…HP Cloud DNS. The post focuses on the key aspects of synchronous replication setup with high-… may not be feasible in a cloud environment. Next, the SST. Xtrabackup SST is used there. SST…paramount. We recommend Xtrabackup SST for its reduced locking period from its use (which means the donor…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… once when statement is started instead of handling auto increment lock for full statement duration. The problem with multi value inserts… community version. Relaxing Locks Row level replication allows to get relaxed locks in many other cases. Gap or next-key locks which limit concurrency in…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
October 20, 2007 By 51 Comments
darseq, Indeed if you have SERIALIZABLE isolation or REPEATABLE-READS you will need to have those locks set, this is similar to why Innodb sets next-key locks in the indexes now. For most applications however READ-COMMITED is enough and when locks can be avoided.
Comment: 128GB or RAM finally got cheap
August 6, 2008 By 14 Comments
… 2% of a possible 800%…). If it weren’t for next-key locking in big selects, the system would appear nearly transparent. 
Its…
Post: Index lock and adaptive search - next two biggest InnoDB problems
February 25, 2010 By 12 Comments
… contention problems. So I suspect it’s going to be next biggest issues to make InnoDB scaling on high-end system… be done there internally: there is B-Tree lock free or only page-level lock algorithms, so operation does not need to… reading secondary keys. How it can be solved internally: I think some hashing algorithms may be applied to not lock select queries…
Post: Improved InnoDB rw_lock patch
October 20, 2008 By 3 Comments
… scalability. E.g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard InnoDBGoogle smpfixYasufumi rw_lock 19700.2810601.969432.44 214355.6616673.3112783.58 416104.202669… workloads new rw_locks show results comparable with Google’s smpfix, so we will include innodb_rw_lock into our next -percona-highperf…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…wasting CPU time running spin locks and doing unneeded context switches. The next section is about deadlock errors: …have similar information about last failed foreign key constraint: ———————— LATEST FOREIGN KEY ERROR ———————— 060717 4:29:00 Transaction…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…next‘, ’2358572961′ ‘Handler_rollback’, ’4947643′ ‘Handler_update’, ’12524′ ‘Handler_write’, ’292923929′ ‘Key_blocks_not_flushed’, ’0′ ‘Key_blocks_unused’, ’28987′ ‘Key_blocks_used’, ’1332′ ‘Key…Sort_scan’, ’935242′ ‘Table_locks_immediate’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached’, …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… different. Q2: Does Innodb has pointers to the next/previous page in index tree leaf pages ? HT:…, then InnoDB normally does not lock the ‘gaps’, and it does not lock rows whose latest committed version…, in the same order in the foreign key and the referenced key (this same order condition could be …
