|
|
Posted by O.L. on 12/01/06 10:30
Hello,
On my LAMP webserver, I noticed that sometimes the MySQL daemon uses
99.99% of the CPU, and does not answer SQL queries, while several
minutes.
Does someone know what could be the causes ?
I searched on MySQL.com forums, and I found answers about query cache,
but this is not enabled on my server.
I looked the process list (SHOW FULL PROCESSLIST) :
- almost all the queries where "Locked"
- almost all queries where SELECT
- there was no "difficult" query (big UPDATE or big DELETE or REPAIR or
OPTIMIZE ...)
My database is mainly used with the 'members' table which contains
100000+ records, and a lot of INDEXes. All the queries shown in the
process list were about this table.
Any idea ? Any solution to prevent this periodical server lag ?
Thanks in advance for your help :)
Olivier (and excuse my bad english !)
--
Olivier Ligny
Créateur web free-lance / www.cyber-tamtam.net
Navigation:
[Reply to this message]
|