首页 / MYSQL / Mysql 查看数据库大小
Mysql 查看数据库大小
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Mysql 查看数据库大小,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3485字,纯文字阅读大概需要5分钟。
内容图文
1 命令行进入数据库
[root@80 ~]# mysql -uroot -p Enter password:
2 查看数据库
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+
3 查看information_schema的"TABLES"
mysql> use information_schema; | TABLES |
4 查看字段结构
mysql> desc tables; +-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | TABLE_CATALOG | varchar(512) | NO | | | | | TABLE_SCHEMA | varchar(64) | NO | | | | | TABLE_NAME | varchar(64) | NO | | | | | TABLE_TYPE | varchar(64) | NO | | | | | ENGINE | varchar(64) | YES | | NULL | | | VERSION | bigint(21) unsigned | YES | | NULL | | | ROW_FORMAT | varchar(10) | YES | | NULL | | | TABLE_ROWS | bigint(21) unsigned | YES | | NULL | | | AVG_ROW_LENGTH | bigint(21) unsigned | YES | | NULL | | | DATA_LENGTH | bigint(21) unsigned | YES | | NULL | | | MAX_DATA_LENGTH | bigint(21) unsigned | YES | | NULL | | | INDEX_LENGTH | bigint(21) unsigned | YES | | NULL | | | DATA_FREE | bigint(21) unsigned | YES | | NULL | | | AUTO_INCREMENT | bigint(21) unsigned | YES | | NULL | | | CREATE_TIME | datetime | YES | | NULL | | | UPDATE_TIME | datetime | YES | | NULL | | | CHECK_TIME | datetime | YES | | NULL | | | TABLE_COLLATION | varchar(32) | YES | | NULL | | | CHECKSUM | bigint(21) unsigned | YES | | NULL | | | CREATE_OPTIONS | varchar(255) | YES | | NULL | | | TABLE_COMMENT | varchar(2048) | NO | | | | +-----------------+---------------------+------+-----+---------+-------+
5 查看DB的数据大小
mysql> select table_schema,round(sum(DATA_LENGTH)/1024/1024,2) as table_size from tables group by table_schema; +--------------------+------------+ | table_schema | table_size | +--------------------+------------+ | bomo_backend | 0.09 | | test1 | 234.16 | | test2 | 0.17 | | information_schema | 0.00 | | mysql | 0.71 | | performance_schema | 0.00 | | test | 0.03 | +--------------------+------------+
6 查看table的数据大小
mysql> select table_schema,table_name,concat(round(data_length/1024/1024,2),‘M‘) as table_size from tables where table_schema = ‘grab‘; +--------------+--------------+------------+ | table_schema | table_name | table_size | +--------------+--------------+------------+ | grab | product | 215.12M | | grab | result | 13.52M | | grab | rule | 0.02M | | grab | task | 5.52M | +--------------+--------------+------------+
本文出自 “老炮儿” 博客,转载请与作者联系!
Mysql 查看数据库大小
标签:mysql 数据库
本文系统来源:http://joelemma.blog.51cto.com/11189330/1865330
内容总结
以上是互联网集市为您收集整理的Mysql 查看数据库大小全部内容,希望文章能够帮你解决Mysql 查看数据库大小所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。