----- Original Message ----
> From: Laurence Meyer <lar...@soe.ucsc.edu>
> To: mysql@lists.mysql.com
> 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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
