So, the data dictionary in MySQL consists of the tables in the INFORMATION_SCHEMA tables, particularly in 6.0+ where I believe almost all of the SHOW commands are now in a table in INFORMATION_SCHEMA (most notably missing are the InnoDB-related SHOW statements, such as SHOW ENGINE INNODB STATUS and SHOW MUTEX STATUS, but I believe pretty much everything else is represented -- feel free to correct me if I'm wrong).
Anyway, how is Drizzle doing its data dictionary? Actually, this somewhat is also the question of "how does MySQL do its data dictionary" -- the manual calls the information_schema tables "views" on hidden base tables; however 9 out of the 42 tables in 6.0's information_schema are of the Maria table type, the other 33 are memory. Doing SHOW CREATE TABLE shows that they are temporary tables, not views..... So, a few questions as to how MySQL does it, and hopefully a discussion on how Drizzle should do it: 1) Are the information_schema tables views or temporary tables? 2) Where are the definitions stored for the information_schema tables? 3) How and when do the definitions get loaded? I see these questions (particularly #3) as important particularly for plugins, as some plugins will (heck, I'd probably argue that most of the major ones *should*) add to the information_schema database. -- - Sheeri K. Cabral
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
