On Mon, 2008-08-18 at 22:29 -0400, Jay Pipes wrote: > Brian Aker wrote: > > Hi! > > > > On Aug 18, 2008, at 6:44 PM, Baron Schwartz wrote: > > > >> Yeah, do we really need SHOW anymore at all? I would argue not. > > > > I go back and forth on this. > > > > Right now I believe: > > 1) Keeping them in the client I think is a win. > > 2) Right now we need them because for replication not everything is in I_S. > > 3) SHOW CREATE TABLE is required no matter what... or we have to find > > some similar syntax (I personally find it really useful). > > Again, I return to the idea that SHOW and other commands like DESC can > be implemented as a raw string replacement on the client. Basically, > convert SHOW TABLES to SELECT TABLE_NAME.TABLE FROM INFORMATION_SCHEMA, > etc... >
If we are going to do this as queries to INFORMATION_SCHEMA and use INNODB. We should consider setting innodb_stats_on_metadata=0 as the default. Till this option was available INFORMATION_SCHEMA was pretty much unusable in our environment for performance reasons. --Koa
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
