List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 20 1999 9:04pm
Subject:Re: mysqld problem
View as plain text  
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
Thread
mysqld problemUlrich Gulløv20 May
  • Re: mysqld problemDan Nelson20 May
  • mysqld problemMichael Widenius24 May
Re: mysqld problemDan Nelson21 May