{"id":620,"date":"2014-03-17T16:48:43","date_gmt":"2014-03-17T09:48:43","guid":{"rendered":"http:\/\/blog.trichev.com\/?p=620"},"modified":"2017-08-10T09:26:57","modified_gmt":"2017-08-10T02:26:57","slug":"mysql-table-size","status":"publish","type":"post","link":"https:\/\/trichev.com\/blog\/2014\/03\/17\/mysql-table-size\/","title":{"rendered":"MySQL. Table size"},"content":{"rendered":"<pre><code>SELECT\r\n    table_name AS table_name,\r\n    engine,\r\n    ROUND(data_length\/1024\/1024,2) AS total_size_mb,\r\n    table_rows\r\nFROM\r\n    information_schema.tables\r\nWHERE\r\n    table_schema=DATABASE(); \/\/or just <\/code><code>table_schema='table_name';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SELECT table_name AS table_name, engine, ROUND(data_length\/1024\/1024,2) AS total_size_mb, table_rows FROM information_schema.tables WHERE table_schema=DATABASE(); \/\/or just table_schema=&#8217;table_name&#8217;;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[231],"tags":[32,192,28,14,11],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts\/620"}],"collection":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/comments?post=620"}],"version-history":[{"count":1,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts\/620\/revisions"}],"predecessor-version":[{"id":621,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/posts\/620\/revisions\/621"}],"wp:attachment":[{"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/media?parent=620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/categories?post=620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trichev.com\/blog\/wp-json\/wp\/v2\/tags?post=620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}