I am rather excited about being able to do awesome things such as this to get the current configuration of your server:
drizzle> SELECT NAME,VALUE -> FROM DATA_DICTIONARY.INNODB_CONFIGURATION -> WHERE NAME IN ("data_file_path", "data_home_dir"); +----------------+-------+ | NAME | VALUE | +----------------+-------+ | data_file_path | NULL | | data_home_dir | ./ | +----------------+-------+ 2 rows in set (0 sec) drizzle> SELECT NAME,VALUE -> FROM DATA_DICTIONARY.INNODB_CONFIGURATION -> WHERE NAME IN ("data_file_path", "data_home_dir"); +----------------+-------+ | NAME | VALUE | +----------------+-------+ | data_file_path | NULL | | data_home_dir | ./ | +----------------+-------+ 2 rows in set (0 sec) drizzle> SELECT NAME,VALUE -> FROM DATA_DICTIONARY.INNODB_CONFIGURATION -> WHERE NAME = "io_capacity"; +-------------+-------+ | NAME | VALUE | +-------------+-------+ | io_capacity | 200 | +-------------+-------+ 1 row in set (0 sec)
Coming soon: status in a table.
(this is for the upcoming embedded_innodb plugin, which using the API provided by Embedded InnoDB to implement a Storage Engine for Drizzle)
Thanks You for the update.
I will keep updating in wiki.. but yet to catchup with all of you.