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.