List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 24 1999 1:33am
Subject:mysqld problem
View as plain text  
>>>>> "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

<cut>

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    |

Hi!

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!

Regards,
Monty

PS:  Sorry for the late reply;  Until 1999-06-01 (when we come back
     from USA), my replies may be a bit delayed.
Thread
mysqld problemUlrich Gulløv20 May
  • Re: mysqld problemDan Nelson20 May
  • mysqld problemMichael Widenius24 May
Re: mysqld problemDan Nelson21 May