List:General Discussion« Previous MessageNext Message »
From:Scott Pippin Date:May 5 2004 6:52pm
Subject:Re: MySQL 100% CPU Spikes
View as plain text  
>Any information on how I can go about doing this, or maybe some
>documentation on improving the speed.
>The problem is two of the databases I think, both are around 1.1MB
each and:
 
Try putting an explain before your select statement:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
 
this will show you if it is your query that is causing the problem.

>Database1: 13736 data records
>Database2: 77312 data records.

>Is this excessive ?
Not even close.  We currently have a database of 4 gb and 75 tables. 
One of our tables has over 2 million rows.  Even this is small as
compared to some of the other databases I have seen.  Hope this helps.

Scott Pippin
spippin@stripped
 

Thread
MySQL 100% CPU SpikesNick A. Sugiero5 May
  • Re: MySQL 100% CPU SpikesJeremy Zawodny5 May
  • Re: MySQL 100% CPU SpikesNick A. Sugiero5 May
    • Re: MySQL 100% CPU SpikesPeter J Milanese5 May
    • Re: MySQL 100% CPU SpikesSasha Pachev5 May
Re: MySQL 100% CPU SpikesScott Pippin5 May
  • Re: MySQL 100% CPU SpikesPeter J Milanese5 May