Daniel and I and the Percona release engineering team are proud to announce version 1.0.1 of Percona Toolkit. This toolkit is Percona’s suite of DBA and sysadmin productivity tools for MySQL. It is the successor to the popular Maatkit and Aspersa toolkits. Percona Toolkit is available for immediate download at percona.com/downloads/percona-toolkit/.
The latest Percona Server release has one new feature: now MEMORY tables can have BLOB and TEXT columns, and VARCHAR columns will not waste space due to implicit extension to CHAR.
The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one of the long-standing limitations caused by the fact that variable-length records were not supported by the engine. This is true for all MySQL versions, including the latest 5.6 development tree as of last week.
Revision 68 of common_schema is out, and includes some interesting features:
I've just implemented an eval() call for MySQL. It is implemented with SQL, using a stored procedure. So this is not some plugin: you can use it from within your normal database server.
In some programming languages it would mean: get some text, and execute it as though it were complied code. So, dynamic coding.
In SQL: get the text of query which generates SQL statements in itself (either DML or DDL), and invoke those implied SQL statements.