…_memo_contains(mtr, dict_index_get_lock(index), 551 MTR_MEMO_X_LOCK)); 552 } else { 553 mtr_s_lock(dict_index_get_lock(index), mtr); ===> all other queries…->mutex’ 2 lock on RW-latch at 0x2d881108 ‘&new_index->lock‘ 212 Mutex at 0x2d0777a8 ‘&log_sys->mutex’ 803 lock on RW-latch at 0x2d87c708 ‘&new_index->lock‘
Comment: Index lock and adaptive search - next two biggest InnoDB problems
February 19, 2012 By 12 Comments
Comment: SHOW INNODB STATUS walk through
January 12, 2011 By 40 Comments
… 487 for 28.000 seconds the semaphore: S-lock on RW-latch at 0x2ac843e8e770 ‘&new_index->lock‘ a writer (thread id 1265760576) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file btr/btr0cur.c line 487 Last…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 0.000004 | | init | 0.000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0.002255 | | After… only the clustered index, and adding the secondary indexes after the data is loaded.” mysqldump in Percona Server supports the new option –innodb…
Comment: Slow Query Log analyzes tools
February 20, 2009 By 83 Comments
… I have is to create an index on a 7gb InnoDB table , single .ibd file, that locks the table WRITE for a…] Lock the table READ to prevent updates and make the new index consistent [2] create like a new empty table and add the new index [3] select into the new table from the big table [4] lock…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… allows you to change that behavior with the new parameter –log-slow-slave-statements. THE DETAILED … means any of the joins didn’t use indexes. If a temporary table is required for query…] @ localhost [] # Thread_id: 4 # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… output. “xx-lock on RW-latch at 0x7f2ff40a3dc0 created in file dict/dict0dict.c line 1627″ It is index->lock, viewing the source file (and it may be HISTORY table). This is the lock for each index tree. We… Dimitri’s) “xtra p_t 4″: XtraDB 1.0.4-new (4 purge threads) The graphs show… The purge thread (> 0…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852…. You cannot consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together, and tweaking… case, though, a query simply needs a rewrite or a new index or something. In this case we show the query and…
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… Add more features for Percona XtraBackup And work on our new area of interest: clustering solution based on XtraDB + Galera If…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… announced new Percona-XtraDB-9.1 release, and now it is…features from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended…Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io profiling in slow.log I hope you …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… can’t wait for ability to create physically sorted indexes with Innodb (with index built by sort) this is when this should… (or never locks) the rows if they were not matched by query where clause when it was not resolved by index HT…: INNODB has typically had problems scaling on multicore boxes. The new quad core CPUs from AMD and Intel means that 8…
