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!

I moved mysql to /home and now is overload my server

Discussion in 'Database Discussion' started by il15, May 14, 2015.

  1. il15

    il15 Member

    Joined:
    Dec 9, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Hello,

    I had root partition at 100% so I moved mysql to /home. Everything works ok, but my server is overload.

    When I make HTOP I can see this:

    Code:
    PID USER      PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command                                                                                                                                                                                                                                                             
    29939 mysql      20   0  911M  544M  6616 S  9.9  2.3  2:21.36 /usr/sbin/mysqld --basedir=/usr --datadir=/home/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/home/mysql/ks313093.domain.com.err --open-files-limit=10000 --pid-file=/home/mysql/ks313093.domain.com.pid
    2344 mysql      20   0  911M  544M  6616 S  1.4  2.3  0:01.82 /usr/sbin/mysqld --basedir=/usr --datadir=/home/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/home/mysql/ks313093.domain.com.err --open-files-limit=10000 --pid-file=/home/mysql/ks313093.domain.com.pid
    29965 mysql      20   0  911M  544M  6616 S  1.4  2.3  0:08.39 /usr/sbin/mysqld --basedir=/usr --datadir=/home/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/home/mysql/ks313093.domain.com.err --open-files-limit=10000 --pid-file=/home/mysql/ks313093.domain.com.pid
    2370 mysql      20   0  911M  544M  6616 S  0.9  2.3  0:02.03 /usr/sbin/mysqld --basedir=/usr --datadir=/home/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/home/mysql/ks313093.domain.com.err --open-files-limit=10000 --pid-file=/home/mysql/ks313093.domain.com.pid
    
    
    Can anyone help me, I don't know how to solve this.

    Thank you,
     
    #1 il15, May 14, 2015
    Last edited by a moderator: May 14, 2015
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,435
    Likes Received:
    1,961
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Have you tried restarting MySQL? What instructions did you use to change the partition of the MySQL data directory? Have you tried running "mysqladmin processlist" to get a better idea of which databases are contributing to the usage?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. il15

    il15 Member

    Joined:
    Dec 9, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    I used this guide to move mysql to /home: http://syslint.com/syslint/how-to-safely-change-the-location-of-mysql-data-directory-on-cpanelwhm-servers/

    With mysqladmin processlist I can see this:

    root@ks313093 [~]# mysqladmin processlist

    +-----+------------+-----------+------------------+---------+------+-------+------------------+

    | Id | User | Host | db | Command | Time | State | Info |

    +-----+------------+-----------+------------------+---------+------+-------+------------------+

    | 335 | eximstats | localhost | eximstats | Sleep | 130 | | |

    | 883 | estudio_il | localhost | estudio_estudioi | Sleep | 0 | | |

    | 884 | estudio_il | localhost | estudio_estudioi | Sleep | 0 | | |

    | 885 | root | localhost | | Query | 0 | init | show processlist |

    +-----+------------+-----------+------------------+---------+------+-------+------------------+

    root@ks313093 [~]#
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,435
    Likes Received:
    1,961
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice