…-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size=64M… InnoDB: The InnoDB memory heap is disabled 120619 13:21:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120619 13:21:17 InnoDB…. Let’s test. # clustercheck HTTP/1.1 200 OK Content-Type: Content-Type: text/plain Node is running. We will use xinetd…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…look for content in the…innodb_flush_methodblogpercona.commanual innodb_force_recoveryblogpercona.commanual Innodb_have_atomic_builtinsblogpercona.commanual innodb_io_capacityblogpercona.commanual innodb_lock_wait_timeoutblogpercona.commanual innodb_locks_unsafe_for_binlogblogpercona.commanual innodb…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb…innodb_fsync_source.patch | Information of fsync callers in InnoDB | 1.0 | Google | GPL | | | innodb_show_bp.patch | show innodb buffer pool content…
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
…innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb…innodb_fsync_source.patch | Information of fsync callers in InnoDB | 1.0 | Google | GPL | | | innodb_show_bp.patch | show innodb buffer pool content…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… concurrency, specifically around mutexes and contention? How does this fit into the development process? HT: Contention and thread thrashing depends very much… moves the contention to another place. Thus, no general rules can be established. I have assigned Inaam as the InnoDB scalability engineer… Heikki – it should be possible to implement online reorganize which locks and reorganizes small portions of table online. Q38: Seems that…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… bitten repairing multiple GB MyISAM table few times, though Table Locks is probably the most important issue – with modern multi core… serious contention issue. The problem we often run into during migration is Full Text Search indexes which are not supported for Innodb… add a lot of contention on the writes. In this case you can just rebuild the table from Innodb source on regular…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…INNODB STATUS. We’ve added more memory information and lock information, and fixed problems with lock information. documentation Improvements to InnoDB IO. Improvements of InnoDB… of buffer_pool scalability. documentation innodb_buffer_pool_pages Information about content of buffer_pool pages. …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… variables’ values below will be ignored and # overridden by the content of the master.info file, unless you shutdown # the slave… #bdb_max_lock = 100000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/data/ #innodb_data_file… buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50…
Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 13, 2008 By 51 Comments
… a lock and can not get it because something else has the lock was called lock contention. Also, when you say: “Lock table Innodb can lock tables but it will still need to set row level locks which…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… pagesize when you created database InnoDB fast checksums, idea and implementation was taken from Facebook patches InnoDB big log files ( bigger 4GB… content of buffer_pool Import / export of dedicated tables Import / export of buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking…
