Questions tagged [slow-log]
The slow-log tag has no usage guidance.
17
questions with no upvoted or accepted answers
3
votes
0
answers
544
views
Modify slow query log rotation on Amazon RDS instance
Our Amazon RDS instance rotates slow logs every hour, and keeps only the last 20 of them.
This is not optimal for monitoring as it prevents us from seeing any slow query that might have been ...
- 1,324
3
votes
0
answers
2k
views
amazon rds logs all queries
I have enabled slow query log on Amazon RDS with following configuration.
long_query_time = 0.5
general_log = 0
log_output = TABLE
min_examined_row_limit = 1000
slow_query_log = 1
...
- 263
1
vote
0
answers
142
views
MySQL Percrona 8.0 became suddenly slow until restart mysql
My website today suddenly became slow and all requests were taking about 2 seconds to complete.
Usually it takes like 0.2 second I checked available space on disk and I have a lot.
Memory and CPU ...
- 111
1
vote
1
answer
742
views
MySQL / MyISAM: Queries sometimes very slow, no waiting for lock time
I have a web application using PHP 7.0 and MySQL 5.5.54-0+deb8u1-log.
Occasionally, there are long waiting times in the application, which seem to be related to slow database queries. In the slow ...
- 11
1
vote
1
answer
59
views
MySQL: not quoting WHERE conditions slows query execution
I just ran into a curious issue with MySQL. I had a very slow query, even if properly indexed, which was like this:
SELECT * FROM `tbl1` WHERE `parm1` = 'taleggio' AND `parm2` = 10
As said both ...
- 201
1
vote
0
answers
49
views
Need help in optimizing a Slow Query
I am using userpoints module to provide points for different actions that they do on my site.
mysql> desc userpoints;
+-------------+---------+------+-----+---------+----------------+
| Field ...
- 11
1
vote
1
answer
98
views
mysql upgrade 5.0.45 to 5.1.7 and problem query
Have been working on a migration the past few weeks, and we have run into a mysql specific problem.
After creating a new VM, faster server than the old, we have a query that takes approx 2 seconds on ...
- 19
0
votes
0
answers
126
views
MariaDB SELECT query keeps stuck in one system but not in another
This is the reduced query showing problem:
SELECT
t.*
FROM
transactions t
LEFT JOIN assignments a ON a.transaction_id = t.id
LEFT JOIN users u2 ON u2.id = a.user_id
WHERE (
u2....
- 103
0
votes
2
answers
83
views
Mysql server running as replica doesn't record the slow queries in the slow query log, even though it's enabled
I am running a MySql 8.0.29 server serving as a replica for another server on an ubuntu 20.04.4 LTS box.
'slow_query_log','ON'
'slow_query_log_file','/var/log/mysql/mysql-slow.log'
'long_query_time', ...
- 427
0
votes
2
answers
79
views
Optimize query to not read all rows in table
I have this in my slow query log.
Slow Query Log
# Time: 2020-03-09T08:42:46.946084Z
# User@Host: admin_admin[admin_admin] @ localhost [127.0.0.1] Id: 16
# Query_time: 0.001558 Lock_time: 0....
- 101
0
votes
1
answer
70
views
Unexpected slow queries
Using LEMP on popular cloud-service virtual server, with MyISAM tables.
The problem is that sometimes once in few hours simple mysql queries (select from where) executing several seconds (5-9) ...
- 1
0
votes
0
answers
284
views
mysql.rds_history query locked for 70 seconds
SELECT count(*)
from mysql.rds_history
WHERE action = 'disable set master'
GROUP BY action_timestamp,called_by_user,action,mysql_version,
master_host,master_port,master_user,...
- 101
0
votes
2
answers
400
views
Block certain queries from being logged in slow query log
I have mysqld_node running on my mysql server to get statistics to be used by grafana + prometheus to graph dashboard for this MySQL server. However, i noticed that 90% of the queries in my slow query ...
- 23
0
votes
1
answer
2k
views
Periodically very slow execution of simplest queries
Inspecting MySQL slow query log I found out that in certain periods of time there are a bunch of queries in log which are supposed to be very fast but were actually very slow.
For example:
# User@...
0
votes
0
answers
366
views
Slow queries while using views in MySQL
We have MyISAM tables on MySQL 5.5 and there is this select * from theView where serial_number = 'QWE12345' or select * from theView where user_id = 1234 kind of queries when searching. When I ...
- 3,049
0
votes
3
answers
262
views
Identifying root cause of slow query outliers from pt-query-digest?
I've run pt-query-digest and noticed many outliers with very high query times. Many of these queries do not perform slowly when I run them myself, and I'm having trouble figuring out the root cause of ...
- 133
-1
votes
1
answer
106
views
Mysql: slow down with order by, global database problem
i create nasty query for testing reasons. Only for speed testing.
EXPLAIN SELECT m.post_id
FROM wp_postmeta m
LEFT JOIN wp_postmeta mi ON
m.`post_id` = mi.`post_id`
LEFT JOIN wp_postmeta md ON
(md.`...
- 99