… week, so we are a little slow to blog about this and acknowledge…time resolution for DATETIME and similar time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through …
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…enable logging queries which do not use indexes even if they take less time (–log-queries-not-using-indexes) Slow query log is great to spot really slow queries…specify slow query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time=…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… other is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that run…when no longer necessary (though actually slow log can be disabled by simply setting long_query_time MySQL variable vale high enough)….
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… query to be logged it must match long_query_time AND min_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…log_outputblogpercona.commanual log_queries_not_using_indexesblogpercona.commanual log_short_formatblogpercona.commanual log_slave_updatesblogpercona.commanual log_slow_admin_statementsblogpercona.commanual log_slow_queriesblogpercona.commanual log_slow_slave_statementsblogpercona.commanual log…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… sure you have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time=0, because… like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query_time: 2.365434 Lock_time: 0.000000 Rows_sent…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 …It is interesting though slow query log remained enabled – probably it caused so little overhead because there were no slow queries it just was left …
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
…log-slow-queries=slow.log and –log-output=FILE. Also you need to configure so called long query time. It’s done either with startup parameter –long_query_time…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… can get all queries logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable debug logging live. Note however this is not 100% equivalent for general query log – for…
Post: mk-query-digest, query comments and the query cache
…query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query…