{"id":28478,"date":"2024-03-16T10:24:46","date_gmt":"2024-03-16T10:24:46","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/"},"modified":"2024-03-22T13:33:18","modified_gmt":"2024-03-22T13:33:18","slug":"querying-the-amount-of-data-in-all-tables-of-the-mysql-database","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/","title":{"rendered":"Querying the amount of data in all tables of the MySQL database."},"content":{"rendered":"<p>You can use the following SQL statement to query the data size of all tables in a MySQL database:<\/p>\n<pre class=\"post-pre\"><code>SELECT \r\n    TABLE_SCHEMA AS 'Database',\r\n    TABLE_NAME AS 'Table',\r\n    TABLE_ROWS AS 'Row Count'\r\nFROM\r\n    INFORMATION_SCHEMA.TABLES\r\nWHERE\r\n    TABLE_TYPE = 'BASE TABLE'\r\n    AND TABLE_SCHEMA NOT IN ('information_schema', 'mysql', 'performance_schema', 'sys')\r\nORDER BY\r\n    TABLE_SCHEMA,\r\n    TABLE_NAME;\r\n<\/code><\/pre>\n<p>This query will return the database names, table names, and row counts for each table. Please note that the above query will not include views and temporary tables. You can use the WHERE clause to filter out specific databases as needed (such as information_schema, mysql, performance_schema, and sys).<\/p>\n<p>This query utilizes the built-in information schema of MySQL, which provides metadata information about databases, tables, and columns.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use the following SQL statement to query the data size of all tables in a MySQL database: SELECT TABLE_SCHEMA AS &#8216;Database&#8217;, TABLE_NAME AS &#8216;Table&#8217;, TABLE_ROWS AS &#8216;Row Count&#8217; FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = &#8216;BASE TABLE&#8217; AND TABLE_SCHEMA NOT IN (&#8216;information_schema&#8217;, &#8216;mysql&#8217;, &#8216;performance_schema&#8217;, &#8216;sys&#8217;) ORDER BY TABLE_SCHEMA, TABLE_NAME; This query will return the database [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-28478","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Querying the amount of data in all tables of the MySQL database. - Blog - Silicon Cloud<\/title>\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.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Querying the amount of data in all tables of the MySQL database.\" \/>\n<meta property=\"og:description\" content=\"You can use the following SQL statement to query the data size of all tables in a MySQL database: SELECT TABLE_SCHEMA AS &#039;Database&#039;, TABLE_NAME AS &#039;Table&#039;, TABLE_ROWS AS &#039;Row Count&#039; FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = &#039;BASE TABLE&#039; AND TABLE_SCHEMA NOT IN (&#039;information_schema&#039;, &#039;mysql&#039;, &#039;performance_schema&#039;, &#039;sys&#039;) ORDER BY TABLE_SCHEMA, TABLE_NAME; This query will return the database [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T10:24:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T13:33:18+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Taylor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"Querying the amount of data in all tables of the MySQL database.\",\"datePublished\":\"2024-03-16T10:24:46+00:00\",\"dateModified\":\"2024-03-22T13:33:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\"},\"wordCount\":99,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\",\"name\":\"Querying the amount of data in all tables of the MySQL database. - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T10:24:46+00:00\",\"dateModified\":\"2024-03-22T13:33:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Querying the amount of data in all tables of the MySQL database.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Querying the amount of data in all tables of the MySQL database. - Blog - Silicon Cloud","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.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"Querying the amount of data in all tables of the MySQL database.","og_description":"You can use the following SQL statement to query the data size of all tables in a MySQL database: SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table', TABLE_ROWS AS 'Row Count' FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA NOT IN ('information_schema', 'mysql', 'performance_schema', 'sys') ORDER BY TABLE_SCHEMA, TABLE_NAME; This query will return the database [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T10:24:46+00:00","article_modified_time":"2024-03-22T13:33:18+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"Querying the amount of data in all tables of the MySQL database.","datePublished":"2024-03-16T10:24:46+00:00","dateModified":"2024-03-22T13:33:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/"},"wordCount":99,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/","url":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/","name":"Querying the amount of data in all tables of the MySQL database. - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T10:24:46+00:00","dateModified":"2024-03-22T13:33:18+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/querying-the-amount-of-data-in-all-tables-of-the-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Querying the amount of data in all tables of the MySQL database."}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/28478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=28478"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/28478\/revisions"}],"predecessor-version":[{"id":62779,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/28478\/revisions\/62779"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=28478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=28478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=28478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}