List:General Discussion« Previous MessageNext Message »
From:Glyn Astill Date:August 16 2009 1:41pm
Subject:Re: show tables is slow/uncached
View as plain text  

----- Original Message ----
> From: Laurence Meyer <larrym@stripped>
> To: mysql@stripped
> Sent: Sunday, 16 August, 2009 7:09:25
> Subject: show tables is slow/uncached
> We have a production database that has 4,000+ tables. For a variety of reasons, 
> our CGIs always
> have to run "show tables" to generate a list of all tables in the database.

> Does anyone know why "show tables" is so slow?
> Is there any way to speed this up?

Unless it's a general database performance issue, or something where there's a mysql
specific workaround you could use memcached to save hitting the database at all.

show tables is slow/uncachedLaurence Meyer16 Aug
  • Re: show tables is slow/uncachedGlyn Astill16 Aug
  • Re: show tables is slow/uncachedDan Nelson17 Aug