sploofus Posted February 23, 2006 Share Posted February 23, 2006 I am running PHP 4.3.9 and MySQL 4.1.10.I have several DB calls, all with proper PHP syntax, in any given page. With only a few users on the site, my processor usage immediately spikes to 99.9%, and the average load is like 62.4, 54.1, 59.0!This never happend to me using the same scripts with MySQL 3.23 and PHP 4.1The server is running RHE4, 3.0 GHz P4 and 2 GB RAM. The hosting company is telling me that my DB queries are being pushed out into memory and that is causing the processor to get overloaded. Is this something new in 4.1? Any suggestion?Help please!Thanks! Quote Link to comment Share on other sites More sharing options...
wisewood Posted February 23, 2006 Share Posted February 23, 2006 are you using select * from 'table' or specifying only the fields you need for each query? selecting for example...SELECT field1, field2, field3 FROM tablethis can use much less cpu & memory Quote Link to comment Share on other sites More sharing options...
sploofus Posted April 6, 2006 Author Share Posted April 6, 2006 You have a corrupt MySQL table. Run a myisamchk on your tables. Your processor and load average is being eaten by MySQL attempting to rectify a corrupted table. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.