Details
Minor
Description
MariaDB [test]> analyze select 1;
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | r_rows | filtered | r_filtered | Extra |
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+----------------+
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used |
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+----------------+
1 row in set (0.01 sec)
MariaDB [test]> show status like 'Com_analyze';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Com_analyze | 0 |
+---------------+-------+
1 row in set (0.00 sec)
MariaDB [test]> show status like 'Com_select';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Com_select | 1 |
+---------------+-------+
1 row in set (0.00 sec)
I don't know whether it's by design or a bug, but if it's intentional, at least it should be documented.
Branch: 10.1 commit 12d6f89b073351169e070355e8db363d0d649749 Author: Sergei Petrunia <psergey@askmonty.org> Date: Thu Jun 26 15:55:25 2014 +0400
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-406 ANALYZE $stmt
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Following Serg's opinion, closing as Not A Bug. If anybody strongly disagrees, please re-open.
I think this is correct. EXPLAIN SELECT doesn't increment Com_explain either, it only increments Com_select. There is no Com_explain at all.
And DESCRIBE SELECT doesn't increment Com_describe, it increments Com_select.
While DESCRIBE table increments Com_show_fields.