…_length: 100253696 Max_data_length: 0 Index_length: 128974848 Data_free: 0 Auto_increment: 1638401 Create_time: 2006-07-12 07:31…: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 1591296 kB 1 row in set… memory: History list length 5 Total number of lock structs in row lock hash table 6092 LIST OF TRANSACTIONS FOR EACH SESSION…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
… InnoDB results acceptable in primary key lookups queries, but secondary indexes were forgotten for some time. Now having Dell PowerEdge R900… NOT NULL default ’0′, PRIMARY KEY (id) ) CREATE INDEX email_idx on sbtest(email); CREATE INDEX country_id_idx on sbtest(country_id,state… is used as mutex even in places where shared read lock is enough – and we replaced page_hash mutex to page…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
… OK table is exposed without indexes for some time. Note though nothing stops you from using LOCK TABLES on Innodb table to ensure there is not ton of queries starting reading table with no indexes and… not know why this was not done when support for creating index by sorting was implemented. It looks very strange to me…
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
…-flushing/ Fix InnoDB index locking Figure out InnoDB adaptive locking issue, e.g: http://www.mysqlperformanceblog.com/2010/02/25/index-lock-and-adaptive-search…-transactional 
Make InnoDB page size setting per tables and per index Specify location of InnoDB tables (e.g: disk or SSD… in general faster on SSD, so we do need to create several instances, like in my recent benchmarks Add more features…
Comment: Introducing tpce-like workload for MySQL
August 19, 2010 By 6 Comments
… provided README files – I have been able to create the database, load the data, create indexes etc. However, when I try to kick… Waiting for Trade-Cleanup transaction finished… safe_mutex: Trying to lock unitialized mutex at my_thr_init.c, line 299 safe… my_thr_init.c, line 299 safe_mutex: Trying to lock unitialized mutex at my_thr_init.c, line 299 Aborted…
Comment: Pitfalls of converting to InnoDB
March 28, 2007 By 16 Comments
… clients (A, B) and the following sequence of statements. A – create table ed (id int unsigned, name varchar(10)) engine=innodb… implicit transaction of an insert/update as well as the index locks (especially foreign keys) acquired. Also, don’t forget that summary… like “update parent set column = column + 1 where primary_key = ##” lock parent’s row until the original statement is completed. Moral…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…, I bumped into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 10099, OS thread id 3771312 starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 320… bits 72 index `PRIMARY` of table `test/iz` trx id 0 42313620 lock_mode X locks rec but not gap Record lock, heap no… see number of pages being read and written. Created pages is empty pages created in buffer pool for new data – when previous…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… MVCC to do index scans. Basically this means that all types of SELECTs can be done without locking. Morgan notes: Indexes not using… locking and foreign keys. Does this create any additional locking overhead that we should be aware of? Firstly, PBXT does not acquire read locks. A normal SELECT does not lock…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… LRU list Take a reader-writer shared lock on the latch protecting the Adaptive Hash Index (AHI) Scan the buffer pool and… last access time) and a shared reader-writer lock on the Adaptive Hash Index latch. The buffer pool mutex is a major…. First of all before running the benchmark, 30 tables were created and populated with 1000 rows, the tables all had a…
