Results 1 to 4 of 4
  1. #1
    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.9
    Last edited by E-Bilisim; 07-24-2009 at 09:44 AM.

  2. #2
    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/

  3. #3
    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.

  4. #4
    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

  1. Replies: 1
    Last Post: 05-07-2009, 12:35 AM
  2. Question about Core2Quad Q9400 (2.66ghz)
    By TheDrunkenGamer in forum Dedicated Server
    Replies: 10
    Last Post: 03-31-2009, 11:50 AM
  3. Quad Core Q9400 from $100 and Atoms from $70
    By nonparity in forum Dedicated Hosting Offers
    Replies: 2
    Last Post: 02-13-2009, 03:06 AM
  4. 9400 quad cores are here! Unmetered Quad Core Q9400, 4GB, 500GB, $169, 99.9% Uptime
    By Northstorm | Kevin in forum Dedicated Hosting Offers
    Replies: 1
    Last Post: 11-24-2008, 11:24 AM
  5. Mysql Overload Problem
    By neuromancer in forum Hosting Security and Technology
    Replies: 1
    Last Post: 06-21-2005, 05:58 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •