Re: slow query makes MySQL halt
Posted by:
Erel Segal
Date: February 04, 2009 03:09AM
It's a Linux system.
This is the information I managed to collect:
$ df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/vzfs 60000000 17382216 42617784 29% /
simfs 60000000 17382216 42617784 29% /tmp
simfs 60000000 17382216 42617784 29% /var/tmp
When the system is idle (when the long query doesn't run):
$ top - 01:08:27 up 20 days, 20:23, 1 user, load average: 0.02, 0.04, 0.09
Tasks: 53 total, 1 running, 50 sleeping, 0 stopped, 2 zombie
Cpu(s): 1.8% us, 0.3% sy, 0.0% ni, 93.3% id, 4.6% wa, 0.0% hi, 0.0% si
Mem: 2758032k total, 658148k used, 2099884k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached