I'm trying to restart my mysqld process on CentOS 6.6. I have root access to the server and when I run top
, this is the first line:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3874 mysql 15 0 2859m 336m 7188 S 120.5 16.4 74730:50 mysqld
Clearly there is an issue there (and I may need to increase the DB server since it's maxing out) but the first step I want to take is to put the process through a power cycle to restart it since it hasn't been restarted in a very long time.
I've tried as root to do many different processes:
service mysqld restart (I get service not found)
If I run which mysqld
I get /usr/sbin/mysqld
. I tried:
/usr/sbin/mysqld restart
That didn't work. I tried:
/etc/init.d/mysqld restart
That didn't work. Do I need to be logged in as the mysql user to do this? I figured root would be able to do this but I guess I just can't find the correct way to restart the server.
Thanks for your help!
killall mysqld
first? Orkillall -s 9 mysqld
./etc/init.d
? what error did it throw (if any?)