… you do in MySQL 5.0 and below ? Use Our Patch – With this patch you 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…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
Post: Announcing Percona Server for MySQL 5.5.30-30.1
March 7, 2013 By Leave a Comment
…id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5.30-30.1[/caption] Percona is …unnecessary 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 …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…from the Percona Software Repositories). Based on MySQL 5.5.16, including all the …creation has been introduced for enabling or disabling this feature. #858945 (Alexey Kopytov). Bugs …Kopytov). The Slow Query Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log-slow-admin-…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…MySQL optimizer choose the appropriate index for a query. If a table’s statistics or index cardinality becomes outdated, you might see queries which previously performed well suddenly show up on slow query log until … I will discuss the effects of disabling the feature and how you or…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… by aggregating query log with mk-query-digest. When I filtered out only queries of this…_hash_index,btr_search_info_update_slow,btr_search_info_update,btr_cur…mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection,handle_one_conne ction,start_thread,clone P.S Disabling…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… thought to be slow down with version …query-digest to compare workloads on servers. Best if you can analyze full query logs…query which performs differently between MySQL Server versions you should: Check Query Plan Run EXPLAIN to see if plans for the query…. You may consider disabling innodb_stats_on…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM buffer pool can be found here and for… / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
…log_warning_1592 option to disable logging of error code 1592. Added the –microseconds_in_slow_query_log option to use microsecond precision for the slow query log… with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL-server #589639 Recovery process may hang when tablespaces …
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… often see for simple queries due to generally fatter code. The problem in both cases was MySQL 5.0 broken group commit… would see very strange behavior on 5.0 of MySQL being slow but few queries being “inside innodb” and potentially even empty queue… so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… = 0 long_query_time = 8 #log-slow-queries = /var/log/mysql-slow-query.log # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links …
