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

il15

Member
Dec 9, 2011
6
0
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,
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
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

Member
Dec 9, 2011
6
0
51
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.
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:

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

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

[email protected] [~]#