…come in MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at least in more flexible community version. Relaxing Locks Row …Kinoshita did number of interesting benchmarks stress testing other areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully …
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select count(*) from sample where j like “5%” lock in share mode; +———-+ | count(*) | +———-+ | 102216 | +———-+ 1 row in…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
… InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment … a single-row or multi-row INSERT/REPLACE uses a light-weight mutex instead of a table lock on AUTO-…1 and foo.name is null; Query OK, 0 rows affected (0.00 sec) Now check the auto_increment counter:…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… I have started the development of an updated version of the patch. The basic …0.3s! # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL…in production or on any important system! The patch is available for MySQL Community 5.0…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…of SHOW PROCESSLIST. (Laurynas Biveinis) Variable Changes Old status variable innodb_row_lock_numbers was renamed to innodb_current_row_locks…MySQL 5.0 or Percona Server versions prior to 5.1.7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…row in set (6.11 sec) Result well matches one which we got with OPTIMISTIC locking – just instead of simply balling out on first row lock…Mysql | | 2 | Solid | | 3 | MyISAM | +—-+——–+ 3 rows in set (0.00 sec) Conclusion: Current Beta version seems to have number of…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
…in MySQL before 5.1. In MySQL 5.1 this as well as few other problems should be solved by row…of lock structs, which means it has locked a lot of rows. “fetching rows” of course means it is still going. In…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…row in set (0.00 sec) With ICE, after compression there is only 2.5GB of…
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
…_id: 3432 Schema: test # Query_time: 0.000695 Lock_time: 0.000284 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 Rows_read: 1 # QC_Hit: No Full_scan… patch – which is included in all Community tree based Percona MySQL builds since it is part of MySQL community version ever since 5.0.37 (note – not…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…MySQL versions knew only about table locks and were not initially designed to support transactions. Most of…MySQL 5.1 features. During my talks I often asked people how many of them use 5.1 vs row…
