1 개요[ | ]
- MySQL SHOW TABLE STATUS
Console
Copy
mysql> SHOW TABLE STATUS;
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------------------------------------------------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------------------------------------------------+
| columns_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 227994731135631359 | 4096 | 0 | NULL | 2012-08-30 14:30:23 | 2014-09-09 07:36:56 | 2014-09-09 07:36:56 | utf8_bin | NULL | | Column privileges |
| db | MyISAM | 10 | Fixed | 3 | 440 | 1320 | 123848989752688639 | 5120 | 0 | NULL | 2012-08-30 14:30:23 | 2015-11-26 15:08:34 | 2014-09-09 07:36:56 | utf8_bin | NULL | | Database privileges |
| event | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | NULL | 2012-08-30 14:30:24 | 2014-09-09 07:36:56 | 2014-09-09 07:36:56 | utf8_general_ci | NULL | | Events |
... (생략)
| user | MyISAM | 10 | Dynamic | 13 | 85 | 1112 | 281474976710655 | 2048 | 0 | NULL | 2012-08-30 14:30:23 | 2015-11-26 15:08:34 | 2014-09-09 07:36:56 | utf8_bin | NULL | | Users and global privileges |
+---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------------------------------------------------+
23 rows in set (0.00 sec)
2 같이 보기[ | ]
편집자 Jmnote
로그인하시면 댓글을 쓸 수 있습니다.
- 분류 댓글:
- MySQL (5)
CentOS MySQL 설치 ― …MySQL BigDump ― JmnoteMySQL STRICT TRANS TABLES ― John JeongMySQL 외래키 옵션 변경 ― 문태부MySQL 컬럼명으로 테이블 찾기 ― Stly3466