----- 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.