FAQ by LinKuFF.com

Configuration à modifier selon l'utilisation de vos ressources. La mienne :

key_buffer              = 128M
max_allowed_packet      = 16M

thread_stack            = 256K
thread_cache_size       = 64

max_connections        = 300

table_cache            = 10000
table_definition_cache = 1500

join_buffer_size       = 16M
read_buffer_size       = 7M
sort_buffer_size       = 7M

tmp_table_size         = 128M
max_heap_table_size    = 128M

query_cache_limit       = 25M
query_cache_size        = 500M

innodb_buffer_pool_size  = 300M
innodb_additional_mem_pool_size=32M
innodb_thread_concurrency=2

myisam_sort_buffer_size= 100M

Pendant l'utilisation de MySQL, en cas de pic :

SHOW PROCESSLIST

Puis pour stopper une requête trop gourmande :

KILL QUERY THREAD_ID;