HIGH CPU caused by mysql

[vestacp89]

Hello,

I have big cpu caused by mysql, 3 vcores, centos 6 64bits

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=200
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log

#innodb_use_native_aio = 0
innodb_file_per_table

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Code: Select all

+----------------+-------------------+-------------------+-------------------+
| Storage Engine | Data Size         | Index Size        | Total Size        |
+----------------+-------------------+-------------------+-------------------+
| InnoDB         |           1.81 MB |         256.00 KB |           2.06 MB |
| Total          |           1.81 MB |         256.00 KB |           2.06 MB |
+----------------+-------------------+-------------------+-------------------+
2 rows in set (0.08 sec)

How to fix this ? If you need some more information just say.

Thanks.

[skurudo]

In mysql console you can see processlist and detect what load CPU.
It's in many cases fat mysql request.

http://dev.mysql.com/doc/refman/5.0/en/ ... slist.html

[vestacp89]

In mysql console you can see processlist and detect what load CPU.
It's in many cases fat mysql request.

http://dev.mysql.com/doc/refman/5.0/en/ ... slist.html

I add in terminal:

Code: Select all

SHOW FULL PROCESSLIST

but this not work, i use centos 6 ?

Thanks.

[skurudo]

It's for mysql console, login to the console first
mysql -uroot -puserpassword

[vestacp89]

It's for mysql console, login to the console first
mysql -uroot -puserpassword

Hello,

i login with root in terminal do:

Code: Select all

mysql 

and then

Code: Select all

SHOW FULL PROCESSLIST

and not work ?

Thanks.

[skurudo]

SHOW FULL PROCESSLIST;