Skip to main content

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,

Comments

3 comments

Date Votes
  • 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.
    0
  • 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:
    0
  • cPanelMichael
    You may also want to review this thread: Troubleshooting High Loads On Linux Systems Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post