{"id":181,"date":"2008-07-02T00:14:00","date_gmt":"2008-07-02T00:14:00","guid":{"rendered":"http:\/\/blog.trungson.com\/?p=181"},"modified":"2008-07-02T00:14:00","modified_gmt":"2008-07-02T00:14:00","slug":"show-table-status-from-mydatabasename","status":"publish","type":"post","link":"http:\/\/blog.trungson.com\/?p=181","title":{"rendered":"SHOW TABLE STATUS FROM MyDatabaseName;"},"content":{"rendered":"<p>Run that query if you would like to know basic details about a database, especially the overhead to see if you would need to optimize it.<\/p>\n<pre>\nName: AdSpeedDB\nEngine: MyISAM\nVersion: 10\nRow_format: Dynamic\nRows: 0\nAvg_row_length: 0\nData_length: 4676\nMax_data_length: 281474976710655\nIndex_length: 3072\nData_free: 4676\nAuto_increment: 221\nCreate_time: 2007-08-01 17:15:24\nUpdate_time: 2008-06-03 07:26:13\nCheck_time: NULL\nCollation: latin1_swedish_ci\nChecksum: NULL\nCreate_options:\nComment: Ad Server\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Run that query if you would like to know basic details about a database, especially the overhead to see if you would need to optimize it. Name: AdSpeedDB Engine: MyISAM Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 Data_length: 4676 Max_data_length: 281474976710655 Index_length: 3072 Data_free: 4676 Auto_increment: 221 Create_time: 2007-08-01 17:15:24 Update_time: 2008-06-03 07:26:13 Check_time: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/181"}],"collection":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=181"}],"version-history":[{"count":0,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=\/wp\/v2\/posts\/181\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.trungson.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}