The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Optimizing Msql for high traffic

Discussion in 'Workarounds and Optimization' started by elitepromo, Apr 22, 2013.

  1. elitepromo

    elitepromo Registered

    Joined:
    Apr 22, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Can Someone help me please. This is my current Mysql setting query.PNG
    the server that i am using is "Intel Xeon E3-1220 V2
    3.1GHz 4 Cores w/o HT" and the website is - removed -

    CAN SOME ONE SHOW ME THE CORRECT SETTINGS TO GET THE MOST OUT OF MSQL, currently my mysql processes are in the high 20's
     
    #1 elitepromo, Apr 22, 2013
    Last edited by a moderator: Apr 22, 2013
  2. STS Admin

    STS Admin Well-Known Member

    Joined:
    Jul 8, 2012
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    cPanel Access Level:
    Root Administrator
  3. thinkbot

    thinkbot Well-Known Member

    Joined:
    Oct 30, 2012
    Messages:
    326
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    run mysqltuner, mysqlreport, tuningprimer

    or mysqlmymonlite and put here the resuts
     
  4. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    INDIA
    cPanel Access Level:
    Root Administrator
    Twitter:
    Its depeneding on your RAM size.. You can optimize the my.cnf settings with many tools...
     
Loading...

Share This Page