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.

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

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

  1. il15

    il15 Member

    Joined:
    Dec 9, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. il15

    il15 Member

    Joined:
    Dec 9, 2011
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I used this guide to move mysql to /home: http://syslint.com/syslint/how-to-s...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 [~]#
     
Loading...

Share This Page