{"id":13900,"date":"2023-01-23T06:51:28","date_gmt":"2023-01-23T06:51:28","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=13900"},"modified":"2023-01-23T06:51:30","modified_gmt":"2023-01-23T06:51:30","slug":"how-to-check-mysql-database-size-in-linux","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2023\/01\/23\/how-to-check-mysql-database-size-in-linux\/","title":{"rendered":"How to Check MySQL Database Size in Linux"},"content":{"rendered":"

In this article, I will show you how to check the size of MySQL\/MariaDB<\/strong> databases and tables via the MySQL shell. You will learn how to determine the real size of a database file on the disk as well as size of data that it present in a database.<\/p>\n

Read Also<\/strong>: 20 MySQL (Mysqladmin) Commands for Database Administration in Linux<\/a><\/p>\n

By default MySQL\/MariaDB<\/strong> stores all the data in the file system, and the size of data that exists on the databases may differ from the actual size of Mysql data on the disk that we will see later on.<\/p>\n

In addition, MySQL uses the information_schema<\/strong> virtual database to store information about your databases and other settings. You can query it to gather information about size of databases and their tables as shown.<\/p>\n

# mysql -u root -p\nMariaDB [(none)]><\/strong> SELECT table_schema AS \"Database Name\", \nROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS \"Size in (MB)\" \nFROM information_schema.TABLES \nGROUP BY table_schema; \n<\/pre>\n
\n
\"Check<\/a><\/p>\n
Check MySQL Database Size<\/p>\n<\/div>\n
To find out the size of a single MySQL database called rcubemail<\/strong> (which displays the size of all tables in it) use the following mysql query.<\/p>\n
MariaDB [(none)]><\/strong> SELECT table_name AS \"Table Name\",\nROUND(((data_length + index_length) \/ 1024 \/ 1024), 2) AS \"Size in (MB)\"\nFROM information_schema.TABLES\nWHERE table_schema = \"rcubemail<\/strong>\"\nORDER BY (data_length + index_length) DESC;\n<\/pre>\n
\n
\"Check<\/a><\/p>\n
Check Size of MySQL Database<\/p>\n<\/div>\n
Finally, to find out the actual size of all MySQL database files on the disk (filesystem), run the du command<\/a>below.<\/p>\n
# du -h \/var\/lib\/mysql\n<\/pre>\n
\n
\"Check<\/a><\/p>\n
Check MySQL Size on Disk<\/p>\n<\/div>\n
You might also like to read these following MySQL related articles.<\/p>\n
    \n
  1. 4 Useful Commandline Tools to Monitor MySQL Performance in Linux<\/a><\/li>\n
  2. 12 MySQL\/MariaDB Security Best Practices for Linux<\/a><\/li>\n<\/ol>\n
    For any queries or additional ideas you want to share regarding this topic, use the feedback form below.<\/p>\n
    Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
    In this article, I will show you how to check the size of MySQL\/MariaDB databases and tables via the MySQL shell. You will learn how to determine the real size of a database file on the disk as well as size of data that it present in a database. Read Also: 20 MySQL (Mysqladmin) Commands for Database Administration … <\/p>\n
    Continue reading “How to Check MySQL Database Size in Linux”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-13900","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=13900"}],"version-history":[{"count":2,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13900\/revisions"}],"predecessor-version":[{"id":16917,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13900\/revisions\/16917"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=13900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=13900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=13900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}