Hi, I am Google Summer of Code student working on adding Drizzle support to phpMyAdmin (and, of course, working under phpMyAdmin). I started to look into differences to MySQL I would like to ask for some help in figuring out some information placement.
1. Most of data from information_schema.tables is in DATA_DICTIONARY.TABLES, but not all. I would like to know whether I can get values (or their estimates) of: TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH, MAX_DATA_LENGTH, INDEX_LENGTH, DATA_FREE, CHECKSUM, CREATE_OPTIONS. At least some estimation of table sizes (in bytes) would be useful. As for row counts, I found INNODB_SYS_TABLESTATS.NUM_ROWS (how accurate is it?), but I'm wondering whether there is a more generic way to access this information instead of looking into each storage plugin's tables. 2. Is there any documentation on InnoDB tables in data_dictionary? MySQL docs are incomplete and seem too unreliable with all these question marks in descriptions. 3. I can reconstruct at least some data of SHOW ENGINES by joining PLUGINS and MODULES tables (plugin name + some description), is there anything more I can do? I will probably be returning with new questions, I hope you won't get tired of me ;) -- Best regards, Piotr Przybylski _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
