We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
HIGH CPU caused by mysql
HIGH CPU caused by mysql
Hello,
I have big cpu caused by mysql, 3 vcores, centos 6 64bits
How to fix this ? If you need some more information just say.
Thanks.
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)
Thanks.
Re: HIGH CPU caused by mysql
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
It's in many cases fat mysql request.
http://dev.mysql.com/doc/refman/5.0/en/ ... slist.html
Re: HIGH CPU caused by mysql
I add in terminal:skurudo wrote: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
Code: Select all
SHOW FULL PROCESSLIST
Thanks.
Re: HIGH CPU caused by mysql
It's for mysql console, login to the console first
mysql -uroot -puserpassword
mysql -uroot -puserpassword
Re: HIGH CPU caused by mysql
Hello,skurudo wrote:It's for mysql console, login to the console first
mysql -uroot -puserpassword
i login with root in terminal do:
Code: Select all
mysql
Code: Select all
SHOW FULL PROCESSLIST
Thanks.
Re: HIGH CPU caused by mysql
SHOW FULL PROCESSLIST;