…ENGINE = InnoDB, PARTITION p7 VALUES LESS THAN (800000000) ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE = InnoDB…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…to perform a lookup on table2 are batched together and sent to the storage engine. The storage engine … fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size … the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MySQL 5.6, when the workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory… these lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read are… MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB…InnoDB, but it can find evidence of problems in the server as well as the storage engine…memory plugin checks for a single process consuming too much memory and/or for too little free memory… be performed with …
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
…memory, useful for temporary tables | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… cases in Optimizer – such as in memory nature of MEMORY storage engine, clustering by Primary key in Innodb and distributed nature of NDB makes… has to be synchronized with storage engine transactions which require a lot of complications and performance overhead. MySQL has to do several fsync…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…engine or database About the cluster For best performance…mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… pool memory to disk): the LRU list and the flush list. You can see a tracking of these lists in SHOW ENGINE INNODB… you detect in regular MySQL that your flushing comes from the LRU list? You could periodically check SHOW ENGINE INNODB STATUS, and see…, and performance is mostly defined by available memory and the I/O subsystem. Also, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…note MySQL 5.0 vs 4.1 has a lot of performance differences and not all of them are Innodb …googling.“What is the good way to split memory between INNODB buffers and OS?†Of course this …can be established. I have assigned Inaam as the InnoDB scalability engineer. We do not have much resources for …
