mysql> use information_schema
Database changedmysql> select * from TABLES;
ERROR 1102 (42000): Incorrect database name ''奇怪,为什么有这张表,却查询的时候报错呢?
网上说这个表查看索引碎片什么的,我想看看我频繁操作的表有没有很多的碎片,怎么查看呢?
Database changedmysql> select * from TABLES;
ERROR 1102 (42000): Incorrect database name ''奇怪,为什么有这张表,却查询的时候报错呢?
网上说这个表查看索引碎片什么的,我想看看我频繁操作的表有没有很多的碎片,怎么查看呢?
mysql> use information_schema;
Database changed
mysql> select * from TABLES;
+---------------+--------------------+------------------------
+-------------+--------------------+--------------+-----------
-------------+----------+----------------+--------------------
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME
| DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE
_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT
+---------------+--------------------+------------------------
+-------------+--------------------+--------------+-----------
-------------+----------+----------------+--------------------
| NULL | information_schema | CHARACTER_SETS
| 0 | 16604160 | 0 | 0
general_ci | NULL | max_rows=43690 |