{"id":22277,"date":"2022-04-28T22:37:58","date_gmt":"2022-04-28T22:37:58","guid":{"rendered":"https:\/\/hostandtech.com\/help\/?p=22277"},"modified":"2022-04-29T17:18:16","modified_gmt":"2022-04-29T17:18:16","slug":"check-mysql-database-and-table-sizes","status":"publish","type":"post","link":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/","title":{"rendered":"Check MySQL Database And Table Sizes"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"22277\" class=\"elementor elementor-22277\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0261832 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0261832\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f8a4f05\" data-id=\"f8a4f05\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d3fa36b elementor-widget elementor-widget-text-editor\" data-id=\"d3fa36b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>This article shows you how to check MySQL database and table sizes. You can do this by using the phpMyAdmin web interface or using the command-line MySQL program.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7ece0c8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7ece0c8\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0c804e8\" data-id=\"0c804e8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dde8cd3 elementor-widget elementor-widget-text-editor\" data-id=\"dde8cd3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Check MySQL Database Using phpMyAdmin<\/h2><p>To check the sizes of MySQL databases and tables using PHPMyAdmin, follow these steps:<\/p><ul><li>Log in to cPanel.<\/li><li>After that, locate the <strong>DATABASES<\/strong> section. Then click <strong>phpMyAdmin<\/strong>. Then the phpMyAdmin administration page appears in a new window.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71d5ffd elementor-widget elementor-widget-image\" data-id=\"71d5ffd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"768\" height=\"88\" src=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/check-MySQL-by-phpmyadmin-768x88.png\" class=\"attachment-medium_large size-medium_large wp-image-22314\" alt=\"check MySQL by phpmyadmin\" srcset=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/check-MySQL-by-phpmyadmin-768x88.png 768w, https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/check-MySQL-by-phpmyadmin-300x34.png 300w, https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/check-MySQL-by-phpmyadmin.png 989w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb770d3 elementor-widget elementor-widget-text-editor\" data-id=\"bb770d3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>In the left pane, click the <strong>name<\/strong> of the database that you want to view.<\/li><li>Then, in the right pane, locate the <strong>Size<\/strong> column. phpMyAdmin lists the size of each table in the database.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de14fc5 elementor-widget elementor-widget-image\" data-id=\"de14fc5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"768\" height=\"271\" src=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes-768x271.png\" class=\"attachment-medium_large size-medium_large wp-image-22333\" alt=\"database tables sizes\" srcset=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes-768x271.png 768w, https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes-300x106.png 300w, https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes-1024x361.png 1024w, https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png 1166w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7914fe0 elementor-alert-info elementor-widget elementor-widget-alert\" data-id=\"7914fe0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">Note<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">If the database contains a large number of tables, you may need to click the &gt; icon to advance to the next page of tables. To obtain the total database size, add together the size totals from each page.\n<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9499097 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9499097\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c9b51dd\" data-id=\"c9b51dd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71a0a48 elementor-widget elementor-widget-text-editor\" data-id=\"71a0a48\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Checking MySQL Databases Using The MySQL Command-line Program<\/h2><p>To check the sizes of MySQL databases and tables using the MySQL command-line program, follow these steps:<\/p><ul><li>Firstly, log in to your account using <strong><a href=\"https:\/\/en.wikipedia.org\/wiki\/Secure_Shell\" target=\"_blank\" rel=\"noopener\">SSH<\/a><\/strong>.<\/li><li>Type the following command, replacing the <strong>username<\/strong> with your username account.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fe99ee elementor-widget elementor-widget-code-highlight\" data-id=\"3fe99ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>mysql -u username -p\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63a7657 elementor-widget elementor-widget-text-editor\" data-id=\"63a7657\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Then, type your <strong>password<\/strong>, at the Enter Password prompt. When you type the correct password, the mysql&gt; prompt appears.<\/li><li>To check the sizes of all of your databases, at the mysql&gt; prompt type the following command:<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7134154 elementor-widget elementor-widget-code-highlight\" data-id=\"7134154\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>SELECT table_schema AS \"Database\", \nROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS \"Size (MB)\" \nFROM information_schema.TABLES \nGROUP BY table_schema;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-370ac71 elementor-alert-info elementor-widget elementor-widget-alert\" data-id=\"370ac71\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">Note<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">This command may take a minute or two to complete, depending on how many databases you have and how large they are. After the command finishes, it lists all of your databases and their corresponding size (in megabytes).\n<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7964dbb elementor-widget elementor-widget-text-editor\" data-id=\"7964dbb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Finally, to check the sizes of all of the tables in a specific database, at the mysql&gt; prompt, type the following command.\u00a0<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a81284 elementor-widget elementor-widget-code-highlight\" data-id=\"3a81284\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>SELECT table_name AS \"Table\",\nROUND(((data_length + index_length) \/ 1024 \/ 1024), 2) AS \"Size (MB)\"\nFROM information_schema.TABLES\nWHERE table_schema = \"database_name\"\nORDER BY (data_length + index_length) DESC;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-750c822 elementor-alert-info elementor-widget elementor-widget-alert\" data-id=\"750c822\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">Note<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">Replace database_name with the name of the database that you want to check.<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6632a6c elementor-widget elementor-widget-text-editor\" data-id=\"6632a6c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>After the command finishes, it lists all of the tables and their corresponding size (in megabytes), with the largest table at the top and the smallest table at the bottom.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61f58ec elementor-widget elementor-widget-elementor-faq-schema\" data-id=\"61f58ec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-faq-schema.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t                                    <script type=\"application\/ld+json\">\n                    {\n                        \"@context\": \"https:\/\/schema.org\",\n                        \"@type\": \"FAQPage\",\n                        \"mainEntity\": [\n                         {\n                            \"@type\": \"Question\",\n                            \"name\": \"How To Check MySQL Database Using phpMyAdmin?\",\n                            \"acceptedAnswer\": {\n                                \"@type\": \"Answer\",\n                                \"text\": \"&lt;ul&gt;&lt;li&gt;Log in to cPanel.&lt;\/li&gt;&lt;li&gt;After that, locate the &lt;strong&gt;DATABASES&lt;\/strong&gt; section. Then click &lt;strong&gt;phpMyAdmin&lt;\/strong&gt;. Then the phpMyAdmin administration page appears in a new window.&lt;\/li&gt;&lt;li&gt;In the left pane, click the &lt;strong&gt;name&lt;\/strong&gt; of the database that you want to view.&lt;\/li&gt;&lt;li&gt;Then, in the right pane, locate the &lt;strong&gt;Size&lt;\/strong&gt; column. phpMyAdmin lists the size of each table in the database.&lt;\/li&gt;&lt;\/ul&gt;\"\n                            }\n                                                    },\n                                             {\n                            \"@type\": \"Question\",\n                            \"name\": \"How To Check MySQL Database Using The MySQL Command-line Program?\",\n                            \"acceptedAnswer\": {\n                                \"@type\": \"Answer\",\n                                \"text\": \"&lt;ul&gt;&lt;li&gt;Log in to your account using &lt;strong&gt;SSH&lt;\/strong&gt;.&lt;\/li&gt;&lt;li&gt;Type the following command, replacing the &lt;strong&gt;username&lt;\/strong&gt; with your username account: mysql -u username -p&lt;\/li&gt;&lt;li&gt;Then, type your &lt;strong&gt;password&lt;\/strong&gt;, at the Enter Password prompt. When you type the correct password, the mysql&gt; prompt appears.&lt;\/li&gt;&lt;li&gt;To check the sizes of all of your databases, at the mysql&gt; prompt type the following command: SELECT table_schema AS &quot;Database&quot;, &lt;br \/&gt;ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 2) AS &quot;Size (MB)&quot; &lt;br \/&gt;FROM information_schema.TABLES &lt;br \/&gt;GROUP BY table_schema;&lt;\/li&gt;&lt;li&gt;Finally, to check the sizes of all of the tables in a specific database, at the mysql&gt; prompt, type the following command: SELECT table_name AS &quot;Table&quot;,&lt;br \/&gt;ROUND(((data_length + index_length) \/ 1024 \/ 1024), 2) AS &quot;Size (MB)&quot;&lt;br \/&gt;FROM information_schema.TABLES&lt;br \/&gt;WHERE table_schema = &quot;database_name&quot;&lt;br \/&gt;ORDER BY (data_length + index_length) DESC;&lt;\/li&gt;&lt;\/ul&gt;\"\n                            }\n                                                    }\n                    ]\n                    }\n                <\/script>\n                    \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>This article shows you how to check MySQL database and table sizes. You can do this by using the phpMyAdmin web interface or using the command-line MySQL program. Check MySQL Database Using phpMyAdmin To check the sizes of MySQL databases and tables using PHPMyAdmin, follow these steps: Log in to cPanel. After that, locate the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":22333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[253],"tags":[278,3],"class_list":["post-22277","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-linux-command","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Check MySQL database &amp; table sizes using phpMyAdmin or command line<\/title>\n<meta name=\"description\" content=\"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Check MySQL database &amp; table sizes using phpMyAdmin or command line\" \/>\n<meta property=\"og:description\" content=\"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\" \/>\n<meta property=\"og:site_name\" content=\"STS Host and Tech Knowledge base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/stshostandtech\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-28T22:37:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-29T17:18:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1166\" \/>\n\t<meta property=\"og:image:height\" content=\"411\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"HostandTech Support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Check MySQL database &amp; table sizes using phpMyAdmin or command line\" \/>\n<meta name=\"twitter:description\" content=\"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png\" \/>\n<meta name=\"twitter:creator\" content=\"@stshostandtech\" \/>\n<meta name=\"twitter:site\" content=\"@stshostandtech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"HostandTech Support\" \/>\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:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\"},\"author\":{\"name\":\"HostandTech Support\",\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/person\/141140aea3ea46eb153a44601194d042\"},\"headline\":\"Check MySQL Database And Table Sizes\",\"datePublished\":\"2022-04-28T22:37:58+00:00\",\"dateModified\":\"2022-04-29T17:18:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\"},\"wordCount\":340,\"publisher\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#organization\"},\"image\":{\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png\",\"keywords\":[\"Linux Command\",\"MysQL\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\",\"url\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\",\"name\":\"Check MySQL database & table sizes using phpMyAdmin or command line\",\"isPartOf\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png\",\"datePublished\":\"2022-04-28T22:37:58+00:00\",\"dateModified\":\"2022-04-29T17:18:16+00:00\",\"description\":\"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program\",\"breadcrumb\":{\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage\",\"url\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png\",\"contentUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png\",\"width\":1166,\"height\":411,\"caption\":\"database tables sizes\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/hostandtech.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Check MySQL Database And Table Sizes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hostandtech.com\/help\/#website\",\"url\":\"https:\/\/hostandtech.com\/help\/\",\"name\":\"STS Host and Tech Knowledge base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hostandtech.com\/help\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hostandtech.com\/help\/#organization\",\"name\":\"STS Host and Tech Inc\",\"url\":\"https:\/\/hostandtech.com\/help\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png\",\"contentUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png\",\"width\":630,\"height\":270,\"caption\":\"STS Host and Tech Inc\"},\"image\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/stshostandtech\",\"https:\/\/x.com\/stshostandtech\",\"https:\/\/www.instagram.com\/stshostandtech\",\"https:\/\/www.youtube.com\/channel\/UCqJOPwWE0ILTeIScaND7enw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/person\/141140aea3ea46eb153a44601194d042\",\"name\":\"HostandTech Support\",\"url\":\"https:\/\/hostandtech.com\/help\/author\/m-hajobied\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Check MySQL database & table sizes using phpMyAdmin or command line","description":"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program","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:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/","og_locale":"en_US","og_type":"article","og_title":"Check MySQL database & table sizes using phpMyAdmin or command line","og_description":"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program","og_url":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/","og_site_name":"STS Host and Tech Knowledge base","article_publisher":"https:\/\/www.facebook.com\/stshostandtech","article_published_time":"2022-04-28T22:37:58+00:00","article_modified_time":"2022-04-29T17:18:16+00:00","og_image":[{"width":1166,"height":411,"url":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png","type":"image\/png"}],"author":"HostandTech Support","twitter_card":"summary_large_image","twitter_title":"Check MySQL database & table sizes using phpMyAdmin or command line","twitter_description":"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program","twitter_image":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png","twitter_creator":"@stshostandtech","twitter_site":"@stshostandtech","twitter_misc":{"Written by":"HostandTech Support","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#article","isPartOf":{"@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/"},"author":{"name":"HostandTech Support","@id":"https:\/\/hostandtech.com\/help\/#\/schema\/person\/141140aea3ea46eb153a44601194d042"},"headline":"Check MySQL Database And Table Sizes","datePublished":"2022-04-28T22:37:58+00:00","dateModified":"2022-04-29T17:18:16+00:00","mainEntityOfPage":{"@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/"},"wordCount":340,"publisher":{"@id":"https:\/\/hostandtech.com\/help\/#organization"},"image":{"@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage"},"thumbnailUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png","keywords":["Linux Command","MysQL"],"articleSection":["MySQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/","url":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/","name":"Check MySQL database & table sizes using phpMyAdmin or command line","isPartOf":{"@id":"https:\/\/hostandtech.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage"},"image":{"@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage"},"thumbnailUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png","datePublished":"2022-04-28T22:37:58+00:00","dateModified":"2022-04-29T17:18:16+00:00","description":"to check MySQL database and table sizes, You can do this by using the phpMyAdmin web interface or by using the command-line MySQL program","breadcrumb":{"@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#primaryimage","url":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png","contentUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/04\/database-table-sizes.png","width":1166,"height":411,"caption":"database tables sizes"},{"@type":"BreadcrumbList","@id":"https:\/\/hostandtech.com\/help\/mysql\/check-mysql-database-and-table-sizes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hostandtech.com\/help\/"},{"@type":"ListItem","position":2,"name":"Check MySQL Database And Table Sizes"}]},{"@type":"WebSite","@id":"https:\/\/hostandtech.com\/help\/#website","url":"https:\/\/hostandtech.com\/help\/","name":"STS Host and Tech Knowledge base","description":"","publisher":{"@id":"https:\/\/hostandtech.com\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hostandtech.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hostandtech.com\/help\/#organization","name":"STS Host and Tech Inc","url":"https:\/\/hostandtech.com\/help\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png","contentUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png","width":630,"height":270,"caption":"STS Host and Tech Inc"},"image":{"@id":"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/stshostandtech","https:\/\/x.com\/stshostandtech","https:\/\/www.instagram.com\/stshostandtech","https:\/\/www.youtube.com\/channel\/UCqJOPwWE0ILTeIScaND7enw"]},{"@type":"Person","@id":"https:\/\/hostandtech.com\/help\/#\/schema\/person\/141140aea3ea46eb153a44601194d042","name":"HostandTech Support","url":"https:\/\/hostandtech.com\/help\/author\/m-hajobied\/"}]}},"_links":{"self":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts\/22277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/comments?post=22277"}],"version-history":[{"count":135,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts\/22277\/revisions"}],"predecessor-version":[{"id":22417,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts\/22277\/revisions\/22417"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/media\/22333"}],"wp:attachment":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/media?parent=22277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/categories?post=22277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/tags?post=22277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}