Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Will moving Mysql to another server reduce load?

Discussion in 'Workarounds and Optimization' started by craigedmonds, Jan 17, 2011.

  1. craigedmonds

    craigedmonds Well-Known Member

    Joined:
    Oct 29, 2007
    Messages:
    112
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Twitter:
    I have a dedicated server which sells shared server space and its running WHM/Cpanel and maybe a couple of times a day the load shoots up to 25+ and I have a script which stops httpd and then restarts when load is back down to 8. The httpd service is only down for 60 seconds or so, not much more but its a bit annoying when it happens.

    The server has quite a few sites on it, maybe 250 or so, varying from wordpress, static etc. The sites are delivered very fast but whilst running TOP - C in SSH I can see mysql user at 6% then 25% then 80% then 33% etc so its fluctuating all over the place.

    Its very difficult to establish exactly which user is causing loads but I am wondering if I should move the mysql databases over to a separate Cpanel server.

    Would this reduce the load significantly? I am assuming that some of the load is from users using the mysql service.

    Thoughts anyone?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 craigedmonds, Jan 17, 2011
  2. rrwh

    rrwh Well-Known Member

    Joined:
    Oct 2, 2004
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    156
    first thing to do is to tune mysql if you have not already done so.
     
    #2 rrwh, Jan 19, 2011
  3. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    5
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Hello,

    You can found which database queries are higher using the command mysqladmin pr. A fine tuning will resolve the issue.
    After that only you need to think about a database server.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 LinuxTechie, Jan 23, 2011
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello Craig,

    We have a script on the 11.28+ machines that you can run to get suggestions for MySQL Optimization:

    Code:
    /usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
    You can simply run that and wait for the output. Any suggestions it provides would be placed into /etc/my.cnf file. I'd suggest running that script once every 24 hours for a few days, then tweaking using the suggestions at that time to see the results.

    I also have a MySQL Optimization presentation that I did at our cPanel Conference last year - MySQL Optimization | cPanel Video Site

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelTristan, Jan 23, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - moving Mysql another
  1. Bidi

    Moving MySQL directory

    Bidi, Aug 19, 2017, in forum: Database Discussion
    Replies:
    1
    Views:
    866
    cPanelMichael
    Aug 22, 2017
  2. Thunderchild

    Moving accounts from one server to another

    Thunderchild, Nov 4, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    81
    cPanelLauren
    Nov 5, 2018
  3. JWolfe

    Moving SQL to another drive

    JWolfe, Oct 23, 2018, in forum: Database Discussion
    Replies:
    10
    Views:
    136
    JWolfe
    Oct 25, 2018
  4. chris0147

    Apache rebuild problem after removing main domain

    chris0147, Oct 18, 2018, in forum: EasyApache
    Replies:
    7
    Views:
    116
    Infopro
    Oct 18, 2018
  5. bdp31770

    Removing and Re-adding Domain and MX Records

    bdp31770, Oct 12, 2018, in forum: E-mail Discussion
    Replies:
    1
    Views:
    87
    cPanelLauren
    Oct 16, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice