>>>>> "gullov" == gullov <iso-8859-1> writes:
gullov> Hi there.
gullov> I'm having some problems with my mysqld. Under 'heavy' load, the mysql
gullov> server suddenly uses all available system resources for some time, it
gullov> randomly drops connections, and is quite a pain. After a while, it the
gullov> resource consumption drop to normal, and everything is fine again. I
gullov> configured the compilation with the "--with-named-thread-libs=-lc_r" flag.
gullov> Any suggestions? Am I alone? :-)
gullov> My MySQL server version is: 3.22.22
gullov> My OS is FreeBSD/i386 3.1-RELEASE
gullov> | Handler_delete | 33938 |
gullov> | Handler_read_first | 58 |
gullov> | Handler_read_key | 134875 |
gullov> | Handler_read_next | 2233428 |
gullov> | Handler_read_rnd | 702216299 | <----
gullov> | Handler_update | 127038 |
gullov> | Handler_write | 73829 |
gullov> | Key_blocks_used | 783 |
gullov> | Key_read_requests | 975960 |
gullov> | Key_reads | 590 |
gullov> | Key_write_requests | 129238 |
gullov> | Key_writes | 126342 |
The marked line above shows that a big part of your queries requires
rnd (= random access) reads. This is usually and indication that you
have a lot of queries that scans whole tables.
You should check all your querues with 'EXPLAIN' to check where you
could add more keys to get your quieries faster!
PS: Sorry for the late reply; Until 1999-06-01 (when we come back
from USA), my replies may be a bit delayed.