…behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a…closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | …, 0 rows affected (0.09 sec) session1 > insert into t1 values(null); Query OK, 1 …
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… GA release of MySQL 5.6, and I wanted to check if any improvement has been made to the slow query log in… logs on the server. I read the logging code in MySQL 5.6.10 source, in file sql/log.cc. I discovered…,Refresh,Shutdown,Statistics,Processlist,Connect,Kill,Debug,Ping,Time,Delayed insert,Change user,Binlog Dump,Table Dump,Connect Out,Register Slave…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…). Based on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22…. it faster. By reading the rows for “INSERT“, “UPDATE“ and “DELETE“ statements but not updating them… number correctly. #830199 (Oleg Tsarev). Variable log-slow-admin-statements was not listed with SHOW …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). Compatibility… from MySQL 5.0 or 5.1 prior to version 5.1.24. A fix for a MySQL bug (#27877…813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug …
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in … of similar structure with needed index and populate it with insert… select statement as you need it. One little gotcha which… if concurrent insert is always forced for log table if it is allowed or if there is a buffer of slow log…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5…INSERT or UPDATE statement containing BLOB values for a compressed table. This regression was introduced in Percona Server 5.5…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67… Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_…INSERT or UPDATE statement containing BLOB values for a compressed table. This regression was introduced in Percona Server 5…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… is running concurrently. mysqldump itself also slows down about 2x. What is going on…. It is worth to note MySQL actually uses midpoint insertion for its buffer pool replacement …MySQL 5.6 as it would offer much better “out of box” user experience. Summary As we can see in default configuration MySQL…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…? A: I would wonder whenever it is best setup for 5 indexes to differ only by first column. Regarding changing primary… it also can slow down your inserts and make primary key significantly fragmented. I also would note there are some MySQL optimizer restrictions…` = 5” and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5) to ID=5 (for…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
…run update in chunks if application allows it. In MySQL 5.1 with row level replication you will not … query. It is best to avoid INSERT … SELECT going through replication in 5.0 for many reasons (locking, … cases is to simply space it out and slow down your batch job (such as adding sleep calls…
