{"absolute_url": "/jbmckee/get-table-size/", "blog_post": false, "code": "SELECT \n     table_schema as `Database`, \n     table_name AS `Table`, \n     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` \nFROM information_schema.TABLES \nORDER BY (data_length + index_length) DESC;", "created": "2018-08-03T18:27:19.990933", "description": "", "description_rendered": "", "embed_url": "https://snipt.net/embed/43bf75d0b92ac72e6b762eb8579e0c57/", "full_absolute_url": "/jbmckee/get-table-size/", "id": 65, "lexer": "text", "line_count": 6, "log_entries": [{"code": "SELECT \n     table_schema as `Database`, \n     table_name AS `Table`, \n     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` \nFROM information_schema.TABLES \nORDER BY (data_length + index_length) DESC;", "created": "2018-08-03T18:27:20.315040", "diff": "--- \n+++ \n@@ -0,0 +1,6 @@\n+SELECT \n+     table_schema as `Database`, \n+     table_name AS `Table`, \n+     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` \n+FROM information_schema.TABLES \n+ORDER BY (data_length + index_length) DESC;", "user": "jbmckee"}], "meta": "", "modified": "2026-04-27T10:41:13.948625", "publish_date": null, "raw_url": "/raw/43bf75d0b92ac72e6b762eb8579e0c57/", "resource_uri": "/api/public/snipt/65/", "slug": "get-table-size", "stylized": "<table class=\"highlighttable\"><tr><td class=\"linenos\"><div class=\"linenodiv\"><pre><a href=\"#L-1\">1</a>\n<a href=\"#L-2\">2</a>\n<a href=\"#L-3\">3</a>\n<a href=\"#L-4\">4</a>\n<a href=\"#L-5\">5</a>\n<a href=\"#L-6\">6</a></pre></div></td><td class=\"code\"><div class=\"highlight\"><pre><span></span><span id=\"L-1\"><a name=\"L-1\"></a>SELECT \n</span><span id=\"L-2\"><a name=\"L-2\"></a>     table_schema as `Database`, \n</span><span id=\"L-3\"><a name=\"L-3\"></a>     table_name AS `Table`, \n</span><span id=\"L-4\"><a name=\"L-4\"></a>     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` \n</span><span id=\"L-5\"><a name=\"L-5\"></a>FROM information_schema.TABLES \n</span><span id=\"L-6\"><a name=\"L-6\"></a>ORDER BY (data_length + index_length) DESC;\n</span></pre></div>\n</td></tr></table>", "tags": [{"absolute_url": "/public/tag/mysqli/", "id": 1, "name": "mysqli", "resource_uri": "/api/public/tag/1/", "snipts": "/api/public/snipt/?tag=1"}, {"absolute_url": "/public/tag/mysql/", "id": 18, "name": "mysql", "resource_uri": "/api/public/tag/18/", "snipts": "/api/public/snipt/?tag=18"}, {"absolute_url": "/public/tag/sql/", "id": 22, "name": "sql", "resource_uri": "/api/public/tag/22/", "snipts": "/api/public/snipt/?tag=22"}], "title": "Get table size", "user": {"absolute_url": "/jbmckee/", "email_md5": "f4da96308b6db1b0b19738a7c105d3da", "id": 1, "resource_uri": "/api/public/user/1/", "snipts": "/api/public/snipt/?user=1", "snipts_count": 72, "username": "jbmckee"}}