entityMap|blocks|key|dc782|text|运行这个查询，你可能会得到你想要的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|84gdn|SELECT+table_schema+"DB+Name",
++++++++ROUND(SUM(data_length+%2B+index_length)+/+1024+/+1024,+1)+"DB+Size+in+MB"+
FROM+information_schema.tables+
GROUP+BY+table_schema;|code-block|syntax|javascript|d6pm5|此查询来自|cs0vf|mysql论坛|elom9|，其中有更全面的说明可用。^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|N|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|O|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|P|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|Q|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|R|9|@]|A|@]|B|$]]]]

Run this query and you'll probably get what you're looking for:

<pre><code>SELECT table_schema "DB Name",
 ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema; 
</code></pre>

This query comes from <a href="http://forums.mysql.com/read.php?108,201578,201578" rel="noreferrer">the mysql forums</a>, where there are more comprehensive instructions available.

entityMap|blocks|key|dj92q|text|可以使用以下MySQL命令来确定|type|unstyled|depth|inlineStyleRanges|entityRanges|data|9defl|SELECT+table_schema+AS+"Database",+SUM(data_length+%2B+index_length)+/+1024+/+1024+AS+"Size+(MB)"+FROM+information_schema.TABLES+GROUP+BY+table_schema|code-block|syntax|javascript|87bj5|结果|fd09b|Database++++Size+(MB)
db1+++++++++11.75678253
db2+++++++++9.53125000
test++++++++50.78547382|6f247|获取以GB为单位的结果|6nhk|SELECT+table_schema+AS+"Database",+SUM(data_length+%2B+index_length)+/+1024+/+1024+/+1024+AS+"Size+(GB)"+FROM+information_schema.TABLES+GROUP+BY+table_schema^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|P|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|Q|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|R|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|S|9|@]|A|@]|B|$F|G]]|$2|L|4|M|6|7|8|T|9|@]|A|@]|B|$]]|$2|N|4|O|6|E|8|U|9|@]|A|@]|B|$F|G]]]]

It can be determined by using following MySQL command 

<pre><code>SELECT table_schema AS "Database", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema
</code></pre>

Result 

<pre><code>Database Size (MB)
db1 11.75678253
db2 9.53125000
test 50.78547382
</code></pre>

Get result in GB

<pre><code>SELECT table_schema AS "Database", SUM(data_length + index_length) / 1024 / 1024 / 1024 AS "Size (GB)" FROM information_schema.TABLES GROUP BY table_schema
</code></pre>

entityMap|0|type|IMAGE|mutability|IMMUTABLE|data|imageUrl|https://ask.qcloudimg.com/http-save/actteam/6e3f4377114e2ed51fbfbd6d2552457e.png|imageAlt|blocks|key|c2quv|text|或者，如果您正在使用|unstyled|depth|inlineStyleRanges|entityRanges|dhho3|，您可以查看数据库页脚中表大小的总和|6me0j|制表符。实际数据库大小可能略高于此大小，但它似乎与|3rms5|方法。|6gn6q|屏幕截图：|46ecc|​|4idvq|d798t|?|atomic|offset|length|gf1e|1vn9i^0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|$1|$2|3|4|5|6|$7|8|9|-4]]]|A|@$B|C|D|E|2|F|G|11|H|@]|I|@]|6|$]]|$B|J|D|K|2|F|G|12|H|@]|I|@]|6|$]]|$B|L|D|M|2|F|G|13|H|@]|I|@]|6|$]]|$B|N|D|O|2|F|G|14|H|@]|I|@]|6|$]]|$B|P|D|Q|2|F|G|15|H|@]|I|@]|6|$]]|$B|R|D|S|2|F|G|16|H|@]|I|@]|6|$]]|$B|T|D|-4|2|F|G|17|H|@]|I|@]|6|$]]|$B|U|D|V|2|W|G|18|H|@]|I|@$X|19|Y|1A|B|1B]]|6|$]]|$B|Z|D|-4|2|F|G|1C|H|@]|I|@]|6|$]]|$B|10|D|S|2|F|G|1D|H|@]|I|@]|6|$]]]]

Alternatively, if you are using <code>phpMyAdmin</code>, you can take a look at the sum of the table sizes in the footer of your database <code>structure</code> tab. The actual database size may be slightly over this size, however it appears to be consistent with the <code>table_schema</code> method mentioned above.

Screen-shot :

<a href="https://i.stack.imgur.com/Do40K.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Do40K.png" alt="enter image description here"></a>

entityMap|blocks|key|ar4hb|text|或者，您也可以直接跳转到data目录，检查v3.myd、v3的组合大小。myi和v3。frm文件(适用于myisam)或v3.idb+&+v3.frm+(适用于innodb)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Alternatively you can directly jump into data directory and check for combined size of v3.myd, v3. myi and v3. frm files (for myisam) or v3.idb &amp; v3.frm (for innodb).

entityMap|blocks|key|46iq0|text|要获取以MB为单位的结果，请执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1bvka|SELECT
SUM(ROUND(((DATA_LENGTH+%2B+INDEX_LENGTH)+/+1024+/+1024),+2))+AS+"SIZE+IN+MB"
FROM+INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA+=+"SCHEMA-NAME";|code-block|syntax|javascript|cdrgf|要获得以GB为单位的结果，请执行以下操作：|6bu1r|SELECT
SUM(ROUND(((DATA_LENGTH+%2B+INDEX_LENGTH)+/+1024+/+1024+/+1024),+2))+AS+"SIZE+IN+GB"
FROM+INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA+=+"SCHEMA-NAME";^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|O|9|@]|A|@]|B|$F|G]]]]

To get a result in MB:

<pre><code>SELECT
SUM(ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2)) AS "SIZE IN MB"
FROM INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = "SCHEMA-NAME";
</code></pre>

To get a result in GB:

<pre><code>SELECT
SUM(ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 / 1024), 2)) AS "SIZE IN GB"
FROM INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = "SCHEMA-NAME";
</code></pre>

entityMap|blocks|key|d2j6|text|mysqldiskusage++--server=root:MyPassword@localhost++pics

%2B----------%2B----------------%2B
%7C+db_name++%7C+++++++++total++%7C
%2B----------%2B----------------%2B
%7C+pics+++++%7C+1,179,131,029++%7C
%2B----------%2B----------------%2B|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|aemqa|如果未安装，则可以通过安装|unstyled|3b347|大多数主要发行版都应该打包的包。^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$C|D]]|$2|E|4|F|6|G|8|K|9|@]|A|@]|B|$]]|$2|H|4|I|6|G|8|L|9|@]|A|@]|B|$]]]]

<pre><code>mysqldiskusage --server=root:MyPassword@localhost pics

+----------+----------------+
| db_name | total |
+----------+----------------+
| pics | 1,179,131,029 |
+----------+----------------+
</code></pre>

If not installed, this can be installed by installing the <code>mysql-utils</code> package which should be packaged by most major distributions.

entityMap|blocks|key|7inhr|text|使用以下命令首次登录到MySQL|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1enm6|命令显示单个数据库及其表的大小。|ar4va|SELECT+table_name+AS+"Table",
ROUND(((data_length+%2B+index_length)+/+1024+/+1024),+2)+AS+"Size+(MB)"
FROM+information_schema.TABLES
WHERE+table_schema+=+"database_name"
ORDER+BY+(data_length+%2B+index_length)+DESC;|code-block|syntax|javascript|3g2jh|更改数据库|92nmq|_|45ckf|数据库的名称|dte8i|命令来显示所有数据库，其大小以MB为单位。|767kk|SELECT+table_schema+AS+"Database",+
ROUND(SUM(data_length+%2B+index_length)+/+1024+/+1024,+2)+AS+"Size+(MB)"+
FROM+information_schema.TABLES+
GROUP+BY+table_schema;^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|T|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|U|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|V|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|W|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|X|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|Y|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|Z|9|@]|A|@]|B|$]]|$2|R|4|S|6|G|8|10|9|@]|A|@]|B|$H|I]]]]

First login to MySQL using 

<code>mysql -u username -p</code>

<blockquote>
 Command to Display the size of a single Database along with its table in MB.
</blockquote>

<pre><code>SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE table_schema = "database_name"
ORDER BY (data_length + index_length) DESC;
</code></pre>

Change database_name to your Database

<blockquote>
 Command to Display all the Databases with its
 size in MB.
</blockquote>

<pre><code>SELECT table_schema AS "Database", 
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)" 
FROM information_schema.TABLES 
GROUP BY table_schema;
</code></pre>

entityMap|blocks|key|muih|text|进入mysql数据目录并运行|type|unstyled|depth|inlineStyleRanges|entityRanges|data^0^^$0|$]|1|@$2|3|4|5|6|7|8|C|9|@]|A|@]|B|$]]]]

Go into the mysql data directory and run <code>du -h --max-depth=1 | grep databasename</code>

entityMap|blocks|key|418o|text|如果希望对所有数据库大小的列表进行排序，可以使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8bruu|SELECT+*+
FROM+++(SELECT+table_schema+AS+`DB+Name`,+
+++++++++++ROUND(SUM(data_length+%2B+index_length)+/+1024+/+1024,+1)+AS+`DB+Size+in+MB`
++++++++FROM+++information_schema.tables+
++++++++GROUP++BY+`DB+Name`)+AS+tmp_table+
ORDER++BY+`DB+Size+in+MB`+DESC;|code-block|syntax|javascript^0|0^^$0|$]|1|@$2|3|4|5|6|7|8|H|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|I|9|@]|A|@]|B|$F|G]]]]

If you want the list of all database sizes sorted, you can use :
<pre><code>SELECT * 
FROM (SELECT table_schema AS `DB Name`, 
 ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS `DB Size in MB`
 FROM information_schema.tables 
 GROUP BY `DB Name`) AS tmp_table 
ORDER BY `DB Size in MB` DESC; 
</code></pre>

How to get size of a mysql database? 
Suppose the target database is called "v3".

How to get size of mysql database?

 如何获取mysql数据库的大小？ 假设目标数据库名为"v3“。

问如何获取mysql数据库的大小？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取mysql数据库的大小？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取mysql数据库的大小？
EN