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.

Mysql optimization for Cpanel | Ram2 & Cpu Intel(R) Xeon(R) CPU X3460 @ 2.80GHz

Discussion in 'Workarounds and Optimization' started by Amirali, Mar 17, 2013.

  1. Amirali

    Amirali Registered

    Joined:
    Mar 17, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I'm in the process of optimizing my moodle installation/server it has about 7 separate sites of varying usage. Reports and other tasks seem to be timing. looked at my.cnf and noticed it was empty. /etc/my.cnf

    I did a locate and all others i've found haven't had the standard or much info either
    server specs:
    2gb memory
    Intel(R) Xeon(R) CPU X3460 @ 2.80GHz + Intel(R) Xeon(R) CPU X3460 @ 2.80GHz
    I realize my mysqltuner is only for a couple days. i'll certainly post another at the end of this week if it helps get a better baseline of what kind of config would make sense to better utilize the servers possible performance from a sql standpoint.
    thanks much!
     
  2. Amirali

    Amirali Registered

    Joined:
    Mar 17, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Please Help ME
     
  3. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    We cant provide the exact optimized values for MySQL. You can try to start from minimum values and modify according to the traffic/requirement.


    A sample my.cnf will look like above. You can modify this later according to your server performance and mysqltuner output. If you are not sure about this, I would recommend you to hire a administrator.

    Cheers!!!
     
Loading...

Share This Page