In the last episode (May 20), Ulrich Gull?v said:
> From: Dan Nelson <dnelson@stripped>
> > In the last episode (May 19), Ulrich Gull?v said:
> > > I'm having some problems with my mysqld. Under 'heavy' load, the
> > > mysql server suddenly uses all available system resources for
> > > some time, it randomly drops connections, and is quite a pain.
> > > After a while, it the resource consumption drop to normal, and
> > > everything is fine again. I configured the compilation with the
> > > "--with-named-thread-libs=-lc_r" flag. Any suggestions? Am I
> > > alone? :-)
> >
> > Can you do a "mysqladmin processes" during one of these periods?
>
> Yes, I can get the processlist just fine? You can see it further
> down. Can it be, that the server is too loaded? I'm runneng about 30
> queries/sec on a P2-300 w. 256mb ram ...
>
>
> +-------+------+-----------+------------+-----------+------+--------------+------------------------------------------------------------------------------------------------------+
> | Id | User | Host | db | Command | Time | State |Info|
>
> +-------+------+-----------+------------+-----------+------+--------------+------------------------------------------------------------------------------------------------------+
> | 33636 | root | localhost | top100 | Query | 3 | Sending data |select id
> from hits_18051999 where site_id = 584|
> | 36685 | root | localhost | bannerswap | Query | 38 | Sending data |select id
> from views where ip = 'webprox1.livjm.ac.uk' AND browser ='Mozilla/3.01 (Win16; I)' AND r
> |
> | 36712 | root | localhost | top100 | Query | 9 | Sending data |select
> who,when from hits_tmp where site_id = 551 AND who ='d3o949.telia.com' AND when >
> 927229330 |
> | 36713 | root | localhost | top100 | Query | 9 | Sending data |select
> who,when from hits_tmp where site_id = 380 AND who ='logger.gamma.ru' AND when >
> 927229330 |
> ( 21 total lines like this )
> | 36729 | root | localhost | top100 | Query | 2 | Sending data |select
> who,when from hits_tmp where site_id = 460 AND who ='spider-tm012.proxy.aol.com' AND when
> > |
> | 36730 | root | localhost | top100 | Query | 2 | Sending data |select
> who,when from hits_tmp where site_id = 359 AND who ='spider-wj072.proxy.aol.com' AND when
> > |
> | 36731 | root | localhost | top100 | Query | 1 | Sending data |select
> who,when from hits_tmp where site_id = 359 AND who ='spider-wj031.proxy.aol.com' AND when
> > |
> | 36732 | root | localhost | | Processes | 0 | ||
>
> +-------+------+-----------+------------+-----------+------+--------------+------------------------------------------------------------------------------------------------------+
I find it interesting that all the connections are "sending data".
This makes me think that your application is the bottleneck, not
mysql. You've got an index on "who" or "when", right?
-Dan Nelson
dnelson@stripped
