CODEWITHSUNDEEP
mysqlperformance
canerkoroglu
canerkoroglu

Reputation: 77

MySql user eating CPU and finally CPU overload

i am using vps server and when i type top always i see code below 

cpu | pid  | user  | command
2.2 | 3954 | mysql | /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/xxx.hostname.com.err --pid-file=/var/lib/mysql/xxx.hostname.com.pid

i dont understand what is this? how can i reduce this value? this is running after restart and never stop.

Upvotes: 0

Views: 1894

Answers (1)

hafichuk
hafichuk

Reputation: 10781

Unless I'm missing something you are running the MySQL (mysqld) database on your VPS.

In terms of the CPU overload, my guess is that something is running a CPU intensive query on it. You can take a look at the slow query log to see if there are any queries that are taking a while (i.e. eating up your CPU).

The log is usually in /var/log/mysql/mysql-slow.log.

Upvotes: 0

Related Questions