{"id":49,"date":"2008-02-15T17:23:40","date_gmt":"2008-02-15T22:23:40","guid":{"rendered":"http:\/\/pessoal.org\/blog\/?p=49"},"modified":"2008-06-26T19:10:03","modified_gmt":"2008-06-27T01:10:03","slug":"thousands-of-tables-in-a-mysql-database","status":"publish","type":"post","link":"https:\/\/pessoal.org\/blog\/2008\/02\/15\/thousands-of-tables-in-a-mysql-database\/","title":{"rendered":"Thousands of tables in a MySQL database"},"content":{"rendered":"<p>Just read about the <a href=\"http:\/\/www.askbjoernhansen.com\/2008\/02\/14\/10000_tables_in_one_mysql_database.html\">potential performance implications<\/a> of having thousands of tables in a single MySQL database over at <a href=\"http:\/\/www.askbjoernhansen.com\">Ask Bj\u00f8rn Hansen&#8217;s blog<\/a>.<\/p>\n<p>We have that type of setup at <a href=\"http:\/\/alertlogic.net\">Alert Logic<\/a>, but I don&#8217;t remember any problems while shutting down the database server. I wonder if the <tt>FLUSH TABLES<\/tt> problem only happens that badly under MyISAM instead of InnoDB?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Just read about the potential performance implications of having thousands of tables in a single MySQL database over at Ask Bj\u00f8rn Hansen&#8217;s blog. We have that type of setup at Alert Logic, but I don&#8217;t remember any problems while shutting down the database server. I wonder if the FLUSH TABLES problem only happens that badly [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,9],"tags":[],"_links":{"self":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/posts\/49"}],"collection":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":0,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"wp:attachment":[{"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pessoal.org\/blog\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}