var/lib/mysql is too full Fermé

Question

Bonjour, 

je gere mon site sur une machine virtuelle sous ec2

depuis ce matin message suivant quand je lance le  serveur qui refuse de lancer mysql

 /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full

en regardant de plus près , effectivement:

ubuntu@ip-10-226-70-64:~$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             9.9G  1.5G  7.9G  16% /
udev                  3.8G  116K  3.8G   1% /dev
none                  3.8G     0  3.8G   0% /dev/shm
none                  3.8G   60K  3.8G   1% /var/run
none                  3.8G     0  3.8G   0% /var/lock
none                  3.8G     0  3.8G   0% /lib/init/rw
/dev/sdb              414G  2.4G  391G   1% /mnt
/dev/sdf             1014M 1014M   20K 100% /ebs

on est à 100% sur dev/sdf

et en regardant dans var/lib/mysql

ubuntu@ip-10-226-70-64:/var/lib/mysql$ ls -al
total 611664
drwxr-xr-x  9 mysql mysql      4096 2010-07-07 06:28 .
drwxr-xr-x 42 root  root       4096 2010-06-29 20:04 ..
-rw-r--r--  1 mysql mysql         0 2010-06-29 20:04 debian-5.1.flag
-rw-rw----  1 mysql mysql 616407040 2010-07-20 22:49 ibdata1
-rw-rw----  1 mysql mysql   5242880 2010-07-20 22:49 ib_logfile0
-rw-rw----  1 mysql mysql   5242880 2010-07-20 22:45 ib_logfile1
drwx------  2 mysql mysql     16384 2010-04-12 15:17 mage
drwx------  2 mysql mysql     16384 2010-07-20 01:05 magique
drwx------  2 mysql mysql     16384 2010-07-05 14:33 magique_dev
drwx------  2 mysql mysql      4096 2010-06-01 16:03 magique_supp
drwxr-xr-x  2 mysql mysql      4096 2010-06-29 20:04 mysql
-rw-------  1 mysql mysql         6 2010-01-11 15:17 mysql_upgrade_info
drwx------  2 mysql mysql      4096 2010-01-11 15:18 phpmyadmin
drwx------  2 mysql mysql      4096 2010-06-29 12:24 sondages


on a le fichier ibdata1 qui fait 615 mega ce qui parait énorme vu la taille de la bdd... en plus ce fichier ne faisait que 100 mega hier

QUESTION: que dois-je faire ? comment remettre de la mémoire dans la partition pour pouvoir lancer mysql ?

désolé je suis assez néophyte..


Merci :-)

Configuration: Windows 7 / Firefox 3.6.7

lami20j · Answer

Salut,

Affiche le résultat de
cat /etc/fstab
mount
cat /etc/my.cnf ou 
cat /etc/mysql/my.cnfet en root
fdisk -l

marsupilami · Answer

Merci :-)

voila les resultats

ubuntu@ip-10-48-18-80:/var/lib/mysql$ cat /etc/fstab
# /etc/fstab: static file system information.
# <file system> <mount point> <type> <options> <dump> <pass>
proc /proc proc defaults 0 0
/dev/sda1 / ext3 defaults 0 0
/dev/sdb /mnt ext3 defaults 0 0
/dev/sdf /ebs xfs noatime 0 0
/ebs/etc/mysql /etc/mysql none bind
/ebs/var/lib/mysql /var/lib/mysql none bind
/ebs/var/log/mysql /var/log/mysql none bind

******************************

ubuntu@ip-10-48-18-80:/var/lib/mysql$ mount
/dev/sda1 on / type ext3 (rw)
proc on /proc type proc (rw)
none on /sys type sysfs (rw,noexec,nosuid,nodev)
none on /sys/fs/fuse/connections type fusectl (rw)
none on /sys/kernel/debug type debugfs (rw)
none on /sys/kernel/security type securityfs (rw)
udev on /dev type tmpfs (rw,mode=0755)
none on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=0620)
none on /dev/shm type tmpfs (rw,nosuid,nodev)
none on /var/run type tmpfs (rw,nosuid,mode=0755)
none on /var/lock type tmpfs (rw,noexec,nosuid,nodev)
none on /lib/init/rw type tmpfs (rw,nosuid,mode=0755)
/dev/sdb on /mnt type ext3 (rw)
/dev/sdf on /ebs type xfs (rw,noatime)
/ebs/var/log/mysql on /var/log/mysql type none (rw,bind)
/ebs/var/lib/mysql on /var/lib/mysql type none (rw,bind)
/ebs/etc/mysql on /etc/mysql type none (rw,bind)
ubuntu@ip-10-48-18-80:/var/lib/mysql$

*************************************

ubuntu@ip-10-48-18-80:/var/lib/mysql$ cat /etc/mysql/my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
# If you make changes to these settings and your system uses apparmor, you may
# also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
#bind-address 79.125.24.68
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
max_connections = 1000
#table_cache = 64
table_cache = 1024
#thread_concurrency = 10
thread_concurrency = 8
#
# * Query Cache Configuration
#
#query_cache_limit = 1M
#query_cache_size = 16M
##opti##
query_cache_limit = 2M
query_cache_size = 64M

##opti##
innodb_buffer_pool_size = 2G
innodb_autoextend_increment = 512

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
# other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

************************************************

rien quand je tape fdisk -l

ubuntu@ip-10-48-18-80:/$ fdisk -l
ubuntu@ip-10-48-18-80:/$

lami20j · Answer

Re,

rien quand je tape fdisk -l 

Il faut le faire en root
Donc sudo fdisk -l

Je vais analyser les résultats un peu plus tard. Je suis au boulot.

marsupilami · Answer

ok !

ubuntu@ip-10-48-18-80:/$ sudo fdisk -l

Disk /dev/sda1: 10.7 GB, 10737418240 bytes
255 heads, 63 sectors/track, 1305 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk identifier: 0x00000000

Disk /dev/sda1 doesn't contain a valid partition table

Disk /dev/sdb: 450.9 GB, 450934865920 bytes
255 heads, 63 sectors/track, 54823 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk identifier: 0x00000000

Disk /dev/sdb doesn't contain a valid partition table

Disk /dev/sdc: 450.9 GB, 450934865920 bytes
255 heads, 63 sectors/track, 54823 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk identifier: 0x00000000

Disk /dev/sdc doesn't contain a valid partition table

Disk /dev/sdf: 2147 MB, 2147483648 bytes
255 heads, 63 sectors/track, 261 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk identifier: 0x00000000

Disk /dev/sdf doesn't contain a valid partition table
ubuntu@ip-10-48-18-80:/$

marsupilami · Answer

aussi , si ca peut aider: message type reçu de mon serveur: 

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Var/lib/mysql is too full

5 réponses