2

I have a VPS and I am hosting a game site on it. Recently my CPU went to 3000% and memory is going near full.

When I checked the processes I found this process eating the CPU:

Pid-1571 (Trace) (Kill) 
Owner-mysql 
Priority-0 
CPU %-52.7 
Memory %-4.4
Command:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/domain.com.err --pid-file=/var/lib/mysql/domain.com.pid

What does this command do? Why is it running? How do I stop it?

3

This is MySQL, a database engine. I guess your site utilizes a MySQL database and the SQL queries are not optimal or the engine is not properly tuned. Anyway you can't simply stop it because your site will stop too.

1

Depending on distribution, try

service mysql stop

or

/etc/init.d/mysql* stop

Be warned. Shutting it down will put you site offline, as it is the database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.