On Tue, Oct 14, 2008 at 1:20 PM, Arjen Lentz <[EMAIL PROTECTED]> wrote: > Hi Mark > > On 15/10/2008, at 12:15 AM, MARK CALLAGHAN wrote: >> >> On Mon, Oct 13, 2008 at 9:25 PM, Arjen Lentz <[EMAIL PROTECTED]> >> wrote: >>> >>> You'll be happy to know that these enhancements are like a prime selling >>> point, knowing which indexes are actually getting used is soooo useful. >>> >>> Does the INDEX_STATISTICS keyword (and the others) actually need to be >>> reserved words? >>> They are now, as the equivalent information_schema tables need to be >>> backtick quoted in a query to not chuck a syntax error. >> >> We have been lax about this for many of the changes we made to the >> parser. It doesn't need to be a keyword. > > Okidoki, then we're on the same page. Thanks. > > In fact, I know the v1 heritage for this, but it might make sense for us to > just remove the SHOW part of things and make it a pure INFORMATION_SCHEMA > thing. Sorts out the above also, and in time someone could then turn it into > a 5.1 plugin. > > > And on that note... there's thoughts for creating a separate schema for this > and similar stuff. > Either a single STATISTICS_SCHEMA.*, or like GLOBAL_STATISTICS.* and > SESSION_STATISTICS.* > Right now the infoschema namespace is becoming seriously polluted with > things that don't really belong there (since infoschema is a standard SQL > thing). > What do you reckon about that... of course it is a more significant change, > but adding a schema in itself is not complicated (I've done it myself once, > long ago) > > Comments form others welcome too, of course! I wouldn't see this changed > immediately, but we could stick it in a blueprint to keep it in mind.
Our toolchain still uses SHOW commands so we have yet to add support for the IS. One day we will get there. I am glad that others have done that to the patch. > > > Cheers, > Arjen. > -- > Arjen Lentz, Director @ Open Query (http://openquery.com.au/) > Training and Expertise for MySQL in Australia and New Zealand > > OurDelta: free enhanced builds for MySQL @ http://ourdelta.org/ > > > > -- Mark Callaghan [EMAIL PROTECTED] _______________________________________________ Mailing list: https://launchpad.net/~ourdelta-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~ourdelta-developers More help : https://help.launchpad.net/ListHelp
