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)
|