----- Original Message ----
> From: Laurence Meyer <[email protected]>
> To: [email protected]
> 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/[email protected]

Reply via email to