![]() Use the below command to get the given database size in MB format. MariaDB > SELECT table_schema "database", sum(data_length index_length)/1024/1024/1024 "size in GB" FROM information_schema.TABLES GROUP BY table_schema ģ) How To View The Particular MySQL/MariaDB Database Size In MB Format In Linux? Use the below command to get the database size in GB format. MariaDB > SELECT table_schema "database", sum(data_length index_length)/1024/1024 "size in MB" FROM information_schema.TABLES GROUP BY table_schema Ģ) How To View The MySQL/MariaDB Database Size In GB Format In Linux? Use the below command to get the database size in MB format. Type '\c' to clear the current input statement.ġ) How To View The MySQL/MariaDB Database Size In MB Format In Linux? Server version: 10.3.13-MariaDB Source distributionĬopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. It stores all the database information in the information_schema database so, we can easily gather all the database information from information_schema database.įirst login to MariaDB database using the following command and perform the below commands. Make sure, you should have root privilege to perform this action. It won’t give you an accurate size but no major difference in the size when you comparing with the MySQL/MariaDB query. Since MariaDB database has kept all the data’s in the filesystem so, we can easily check size of the databases and tables by navigating to the following folder var/lib/mysql/. In other words i can say Nothing is Impossible. ![]() ![]() Yes, everybody knows that everything is possible in Linux. So, what to do? is there any options to check these from Linux command line? Sometimes you may need to check the size of each MySQL/MariaDB database and table to optimize or repair them due to some reason. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |