Mysql is very Slow
Hello
We use a cPanel server with bellow details:
8 core cpu, 48G Ram, HDD SATA2 Enterprise, Load avg : 5
cPanel 11.46, mysql 5.6.16-cll-lve, cloudlinux (cagefs, db_governor), x86_64
Recently Websites speed become very slow, They take at least 10 seconds to respond. (other servers respond less than 1 second)
Static files and pages (php, html, ...) without mysql connection are very fast.
I checked many things, but problem persists yet.
I can not find any slow query in slow.log for websites that have problem.
But these are some slow queries that were run as root:
# Time: 141115 16:38:53
# User@Host: root[root] @ localhost []
# Query_time: 41.181927 Lock_time: 0.000069 Rows_sent: 1 Rows_examined: 128000
use information_schema;
SET timestamp=1416069533;
SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_PAGE`;
# Time: 141115 16:39:35
# User@Host: root[root] @ localhost []
# Query_time: 41.584849 Lock_time: 0.000088 Rows_sent: 1 Rows_examined: 127490
SET timestamp=1416069575;
SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_PAGE_LRU`;
# Time: 141115 16:40:16
# User@Host: root[root] @ localhost []
# Query_time: 11.527568 Lock_time: 0.000141 Rows_sent: 1 Rows_examined: 79
SET timestamp=1416069616;
SELECT data_free FROM tables WHERE ENGINE = 'InnoDB' LIMIT 1;
# Time: 141115 16:40:25
# User@Host: root[root] @ localhost []
# Query_time: 42.337690 Lock_time: 0.000074 Rows_sent: 1 Rows_examined: 128000
SET timestamp=1416069625;
SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_PAGE`;
# Time: 141115 16:41:07
# User@Host: root[root] @ localhost []
# Query_time: 41.486949 Lock_time: 0.000075 Rows_sent: 1 Rows_examined: 127477
SET timestamp=1416069667;
SELECT COUNT(*) FROM `information_schema`.`INNODB_BUFFER_PAGE_LRU`;
-
Hello :) I suggest running a MySQL tuner to see what kind of results you get. The following thread is a good place to start: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you. 0 -
Thank you for your reply I don't know what is the problem, It is very strange problem. Some sites (even with mysql connection) loads very fast and some loads very slow. This command take about 10 ~ 20 seconds to run (mysql command): mysql> SELECT count(*) FROM tables WHERE ENGINE = 'InnoDB'; +----------+ | count(*) | +----------+ | 11182 | +----------+ 1 row in set (22.16 sec)
I think information_schema is the reason.0
Please sign in to leave a comment.
Comments
2 comments