Why is my mysql such a cpu hog??? - GoFuckYourself.com

-=HOAX=- · 06-18-2002, 06:21 PM

I have a box running agsql and ePowerTrader and my mysql is taking up like 97% of my cpu...

I have a friend with a very similar setup and about the same amount of traffic and he's only doing 4-5%

Why is this box so pegged?

Pipecrew · 06-18-2002, 06:24 PM

switch to AGPRO sooo much better and quicker, EpowerTrader wasnt coded for efficiency

AdultWire · 06-18-2002, 06:34 PM

MySQL is considered a very fast (effecient) database, if programmed correctly. The problem is the program that's using it.

Mr.Fiction · 06-18-2002, 06:44 PM

You need to configure MySQL for the applications that you're running.

Do a search on my.cnf (the config file) and then make some changes. It can do wonders for the stability and speed of your database server.

Also, memory is very important to MySQL.

Mr.Fiction · 06-18-2002, 06:45 PM

One more thing - you can turn on slow query logging in MySQL and see which queries are taking the longest to execute. From that you can often figure out what some of the problems might be and try to optimize the lame queries.

-=HOAX=- · 06-18-2002, 07:06 PM

FUCK! Now I gotta go learn shit....aaaargh...

Platinum Dan · 06-18-2002, 08:08 PM

-=HOAX=-

I am not sure how technical you are but if you have a friend that is using the same software and their database is only using 5% CPU ... that would lead me to believe one of two things (or both)

1. You have a lot more data ... and need to index your database tables.

and

2. You need to index your database tables.

Indexing alone can change query speed to 90%.

Hope this helps

zubr · 06-18-2002, 08:10 PM

cause looking for a string in MySQL takes an instance, and looking for a string in a text file may take a while. It's a technology designed for immediate response at any cost.

skazzel · 06-18-2002, 09:41 PM

-=HOAX=-,

MySQL is a very fast database. Sounds like one of two things is happening. Either your tables are not indexed properly for the queries you are running on them, or your system is running low on free memory causing MySQL to start swapping to disk which will *greatly* slow it down and cause a sort of thrashing symptom.

If you'd like, I can take a look at your system for you if you want to get in touch with me and give me a (non-root) login. My day job is a supercomputer sysadmin, so stuff like this is usually a piece of cake!

-skazzel

-=HOAX=- · 06-18-2002, 09:44 PM

ICQ#126813938

I'll let you pee on Kman...hook me up...

foe · 06-18-2002, 10:17 PM

Quote:

Originally posted by Platinum Dan
-=HOAX=-

I am not sure how technical you are but if you have a friend that is using the same software and their database is only using 5% CPU ... that would lead me to believe one of two things (or both)

1. You have a lot more data ... and need to index your database tables.

and

2. You need to index your database tables.

Indexing alone can change query speed to 90%.

Hope this helps

The program if its half decent should index the tables for you automaticly.

foe · 06-18-2002, 10:19 PM

Again, you should not try to reindex mysql queries by yourself especially considering that you stated that you dont have large knowledge of mysql Indexing will make your tables bigger and will actually slow down insert and update queries. So proceed with caution

foe · 06-18-2002, 10:24 PM

Quote:

Originally posted by Mr.Fiction
You need to configure MySQL for the applications that you're running.

Do a search on my.cnf (the config file) and then make some changes. It can do wonders for the stability and speed of your database server.

Also, memory is very important to MySQL.

This would be your best bet if you want to continue using the same program. 90% of people dont play around with mysql config and just do default instillation. Proparly configuring mysql can reduce system resources by upto 30% depending on what mysql is doing. Some additional stuff you shoudl consider

Memory as mentioned shoudl be number one.

Additional switchign to a better harddrive preferably scsi

well http://wdvl.internet.com/Authoring/D...timize2_1.html is a decent tutorial that should get you started, message me if your interested in book recomendations etc.

boldy · 06-19-2002, 12:54 AM

Sometimes my boxes are doing 800 queries AVG per second.
Then both of my cpu's are at 70-80% but never over 90%

Your problem might be a fucked up index somewhere, try to optimize your tables. using the optimize tables command

B.

Barry Porn · 06-19-2002, 12:59 AM

Remove ePower, the problem will go away.

It doesn't drop MySQL connections.

06-18-2002, 06:34 PM	#3
AdultWire Confirmed User Join Date: Feb 2002 Location: Toronto, ON Posts: 962	MySQL is considered a very fast (effecient) database, if programmed correctly. The problem is the program that's using it. __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

06-18-2002, 07:06 PM	#6
-=HOAX=- Confirmed User Join Date: Dec 2001 Location: CrackYaMental Posts: 4,365	FUCK! Now I gotta go learn shit....aaaargh... __________________ Insert Value Here.

06-18-2002, 08:08 PM	#7
Platinum Dan Registered User Join Date: Nov 2001 Posts: 38	-=HOAX=- I am not sure how technical you are but if you have a friend that is using the same software and their database is only using 5% CPU ... that would lead me to believe one of two things (or both) 1. You have a lot more data ... and need to index your database tables. and 2. You need to index your database tables. Indexing alone can change query speed to 90%. Hope this helps __________________ Platinum Dan $40.00 a signup, 80% Revenue Share, Earn Platinum Rewards points with each signup.

06-18-2002, 08:10 PM	#8
zubr Confirmed User Join Date: Jan 2002 Location: Toronto Posts: 1,227	cause looking for a string in MySQL takes an instance, and looking for a string in a text file may take a while. It's a technology designed for immediate response at any cost. __________________ Alex - ICQ:61889253 - MSN:zubr_zubr at hotmail.com - Skype:zubrzubr

06-18-2002, 09:44 PM	#10
-=HOAX=- Confirmed User Join Date: Dec 2001 Location: CrackYaMental Posts: 4,365	ICQ#126813938 I'll let you pee on Kman...hook me up... __________________ Insert Value Here.

06-18-2002, 06:21 PM	#1
-=HOAX=- Confirmed User Join Date: Dec 2001 Location: CrackYaMental Posts: 4,365	Why is my mysql such a cpu hog??? I have a box running agsql and ePowerTrader and my mysql is taking up like 97% of my cpu... I have a friend with a very similar setup and about the same amount of traffic and he's only doing 4-5% Why is this box so pegged? __________________ Insert Value Here.

06-18-2002, 06:24 PM	#2
Pipecrew Master of Gfy.com Industry Role: Join Date: Feb 2002 Posts: 14,887	switch to AGPRO sooo much better and quicker, EpowerTrader wasnt coded for efficiency

06-18-2002, 06:44 PM	#4
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	You need to configure MySQL for the applications that you're running. Do a search on my.cnf (the config file) and then make some changes. It can do wonders for the stability and speed of your database server. Also, memory is very important to MySQL.

06-18-2002, 06:45 PM	#5
Mr.Fiction Confirmed User Join Date: Feb 2002 Location: Free Speech Land Posts: 9,484	One more thing - you can turn on slow query logging in MySQL and see which queries are taking the longest to execute. From that you can often figure out what some of the problems might be and try to optimize the lame queries.

06-18-2002, 09:41 PM	#9
skazzel Confirmed User Join Date: Jun 2002 Location: Tampa Posts: 270	-=HOAX=-, MySQL is a very fast database. Sounds like one of two things is happening. Either your tables are not indexed properly for the queries you are running on them, or your system is running low on free memory causing MySQL to start swapping to disk which will greatly slow it down and cause a sort of thrashing symptom. If you'd like, I can take a look at your system for you if you want to get in touch with me and give me a (non-root) login. My day job is a supercomputer sysadmin, so stuff like this is usually a piece of cake! -skazzel

06-18-2002, 10:19 PM	#12
foe Confirmed User Join Date: May 2002 Location: CT Posts: 5,246	Again, you should not try to reindex mysql queries by yourself especially considering that you stated that you dont have large knowledge of mysql Indexing will make your tables bigger and will actually slow down insert and update queries. So proceed with caution

06-19-2002, 12:54 AM	#14
boldy Macdaddy coder Industry Role: Join Date: Feb 2002 Location: MacDaddy pimp coder Posts: 2,806	Sometimes my boxes are doing 800 queries AVG per second. Then both of my cpu's are at 70-80% but never over 90% Your problem might be a fucked up index somewhere, try to optimize your tables. using the optimize tables command B. __________________ MacDaddy Coder.

06-19-2002, 12:59 AM	#15
Barry Porn Confirmed User Join Date: Oct 2001 Location: New Jersey Posts: 257	Remove ePower, the problem will go away. It doesn't drop MySQL connections.