MySQL query database size

MySQL query database size

Step 1: First open the Mysql Command line and choose Start Menu> program> MySql-Command line client, as shown in Figure 1-1:

Figure 1-1

Step 2: Enter use information_schema 1-2 in the command:

Figure 1-2

Step 3: view the size of the specified database. Enter the following statement:

Select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'mb') as data from TABLES where table_schema = 'offlinecollectiondb'; where offlineCollectiondb2 is the database name, replace it with the name of the database you want to query, as shown in 1-3:

Figure 1-3

------------------------------------------- Split line ------------------------------------------------------------------------------------

1. query the size of all data

Select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'mb') as data from TABLES 2. view the table size of the specified database, for example, select concat (round (sum (DATA_LENGTH/1024/1024), 2), 'mb') as data from TABLES where table_schema = 'test' and table_name =;

This article permanently updates the link address: