MySQL : Problème mémoire serveur Linux
Bonjour,
J'ai un problème avec un process MySQL qui utilise de plus en plus de mémoire et qui ne la libère pas...
Au bout d'un moment il utilise toute la mémoire disponible sur le serveur...
Version MySQL : 5.1.51
OS : Rhel 5
Voilà ce que me retourne la commande "ps aux" :
xxxxx 12496 4.3 38.9 10832240 9609528 ? Sl Aug05 1448:36 /xxxxx/xxxx/xxxxxx/xxxxxxx/mysqld --defaults-file=/xxxx/xxxx/xxxxx/xxxxxx/my.cnf --basedir=/xxxx/xxxxx/xxxx --datadir=/xxxx/xxxxx/xxxx --user=xxxxx --ssl --log-error=/xxxx/xxxxx/xxxx/error.log --pid-file=/xxxx/xxxxx/xxxx/mysql.pid --socket=/xxxx/xxxxx/xxxx/mysql.sock --port=xxxx
Soit 10Go de Mémoire !
Le problème c'est que hormis que c'est énorme, cela augmente régulièrement jusqu'à saturation complète du système...
Voici mon fichier de configuration my.cnf :
[client]
port = xxxx
socket = /xxxx/xxxxxx/mysql.sock
[mysqld]
port = xxxx
socket = /xxxx/xxxxxx/mysql.sock
pid-file = /xxxx/xxxxxx/mysql.pid
datadir = /xxxx/xxxxxx
tmpdir = /xxxx/xxxxxx/tmp
user = xxxxxx
event_scheduler = ON
character-set-server = latin1
collation-server = latin1_swedish_ci
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 16M
secure-auth
secure-file-priv = /xxxx/xxxxxx
max_connections = 104
max_user_connections = 50
ssl_ca = /xxxx/xxxxxx
ssl_cert = /xxxx/xxxxxx
ssl_key = /xxxx/xxxxxx
server-id = 1
#relay-log = /xxxx/xxxxxx/mysql-relay-bin
#relay-log-index = /xxxx/xxxxxx/mysql-relay-bin.index
#master-info-file = /xxxx/xxxxxx/master.info
#relay-log-info-file = /xxxx/xxxxxx/relay-log.info
#log-slave-updates
#replicate-same-server-id=0
#auto_increment_increment=2
#auto_increment_offset=1
general_log = OFF
general_log_file = /xxxx/xxxxxx/log-general.log
log-bin = /xxxx/xxxxxx/log/bin
binlog_format = mixed
log-error = /xxxx/xxxxxx/log/error.log
slow_query_log_file = /xxxx/xxxxxx/log/slow-queries.log
long_query_time = 4
expire_logs_days = 7
innodb_file_per_table
innodb_data_home_dir = /xxxx/xxxxxx/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /xxxx/xxxxxx/log/
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
#safe-updates
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
Le moteur de stockage de toutes les tables est MyISAM.
Avez-vous une idée de la raison d'une telle consommation de mémoire ?
Ne peut-on pas fixer un "quota" de concommation de la mémoire (ceci afin d'éviter de saturer le serveur) ?
D'avance merci