0

How to check mysql db size

Can you please tell me how to check MySQL DB size

MySQL Add a comment
stewart
asked Aug 29 2018
edited Mar 11 2019

Answer

0

MySQL uses the information_schema virtual database to store information about your databases and other settings. You can query it to gather information about size of databases and tables as shown:

#mysql -u root -p
MariaDB [(none)]> SELECT table_schema AS "Database Name",
FROM information_schema.tables 
GROUP BY table_schema;
Add a comment
linuxhelp
asked Jan 29 2019
Post your Answer