… often see for simple queries due to generally fatter code. The problem in both cases was MySQL 5.0 broken group commit… 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…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… microsecond logging in the slow query log, and extended statistics in the same log. I logged a couple gigabytes of queries at 0-second threshold (all queries… improvements to the MySQL source code are necessary. But in many cases something can be done, such as disabling or reconfiguring some…
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 is …
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 bug…_creation has been introduced for enabling or disabling this feature. #858945 (Alexey Kopytov). Bugs Fixed…). 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: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL …or even more would be good default. query_cache_size = 1M Query cache remains off by default but … alone. Same applies to sync_relay_log and sync_relay_log_info settings. James also promises …
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 glad… 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…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… still need to keep into account possible query changes, replication etc. Q: Is it possible…MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert binary log…MySQL. Our focus on compatibility is indeed so high there are number of great features which are disabled…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). Compatibility Collations Two new collations, utf8_general50_ci… and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM buffer pool can be found here and for… and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused…
Comment: Enabling/Disabling query log without server restart in MySQL 5.0
August 31, 2010 By 13 Comments
… general log file as described in your book. It seems like a nice and clean solution for enabling/disabling query log dynamically on MySQL 5.0 However I’m having the following error: Error 13. Turning logging off for the…
