MariaDB

  1. Bug #938977
  2. Comment #1

Comment 1 for bug 938977

Revision history for this message
Sergey Petrunia (sergefp) wrote :

I've got:

MariaDB 5.2: 0.16 sec
MariaDB 5.3: 48 sec.
MariaDB 5.3, index_condition_pushdown=off: 48 sec # checked this because it was shown in EXPLAIN.

With MyISAM engine:
MariaDB 5.3: ~ 47 sec, irrespectively of index_condition_pushdown settings
MariaDB 5.2: 0.16 sec.

So, it's not the storage engine, it's not ICP.