On Thu, Oct 02, 2008 at 04:44:55PM +0200, Paul McCullagh wrote: > I agree, this would be a useful addition... > On Oct 2, 2008, at 4:13 PM, Tim Soderstrom wrote: >> I did indeed notice that behavior and it does seem to work well. I >> guess it's sort of a minor annoyance since I'm a purist when it comes >> to databases (I hate when people mount an EXT3 volume directly to >> /var/lib/mysql since, among other bad things, it creates a 'lost >> +found' database). That said, I think having MySQL/Drizzle devote a >> special directory for engines would be nice. For instance, /var/lib/ >> drizzle/pbxt could become /var/lib/drizzle/engines/pbxt where >> 'engines' is a reserved directory of sorts so that it doesn't show up >> in the list.
I've thought about this a bit as well... moving to discovery based data dictionary (and no more FRM), for engines such as InnoDB which can store all data in a single set of files, the directories for databases no longer make much sense. In fact, we shouldn't be thinking about table discovery, but full path discovery (database included). We've had table discovery in NDB since day 1 - the database discovery is a side-effect of all the nasty things we go through for replicating DDL (and a mysqld won't discover the database if it was offline during the DDL). So we probably need a 'show databases' handlerton call or something... then we could just call it and ignore any directories in the datadir. Of course, what to do about engines without a data dictionary? Perhaps a nice default implementation that does directory per engine or some other such convention. There then comes the interesting thing of if you have ables in engine X, then disable engine X, you'll be able to create tables of the same name in engine Y. Although I'm about happy with the "then you get what you deserve" approach in that case. -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
