Results 1 to 4 of 4
-
07-24-2009, 09:36 AM #1Junior Guru Wannabe
- Join Date
- May 2005
- Posts
- 38
Quad CPU Q9400 @ 2.66GHz & 8 GB Ram - Mysql Overload Problem
Hello,
My problem is server overload.I think it's a mysql optimization problem. But i dont change any setting.
Core(TM)2 Quad CPU Q9400 @ 2.66GHz
8 GB Ram
http://img32.imageshack.us/img32/2977/server1j.jpg
http://img263.imageshack.us/img263/9905/server2.jpg
http://img258.imageshack.us/img258/6068/server3.jpg
http://img58.imageshack.us/img58/5988/server4.jpg
CENTOS 5.3 i686 standard on server
cPanel 11.24.4-C37008 - WHM 11.24.2 - X 3.9Last edited by E-Bilisim; 07-24-2009 at 09:44 AM.
-
07-24-2009, 12:05 PM #2Junior Guru Wannabe
- Join Date
- May 2008
- Posts
- 43
Use "show full processlist;" in the mysql console (when the server is under load) to see what processes mysql is trying to run. You can also log slow queries. If mysql is running out of memory when building tables, it will have to write them to disk, and that's always a *lot* slower than writing to memory.
Dan Hildebrandt, Developer / Support, WebGroup Media LLC. - http://twitter.com/cerb5
Cerberus Helpdesk 5.x is a CRM toolkit. Remember anything about anybody, swiftly reply to a flood of e-mail,
capture feedback organically, track time, flag opportunities, share tasks, and more. http://www.cerberusweb.com/
-
07-24-2009, 12:42 PM #3Junior Guru Wannabe
- Join Date
- Nov 2003
- Location
- New Jersey, USA
- Posts
- 81
You're not using any SWAP so most likely it's a disk i/o or CPU usage issue.
Web Hosting - Reseller Hosting - VPS - Dedicated Servers - Cloud Hosting - Email Marketing
BuyHTTP, LLC - R1Soft CDP backup and RVsitebuilder included with all shared/reseller plans
Cloud Hosting Truly redundant high available cloud from a trusted name.
-
07-24-2009, 12:42 PM #4Eternal Learner
- Join Date
- Jul 2007
- Posts
- 2,051
Refer the following URL to find out the slow mysql queries.
http://www.cpanelconfig.com/optimize...mysql-queries/
This should help you to detect the query or the database causing heavy load on the server.Prashant T.
Don't run after Success. Run after Excellence and Success will soon follow.
Similar Threads
-
Quad Core Q9400 8 GB RAM 500 GB Disk UNMETERED BW JUST $119.99/m! NO CONTRACT!!!!!!!!
By LinuxStandard in forum Dedicated Hosting OffersReplies: 1Last Post: 05-07-2009, 12:35 AM -
Question about Core2Quad Q9400 (2.66ghz)
By TheDrunkenGamer in forum Dedicated ServerReplies: 10Last Post: 03-31-2009, 11:50 AM -
Quad Core Q9400 from $100 and Atoms from $70
By nonparity in forum Dedicated Hosting OffersReplies: 2Last Post: 02-13-2009, 03:06 AM -
9400 quad cores are here! Unmetered Quad Core Q9400, 4GB, 500GB, $169, 99.9% Uptime
By Northstorm | Kevin in forum Dedicated Hosting OffersReplies: 1Last Post: 11-24-2008, 11:24 AM -
Mysql Overload Problem
By neuromancer in forum Hosting Security and TechnologyReplies: 1Last Post: 06-21-2005, 05:58 PM