June 20, 2013

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

…of simple benchmarks. Let’s start with a table containing 4 million rows and one secondary key: mysql…mysql> SET profiling=1; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE t ADD COLUMN v VARCHAR(1); Query OK, 4194304 rows… secondary keys | 17.824109 | | rename result table | 0.162041 | | …

Filed Under: Benchmarks, Insight for DBAs, MySQL