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! Link to comment https://forums.phpfreaks.com/topic/3543-phpmysql-db-calls-are-eating-my-cpu/ 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 Link to comment https://forums.phpfreaks.com/topic/3543-phpmysql-db-calls-are-eating-my-cpu/#findComment-12230 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. Link to comment https://forums.phpfreaks.com/topic/3543-phpmysql-db-calls-are-eating-my-cpu/#findComment-24364 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.