… different time periods or different regions. The flights represent the type of investigations and drill-downs that are common in OLAP…=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout… (or any) system variables. For a quick intro to metadata locks and how they may affect you, see Ovais’s article… upgrading, give pt-upgrade a try. It also reads every type of log now (slow, general, binary, and tcpdump), so you…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… Innodb, let alone Galera. I had considered a job queue system in Innodb in the past that, in absence of a ‘SKIP LOCKED… gracefully find rows that had not been taken yet. This type of system simply won’t work across multiple nodes in…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… the SQL for each time. if (trx->isolation_level select_lock_type != LOCK_NONE && trx->mysql_query_str) { /* Scan the MySQL query string…: do not lock gaps */ set_also_gap_locks = FALSE; } } The “REPLACE 1000 rows” SQL doesn’t have “SELECT” so, InnoDB scan all of…->isolation_level select_lock_type != LOCK_NONE && trx->mysql_thd != NULL && thd_is_select(trx->mysql_thd)) { /* It is a plain locking SELECT and…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… in hard to parse SHOW INNODB STATUS output or even uglier hacks with creating tables such as innodb_lock_monitor to get more… allow to preserve compatibility. Look for example on query_cache_type variable which can be set to ON/OFF/DEMAND as…, O_DSYNC, fdatasync etc. However Look at new variable innodb_autoinc_lock_mode freshly added in 5.1.22 (which is what…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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…slave_type_…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…: 11569733 # InnoDB_IO_r_ops: 38530 InnoDB_IO_r_bytes: 631275520 InnoDB_IO_r_wait: 0.204893 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
…: *************************** 2. row *************************** id: 1 select_type: SIMPLE table: t1 type: eq_ref possible_keys: PRIMARY,id… locking was done so disk IO is not done while lock is held, while lock …4 Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form…
Post: Instrumentation and the cost of Foreign Keys
September 20, 2010 By 9 Comments
…_schema.innodb_locks: mysql> SELECT * FROM information_schema.innodb_locks\G *************************** 1. row *************************** lock_id: 87035:1300:3:6 lock_trx_id: 87035 lock_mode: X lock_type: RECORD lock_table: `test`.`parent` lock_index: `PRIMARY` lock…
