Jump to content

Archived

This topic is now archived and is closed to further replies.

sploofus

PHP/MySQL DB Calls are eating my CPU!

Recommended Posts

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.1

The 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!

Share this post


Link to post
Share on other sites
are you using select * from 'table' or specifying only the fields you need for each query? selecting for example...

SELECT field1, field2, field3 FROM table

this can use much less cpu & memory

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.