… isolation level READ COMMITTED, then InnoDB normally does not lock the ‘gaps’, and it does not lock rows whose latest committed version does…. Sets the max\ imum number of threads allowed inside InnoDB. Value 0 will disable the thread t\ hrottling.”, NULL, NULL, 8, 0… of threads waiting for semaphores in SHOW INNODB STATUS), you can try to disable thread throttling completely by setting the value 0…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… you running MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc… 1159956816 starting index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query id… B. The real solution is to disable this startup process. It’s not even needed for InnoDB. Sooner or later you’ll…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…-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… ‘FEDERATED’ is disabled. 120619 13:21:17 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…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_binlog = 1 innodb_max_dirty_pages_pct=15 innodb…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… these mutex lock requests come from. A second confirmation that key_cache is a problem is benchmark run with disabled key_cache… have more queries per second for 4, 8, 16 with disabled key_cache. The results for 2 threads is however quite… on system with 4 Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created…
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… index size with the optimization disabled. OPTIMIZE TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… spike. Plus not all kernels work quite well with swap disabled and there are other reasons against it. For some people… disk, for example when Innodb tries to avoid holding latches while doing IO while there could be locks set while accessing pages… the same lock till IO completion, while they may well have all data they need to proceed in the innodb buffer pool…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… show up on slow query log until InnoDB again updates the statistics. But when does InnoDB perform the updates aside from the…: db1 Last_errno: 0 Killed: 0 # Query_time: 12.277786 Lock_time: 0.000068 Rows_sent: 294 Rows_examined: 294 Rows… called innodb_stats_on_metadata, for Percona Server where both variables exist, both should be 0 if you want to disable the…
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
…) InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use InnoDB‘s own implementation InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… all disabled from 20 servers: # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file… buffer pool size #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50…
