The slow-log tag has no wiki summary.
0
votes
2answers
20 views
Mysql slow.log user specific
I use a slow.log logging on my MySQL server, to catch bottlenecks in my script, but at the same time, i use phpmyadmin on this server. My script and pma has different MySQL user accounts and now, when ...
0
votes
0answers
12 views
Mysql slow.log with noindex, but without tmp_tables
Is it possible to change anything in config to logging in slow log queries without index use, but not in the temporary tables. I have a lot enough subquerys, so it creating anytime temporary table, ...
1
vote
1answer
61 views
Fast query, in theory using index, still in the slow-query log
I'm having a hard time interpreting the EXPLAIN results of these queries. They both end up in the slow-query log, but the execution time is ~0.0050ms and the final result set is always under 100 rows.
...
-1
votes
2answers
50 views
format of mysql query log
What is the format of the mysql query log? In particular, for lines like:
133 Query commit
133 Query rollback
What does '133' stand for? And is it true that each line represents a round ...
2
votes
1answer
144 views
Innodb Slow queries since convert from MyISAM
a few days ago we converted some write intensive tables from MyISAM to InnoDB hoping to have a better performance due the better locking system of InnoDB, but instead of gain performance, we start to ...
0
votes
1answer
116 views
Creating the MySQL slow query log file
What do I need to do to generate the slow logs file in MySQL?
I did:
log_slow_queries = C:\Program Files\MySQL\MySQL Server 5.1\mysql-slow.log
long_query_time = 1
What more do I need to do ...
2
votes
1answer
80 views
Slow Queries Not Logging
I am attempting to enable slow query logging on our server in order to identify any queries that could use optimization. Sounds simple enough, however my file is not being written to. I get no errors ...
0
votes
1answer
78 views
Mysql. Block/disconnect slow queries
I am experiencing issue.
Someone 'attacked' my server: simply by searching the same phrase with multiple requests.
As it is text search request and database indices are not used, the engine searches ...
0
votes
1answer
257 views
Update to session table slow
I have a number of websites with session tables on a web server, these are used by Joomla CMS and Symfony framework systems. With slow_query_log=0.6, the update queries for the session tables come up ...
1
vote
1answer
35 views
simple query is not using indexes
My query is not using indexes.
it was taking around 5 seconds.
output is 500 rows only. it is a simple query
Please find the explain plan and table structure here.
Explain Plan
mysql> explain ...
0
votes
2answers
192 views
How often does the slow_log table get updated in MySQL?
I've changed the long_query_time from 10 secs to 5 secs. I haven't seen any queries logged for a few hours now. Am I supposed to tweak my database for the slow_log table to gets updated more often?
...
1
vote
1answer
173 views
Why would mysql “show global status” query be taking 15 minutes?
I'm reviewing the slow log, and on one of my slaves the average time for SHOW GLOBAL STATUS is 914s.
Any idea how to determine the cause of this?
2
votes
2answers
244 views
Enable slow_query_log tries to write to slow_log.CSV
I'm running MySQL 5.5
I wanted to truncate the slow log file, so I did:
SET GLOBAL slow_query_log = 0;
then truncated the file in filesystem.
But, when I enable it back it fails:
SET GLOBAL ...
3
votes
1answer
497 views
Enabling “log_queries_not_using_indexes” disables “long_query_time”?
I noticed that, in Mysql, when enabling log_queries_not_using_indexes, slow_query_log and long_query_time, the generated slow query log file will contain a lot of queries even if the query time is far ...
0
votes
1answer
58 views
What is stored in mysqld-slow.log?
My MySQL log directory contains the following files:
7.9K mysqld.err-old
4.0G mysqld-slow.log
94 mysql.log
93M mysqld.err
mysqld-slow.log contains a long list of queries with some ...
1
vote
1answer
452 views
MySQL's “slow query” log: strange “Query_time”
I need some help understanding what's going on with my "slow query" log in MySQL. I have set
set global long_query_time=3
and yet this is what I see in the slow query log:
# Time: 120723 9:04:38
...
0
votes
1answer
83 views
Reviewing all new MySql queries on staging environment
The problem I am trying to solve: It's well known that not all developers know what is EXPLAIN in MySql, and not every knows how to use it. Large part of them consider MySql as a black box, no matter ...
0
votes
1answer
156 views
MySQL query took 98 seconds to run but EXPLAIN looks okay
I have a query that took 98 seconds to execute this morning, but I can't recreate the problem now, and the EXPLAIN output isn't giving me any clues. Am I missing something?
Here's the SQL:
SELECT ...
1
vote
1answer
568 views
Transaction Lock Timeouts When Updating a Row
I'm trying to determine the cause of an InnoDB transaction lock timeout. This one is very strange in that it appears to be a deadlock error instead - nonetheless, here's the output of my slow log ...
1
vote
1answer
756 views
MySQL flush logs, unknown error
I gave been trying to solve this for few days now, and cant seem to figure this out.
I have been trying to set log rotation for mysql slow using linux logrotate feature, and my script seems to get ...
1
vote
1answer
164 views
time executing inserts + slow SSH
_ Hello,
my setup is a slow SSH to some linux machine. From there I start a mysql terminal client and execute about 200k inserts (in a while loop inside a stored procedure). This takes about 3 hours ...
3
votes
3answers
1k views
MySQL slow log configuration
Is there a way of making MySQL slow logs to start new log file every day ?
At the moment its just a single large file, and have to grep lines for every day. It would be much more convenient to have ...
2
votes
2answers
362 views
MySQL: Slow log; append CPU usage
I have the MySQL slow log feature enabled: http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
But sometimes the query_times are high simply due to high CPU load.
How can I append the current ...
2
votes
2answers
1k views
Write a slow query to test slow query logging?
Is there a simple query that would take > 2 sec so that I can test the slow query logger?
I am looking for something like a generic recursive or iterative statement.
2
votes
5answers
378 views
Help optimizing query in the MySQL slow-query log
Our database is set up so that we have a credentials table that hold multiple different types of credentials (logins and the like). There's also a credential_pairs table that associates some of these ...
2
votes
5answers
1k views
MySQL slow query log: huge query time, no lock time, minuscule number of rows scanned
I have a slow query log item with the following:
Query_time: 55 Lock_time: 0 Rows_sent: 739 Rows_examined: 739
No one in my group can explain it besides a guess about packet loss. Is there a ...
4
votes
2answers
790 views
MySQL Slow Query Log - SELECT /*!N SQL_NO_CACHE */
Using mysqldumpslow, I can see that the most common entries in a MySQL slow query log are of the following form:
SELECT /*!N SQL_NO_CACHE */ from wp_posts (or wp_comments).
I can't seem to find ...
6
votes
5answers
1k views
Where can I find the mysql slow log?
Just as the title says, where can I see it ?
Are there any config options for it ( like how many ms would determine if a query is slow or not ) ?
