Monthly Archives: March 2011

Partition table MyISAM vs InnoDB

Benchmark partition table with MyISAM & InnoDB engine

Partitions table with MyISAM:
Load data 1.000.000 rows
mysql> call load_test_part_myisam();
Query OK, 1 row affected (57.69 sec)

mysql> select count(*) from test_part_myisam where c3 > date ‘2000-01-01’ and c3 < date '2000-12-31';
+———-+
| count(*) |
+———-+
| 99681 |
+———-+
1 row in set (0.10 sec)

Partitions table with InnoDB:
Load data 1.000.000 rows
mysql> call load_test_part_innodb();
Query OK, 1 row affected (1 hour 11 min 25.19 sec)

mysql> select count(*) from test_part_innodb where c3 > date ‘2000-01-01’ and c3 < date '2000-12-31';
+———-+
| count(*) |
+———-+
| 99681 |
+———-+
1 row in set (0.22 sec)

Continue reading