Limit issue

Portal Home > Knowledgebase > Articles Database > Limit issue

Posted by ahmadtrco, 11-11-2013, 08:44 AM
can any one tell me please what is this issue? and what is its solution?, I fund in log and its consuming server CPU load more than 15% ============ /usr/sbin/mysqld --basedir/usr --datadir/var/lib/mysql --plugin-dir/usr/lib64/mysql/plugin --usermysql --log-error/var/lib/mysql/server.domain.com.err --open-files-limit31980 --pid-file/var/lib/mysql/server.domain.com.pid --socket/var/lib/mysql/mysql.sock ===========
Posted by net, 11-11-2013, 09:05 AM
Install mytop so you can monitor which databases are causing this problem.
Posted by ahmadtrco, 11-11-2013, 10:17 AM
Is it free link?
Posted by hackman, 11-12-2013, 07:36 PM
http://jeremy.zawodny.com/mysql/mytop/ And if you are using Percona MySQL or MariaDB, you can check the information in the _STATISTICS tables in the information_schema.
Posted by Kailash12, 11-13-2013, 12:51 AM
Most probably you have lots of open connection or some large dbs which are consuming more CPU. As suggested, install mytop to monitor the running mysql process via SSH.
Posted by ahmadtrco, 11-17-2013, 08:15 AM
I have installed now i can see some connections sleep so what i need to do to save from sleep connections and stop them
Posted by nixtree, 11-17-2013, 09:20 AM
15% of single CPU? That can be quite normal for MySQL process.