MySQL consomme 200% du CPU
* Bonjour, *
Voila ma situation. Un serveur Debian avec 2 Cpu et 8G de ram.
Un site qui me fait des milliers d'insert et que lorsque ma table dépasse les 100 000 Row
Mysql prend plus de 200% du CPU.
Et ce a chaque jour.
Je dois déplacer les données dans un backup pour vider ma table afin de faire tomber le load sur le cpu.
Voici ma config My.cnf
Citation:
# 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]
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
language = /usr/share/mysql/english
log-slow-queries=/var/lib/mysql/slow.log
skip-external-locking
bind-address = 127.0.0.1
skip-name-resolve
skip-locking
skip-innodb
max_connections=150
max_user_connections=100
key_buffer_size = 10G
thread_cache_size = 50
query_cache_size = 128M
query_cache_limit = 4M
tmp_table_size = 48M
max_heap_table_size = 48M
default-storage-engine = myisam
table_open_cache = 5000
table_cache = 5000
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16M
[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=16M
write_buffer=16M
Toute aide de votre part sera appréciée.
Merci
Vay
