In MariaDB 5.5 the bug still exists with the following query statistics:
- If executed with index:
MariaDB [test]> show status like 'last_query_cost';
+-----------------+-------------+
| Variable_name | Value |
+-----------------+-------------+
| Last_query_cost | 5117.799000 |
+-----------------+-------------+
1 row in set (0.00 sec)
MariaDB [test]> show status like 'last_query_cost';
+-----------------+-------------+
| Variable_name | Value |
+-----------------+-------------+
| Last_query_cost | 5117.799000 |
+-----------------+-------------+
1 row in set (0.00 sec)
In MariaDB 5.5 the bug still exists with the following query statistics:
- If executed with index:
MariaDB [test]> show status like 'last_query_cost'; ------- ----+-- ------- ----+ ------- ----+-- ------- ----+ ------- ----+-- ------- ----+
+------
| Variable_name | Value |
+------
| Last_query_cost | 5117.799000 |
+------
1 row in set (0.00 sec)
MariaDB [test]> show status like 'Handler_read%'; ------- ------- ------+ ------- + ------- ------- ------+ ------- + read_rnd_ deleted | 0 | read_rnd_ next | 0 | ------- ------- ------+ ------- +
+------
| Variable_name | Value |
+------
| Handler_read_first | 1 |
| Handler_read_key | 0 |
| Handler_read_last | 0 |
| Handler_read_next | 4079 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_
| Handler_
+------
- Without index:
MariaDB [test]> show status like 'last_query_cost'; ------- ----+-- ------- ----+ ------- ----+-- ------- ----+ ------- ----+-- ------- ----+
+------
| Variable_name | Value |
+------
| Last_query_cost | 5117.799000 |
+------
1 row in set (0.00 sec)
MariaDB [test]> show status like 'Handler_read%'; ------- ------- ------+ ------- + ------- ------- ------+ ------- + read_rnd_ deleted | 0 | read_rnd_ next | 8079 | ------- ------- ------+ ------- +
+------
| Variable_name | Value |
+------
| Handler_read_first | 0 |
| Handler_read_key | 4079 |
| Handler_read_last | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 13 |
| Handler_
| Handler_
+------