{"id":15324,"date":"2026-05-13T06:46:17","date_gmt":"2026-05-13T06:46:17","guid":{"rendered":"https:\/\/www.bodhost.com\/kb\/?p=15324"},"modified":"2026-05-13T06:46:17","modified_gmt":"2026-05-13T06:46:17","slug":"determining-the-size-of-mysql-databases-and-tables","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/","title":{"rendered":"Determining MySQL Database Storage Size and Table Size"},"content":{"rendered":"

In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool, for better monitoring of your databases, managing your storage, and optimising performance.<\/p>\n

Using phpMyAdmin<\/strong><\/h3>\n

You can easily check MySQL database and table sizes through the phpMyAdmin<\/a> interface. Use the steps below to see detailed database storage information.<\/p>\n

1. Log in to your cPanel account.
\nSimple to access and manage your website databases and hosting settings by logging into your cPanel account.<\/p>\n

2. To access and administer your MySQL databases, click phpMyAdmin under the DATABASES section in cPanel.<\/p>\n

\"cPanel<\/p>\n

The phpMyAdmin dashboard opens in a new window, where you can manage and view your databases with ease.<\/p>\n

3. Select the name of the database you want to work on in the left panel and check in phpMyAdmin.<\/p>\n

4. In the right panel, look at the Size column to see how much space each table takes up in the database.<\/p>\n

\"phpmyadmin\"5. Scroll to the bottom of the Size column in phpMyAdmin to get the total database size.<\/p>\n

\"DB\"<\/p>\n

Using the MySQL command-line program<\/strong><\/h4>\n

If you want to see database and table sizes, here are some steps to do this using the MySQL command-line tool.<\/p>\n

1. Log in securely to your server account using SSH to access the command-line interface for database management.<\/p>\n

2. Open a terminal and type the following, replacing \u201cusername\u201d with your actual account username.<\/p>\n

mysql -u username -p<\/span><\/pre>\n
3. When asked, type in your password. After you log in successfully, the mysql> command prompt will show up for the next steps.<\/p>\n
4. At the mysql> prompt, run the command below to view the size of all your databases.<\/p>\n
Bash\r\nSELECT table_schema AS \"Database\", <\/span>\r\nROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS \"Size (MB)\" <\/span>\r\nFROM information_schema.TABLES <\/span>\r\nGROUP BY table_schema;<\/span><\/pre>\n
Note: <\/strong>Depending on the number and size of your databases, this command may take a few minutes to finish. Once completed, it displays all databases along with their sizes in megabytes.<\/p>\n
5. At the mysql> prompt, run the command below to view the size of all tables in a specific database. Replace \u201cdatabase_name\u201d with your target database name.<\/p>\n
Bash\r\nSELECT table_name AS \"Table\",<\/span>\r\nROUND(((data_length + index_length) \/ 1024 \/ 1024), 2) AS \"Size (MB)\"<\/span>\r\nFROM information_schema.TABLES<\/span>\r\nWHERE table_schema = \"database_name\"<\/span>\r\nORDER BY (data_length + index_length) DESC;<\/span><\/pre>\n
Note: Once the command completes, it shows all tables with their sizes in megabytes, sorted from largest to smallest.<\/p>\n
In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool, for better monitoring of your databases, managing your storage, and optimising performance. Using phpMyAdmin You can easily check MySQL database and table sizes through the phpMyAdmin interface. Use the steps below to […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857],"tags":[],"class_list":["post-15324","post","type-post","status-publish","format-standard","hentry","category-sql"],"yoast_head":"\nDetermining the size of MySQL databases and tables<\/title>\n<meta name=\"description\" content=\"In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Determining the size of MySQL databases and tables\" \/>\n<meta property=\"og:description\" content=\"In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-13T06:46:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.hosting.com\/kb\/kb-cpanel-78-databases-phpmyadmin-icon.png\" \/>\n<meta name=\"author\" content=\"Paul Lopez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Lopez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/\"},\"author\":{\"name\":\"Paul Lopez\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\"},\"headline\":\"Determining MySQL Database Storage Size and Table Size\",\"datePublished\":\"2026-05-13T06:46:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/\"},\"wordCount\":376,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/static.hosting.com\\\/kb\\\/kb-cpanel-78-databases-phpmyadmin-icon.png\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/\",\"name\":\"Determining the size of MySQL databases and tables\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/static.hosting.com\\\/kb\\\/kb-cpanel-78-databases-phpmyadmin-icon.png\",\"datePublished\":\"2026-05-13T06:46:17+00:00\",\"description\":\"In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/static.hosting.com\\\/kb\\\/kb-cpanel-78-databases-phpmyadmin-icon.png\",\"contentUrl\":\"https:\\\/\\\/static.hosting.com\\\/kb\\\/kb-cpanel-78-databases-phpmyadmin-icon.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/determining-the-size-of-mysql-databases-and-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Determining MySQL Database Storage Size and Table Size\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\",\"name\":\"Paul Lopez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"caption\":\"Paul Lopez\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/paullopez\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Determining the size of MySQL databases and tables","description":"In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/","og_locale":"en_US","og_type":"article","og_title":"Determining the size of MySQL databases and tables","og_description":"In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool.","og_url":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2026-05-13T06:46:17+00:00","og_image":[{"url":"https:\/\/static.hosting.com\/kb\/kb-cpanel-78-databases-phpmyadmin-icon.png","type":"","width":"","height":""}],"author":"Paul Lopez","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Lopez","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/"},"author":{"name":"Paul Lopez","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813"},"headline":"Determining MySQL Database Storage Size and Table Size","datePublished":"2026-05-13T06:46:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/"},"wordCount":376,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/static.hosting.com\/kb\/kb-cpanel-78-databases-phpmyadmin-icon.png","articleSection":["SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/","url":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/","name":"Determining the size of MySQL databases and tables","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#primaryimage"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/static.hosting.com\/kb\/kb-cpanel-78-databases-phpmyadmin-icon.png","datePublished":"2026-05-13T06:46:17+00:00","description":"In this article, you will learn how to check the size of MySQL databases and tables with phpMyAdmin or the MySQL command-line tool.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#primaryimage","url":"https:\/\/static.hosting.com\/kb\/kb-cpanel-78-databases-phpmyadmin-icon.png","contentUrl":"https:\/\/static.hosting.com\/kb\/kb-cpanel-78-databases-phpmyadmin-icon.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/determining-the-size-of-mysql-databases-and-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SQL","item":"https:\/\/www.bodhost.com\/kb\/category\/sql\/"},{"@type":"ListItem","position":2,"name":"Determining MySQL Database Storage Size and Table Size"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813","name":"Paul Lopez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","caption":"Paul Lopez"},"url":"https:\/\/www.bodhost.com\/kb\/author\/paullopez\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/15324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=15324"}],"version-history":[{"count":5,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/15324\/revisions"}],"predecessor-version":[{"id":15331,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/15324\/revisions\/15331"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=15324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=15324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=15324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
How can you map MySQL databases and users to cPanel users?<\/em> <\/a>Learn an easy, step-by-step method for organizing and managing access.<\/p>\n","protected":false},"excerpt":{"rendered":"