XFileSharing Pro - mysql cpu high load, how to reduce cpu load.

Message
Author
verzing
Posts: 174
Joined: Mar 02, 2011 7:00 pm

mysql cpu high load, how to reduce cpu load.

#1 Postby verzing » Feb 06, 2012 12:28 pm

My site alway get high load by mysql. Im already turning sql but cpu still high load.
anyone have any idea to reduce cpu load.

thanks

hostlife
Posts: 192
Joined: Aug 13, 2011 12:34 pm

#2 Postby hostlife » Feb 06, 2012 4:04 pm

No one can give any exact solution without checking your server.

Anyway, restart your mysql, make some tweaks & it should work fine. However, it also depends upon your server specs. If you are getting high load & your server cannot handle that, you may need to upgraded your server.

qq_bbq
Posts: 122
Joined: Jul 05, 2009 11:33 pm

#3 Postby qq_bbq » Feb 06, 2012 5:02 pm

First find out if you need to upgrade server or if your mysql is not optimized enough. What is your server specs? How many downloads daily are you getting?

speakerbox
Posts: 73
Joined: Aug 20, 2010 4:39 am

#4 Postby speakerbox » Feb 06, 2012 7:05 pm

Try dumping ip2files if the table is very big is size

glumbo
Posts: 211
Joined: Mar 11, 2011 6:26 am

#5 Postby glumbo » Feb 06, 2012 7:57 pm

Run your mysql on a separate server.

verzing
Posts: 174
Joined: Mar 02, 2011 7:00 pm

#6 Postby verzing » Feb 06, 2012 8:36 pm

My server info:
Total processors: 2

Processor #1

Vendor
GenuineIntel

Name
Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz

Speed
2400.000 MHz

Cache
3072 KB

Processor #2

Vendor
GenuineIntel

Name
Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz

Speed
2933.000 MHz

Cache
3072 KB

Ram: 6G

uplink: 1G


I have 35k to 42k download daily but my server away high load, its realy high when my site have 200 - 300 visit online at once.
I have run main server and file server together on this server. And with 1 vbb forum with 1k page view per day.



does I need to upgrade cpu ?

verzing
Posts: 174
Joined: Mar 02, 2011 7:00 pm

#7 Postby verzing » Feb 06, 2012 8:39 pm

glumbo wrote:Run your mysql on a separate server.
Do you mean run main server on separate server with file server or just remote mysql on separate server ?

speakerbox
Posts: 73
Joined: Aug 20, 2010 4:39 am

#8 Postby speakerbox » Feb 07, 2012 4:06 am

Get a separate server for the front end...

verzing
Posts: 174
Joined: Mar 02, 2011 7:00 pm

#9 Postby verzing » Feb 10, 2012 11:23 am

yeah, just buy a new strong server for sql load. now cpu load in both server are 0.x ,

shareitall
Posts: 29
Joined: Jul 05, 2010 12:08 am

#10 Postby shareitall » Feb 29, 2012 4:53 pm

glumbo wrote:Run your mysql on a separate server.
Does this server have to be connected to the 1st server via local network or will a more powerful server work that is housed in the same datacenter?

ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

#11 Postby ankurs » Mar 01, 2012 8:04 am

shareitall wrote:
glumbo wrote:Run your mysql on a separate server.
Does this server have to be connected to the 1st server via local network or will a more powerful server work that is housed in the same datacenter?
idealy should be connected via cross-connect or private vlan

it can be in same dc, but make sure that traffic between db-web servers is not counted or else you will endup with a big bill