… the slow query log. Fixed by making Rows_read to be a synonym for Rows_examined in the slow query log. Bug fixed #830286 (Alexey Kopytov). Fixed… a transaction. Bug fixed #1070856 (Alexey Kopytov). Values for Rows_sent and Rows_read would be identical in the Slow Query Log. This bug was introduced when slow_extended.patch was ported to Percona Server 5.5. Fixed by making…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query… both slow_query_log = OFF and userstat_running = OFF we have no performance penalties of using of patches. Also we fixed potential memory…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set to microseconds. Bug fixed #887928 (Laurynas… the query plan information were being logged even if they weren’t enabled for the slow query log. Bug fixed #730173 (Laurynas Biveinis). Fixed the…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…: pt-query-digest fails to parse timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query_log… erroneous report. Now such no-query events show up in reports as “/* No query */“. Fixed bug 1078838: pt-query-digest doesn’t parse general…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…_time_distribution in Response Time Distribution. (Oleg Tsarev) Bugs Fixed Bug #643149 – Slow query log entries were not written in the usual parsing… crash or undefined behavior: log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev) Bug…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… fixed: #695906 (Yasufumi Kinoshita) Old variable enable_query_response_time_stats was renamed to query_response_time_stats. (Oleg Tsarev) Existing variable log_slow… Slow Query Log page. (Oleg Tsarev) Other Changes Additional information was added to the LOG section of the SHOW STATUS command. Bug fixed…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… FROM users WHERE featured=1) Some day this should be fixed however but do not expect it soon. Use Indexes This… is very important to fix it. Most applications I have to fix have number of indexing missing which requires queries to do full… for your queries, especially if you see them in slow query log. If you have trouble understanding EXPLAIN or optimizing your queries remember we…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… is very important to fix it. Most > applications I have to fix have number of indexing missing which > requires queries to do full… for your queries, especially > if you see them in slow query log. If you have trouble understanding > EXPLAIN or optimizing your queries remember > we… and disk. Because indexes are fast by storing them as fixed-width data (think of converting your varchars to chars for…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…_slow_timestamp_every was renamed to slow_query_log_timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query…was renamed to innodb_corrupt_table_action. (Yasufumi Kinoshita) Bug Fixes Bug #724674 – Ported an updated version of the original …
Post: Announcing Percona Server for MySQL 5.5.30-30.1
March 7, 2013 By Leave a Comment
… slow log stats accounting even with the slow log disabled. Bug fixed #1123915 (Alexey Kopytov). Optimization cleanup to avoid calls related to extended slow query log stats when this feature is disabled. Bug fixed…
