… 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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: 3 ways MySQL uses indexes
September 12, 2009 By 27 Comments
…first place. Most popular index type in MySQL – BTREE can speed up equality and prefix range matches. …row lookup. Very common problem I see is multi column indexes which are used but only to …type in explain which correspond to scanning (potentially) complete table in the index order. It is very …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…stored in different servers), multi-server partitioning to …column in this table has 10000 distinct value, so range 1..100 selects about 1% of the table. The times for full table scan vs range scan by index: mysql… index scan/range scan speed dramatically. The rows …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…be much larger than table itself) The index build speed is however not …table locks which are taken for statement duration for Inserts with auto-increment column….full statement duration. The problem with multi value inserts however is the following …which may come in MySQL 5.2 or even MySQL 5.1. I …
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
…; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â… table definition, but at row insertion. You may just have a table with 50 variable length columns,… any multi table update in a transaction. It will also impact both read and modification speed, precisely…
