… Server version 5.1.50-rel12.1 RC is now available for download. Functionality Added or Changed Percona Server 5.1.50-rel12.1 is now based on MySQL 5.1.50. New Features Added: innodb_lru… – Corrected wording in an InnoDB error message regarding too many locks printed. (Vadim Tkachenko) Bug #625066 – Fixed a problem handling end…
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
… current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL…. Functionality Added or Changed Percona Server 5.1.52-12.3 is now based on MySQL 5.1.52. New Features Added: HandlerSocket plugin…_status_nolock – Allows examination of slave status even when a lock prevents SHOW SLAVE STATUS from operating. (Oleg Tsarev) Â innodb…
Post: Percona Server 5.1.53-11.7
December 16, 2010 By 2 Comments
Percona Server version 5.1.53-11.7 is now available for download. The main … version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.53-11.7 is now based on MySQL 5.1.53. Â… sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (Alexey Kopytov) Release Notes for this and previous…
Post: Percona Server 5.1.55-12.6
March 7, 2011 By 5 Comments
Percona Server version 5.1.55-12.6 is now available for download. It is … a long time due to excessive locking when innodb_dict_size_limit was non-zero. Locking was relaxed to alleviate this. (Yasufumi…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
Percona Server version 5.1.53-12.4 is now available for download. It is …. Functionality Added or Changed  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added: Precompiled… sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (contributed by Kristian Nielsen) (Alexey Kopytov) Bug #681486…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… of Metadata Locking have not been covered well, and since there are still a large number of MySQL 5.0 and 5.1 installations… the Meta Data Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a statement… Metadata Locking was changed, starting MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL 5.5.3 Starting with 5.5…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… this test. I have compared Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with former being configured… 5 pthread_cond_wait,os_cond_wait,os_event_wait_low,sync_array_wait_event,rw_lock_s_lock_spin,pfs_rw_lock_s_lock…_event_wait_low,sync_array_wait_event,rw_lock_x_lock_func,pfs_rw_lock_x_lock_fu nc,btr_search_build_page_hash…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… no need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign… locks can be different. In the following link there is a good source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it needs to lock the…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… now build against: MySQL 5.1.59, MySQL 5.5.17, Percona Server 5.1.59-13.0 and Percona Server 5.5.16-22.0 and get… for people experiencing problems related to innobackupex holding a write lock for a long time with the normal method of copying… MySQL datadir with rsync (first without a write lock and then with the write lock), we dramatically reduce the amount of time…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… fetching rows mysql tables in use 1, locked 1 9417 lock struct(s), heap size 915896, 696679 row lock(s) MySQL thread id 53173, OS… locked explicitly Innodb “converts” table lock to “no lock” hence eliminating conflicts on MySQL level table locks for most queries. Summary: MySQL Table level locks… locks or auto increment table level lock (mostly with MySQL 5.0 and older MySQL versions). MySQL level locks are entirely different story. Explicitly locking…
