Computing.Net > Forums > Database > mysqld-nt.exe consumes most of CPU

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

mysqld-nt.exe consumes most of CPU

Reply to Message Icon

Name: lvilledasps
Date: May 22, 2008 at 15:31:33 Pacific
OS: 2003 Server Web Edition S
CPU/Ram: Pentium D 3.0 Ghz 2 Cores
Product: Dell / No idea
Comment:

I have a webpage setup with PHP, Apache and MySQL.
Lately, the process mysqld-nt.exe is almost always using the 50% of the CPU (I guess consuming one of the two cores), and the Database performance overall is quite slow.

And sometimes, a quite big query is executing and only the 50% of the CPU is being used and I think that it should use all the available resources to make the querys faster.

Is there anything I can do to improve this situation?

I tried to "Optimize" all the DB, and "Repair" some of the tables that are quite big.



Sponsored Link
Ads by Google

Response Number 1
Name: foxyshadis
Date: June 16, 2008 at 15:40:53 Pacific
Reply:

You're just going to have to learn how to use SQL better and fix your queries. If you want good targeted help, you'll need to explain the layout of the database and show us your sql queries and stored procedures. One of the best places to start is the optimization chapter in MySQL's manual; beyond that you'll need a good book on SQL, database design, optimization, and integration. You will likely need to change your PHP to use the database better - most PHP sites are pretty naively coded.

Things you can do without the mental effort:
Update mysql to 5.0 or 5.1.
Update to the alpha 6.0 for multithreading (but beware of alpha crashes!).
Upgrade your CPU to a core2.
Switch to a faster database engine, like postgresql, which is long since multithreaded.

-foxyshadis


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: mysqld-nt.exe consumes most of CPU

Batch to fill a csv column with text www.computing.net/answers/dbase/batch-to-fill-a-csv-column-with-text/607.html

Acess 2003 Prices www.computing.net/answers/dbase/acess-2003-prices/294.html

automatically fill related fields www.computing.net/answers/dbase/automatically-fill-related-fields/227.html