We have a large tables with millions of entrys. A full count is pretty slow, see code below. Is this quite common for a MySQL InnoDB table? Is there no way to accelerate this? Even with the query c...

Hi i am working on MySQL version 5.5, can somebody please help me to clear/flush data from mysql.slow_log tables in mysql ?

I'm having some difficulty coming up with correct syntax to pull in specific host information for my slow query log file: I'm using the following: sudo pt-query-digest mysql-slow.log --since "201...

I'm trying to enable Slow Query Logging on mysql 5.7 and getting this error: 2016-04-27T14:55:51.934612Z 0 [ERROR] unknown variable 'log-slow-queries=/var/log/mysql-query.log' 2016-04-27T14:55:51...

I'm using the RDS database from amazon with a some very big tables, and yesterday I started to face 100% CPU utilisation on the server and a bunch of slow query logs that were not happening before....

Why can't I use slow_query_log on MySQL 5.6 on CentOS 6.4? [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock ... ## Logging ## *** THESE LOGS WORK JUST FINE *** log_error = /var/l...

So my understanding of slow query log is that it logs info about all those queries that took >= time (in secs) that we have set in my.conf file. Now lets take 3 cases of 3 different SELECT queries...

this is the query for Unified Medical Language System(UMLS) to find a word related to normalized word. this query result is 165MS, but if I am running VIEW of this same query it is taking 70 sec. I...

I am using MySQL version 5.1.66. I saw that the long_query_time variable is dynamic, but when I tried set GLOBAL long_query_time=1; After the above operation again I tried mysql> show vari...

I'm having an issue where MySQL seems to be logging queries in the slow query log that are faster than the time specified. I've configured MySQL to log the following: Server version: 5.1.54-...