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

[il15]

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:

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,

 

[cPanelMichael]

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.

 

[il15]

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.

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 [~]#

 

[cPanelMichael]

You may also want to review this thread:

Troubleshooting High Loads On Linux Systems

Thank you.