The ddl_rewriter Plugin ddl_rewriter  examines SQL statements received by the server prior to parsing, rewriting them according to these conditions: If  ddl_rewriter  rewrites a statement, it generates a warning: If the general query log or binary log is enabled, the server writes to it statements as they appear after any rewriting by  ddl_rewriter . When installed,  ddl_rewriter  exposes the Performance Schema  memory/rewriter/ddl_rewriter instrument for tracking plugin memory use. See Section 27.12.20.10, “Memory Summary Tables” This section describes how to install or uninstall the  ddl_rewriter  plugin. For general information about installing plugins, see Section 5.6.1, “Installing and Uninstalling Plugins” . If installed, the  ddl_rewriter  plugin involves some minimal overhead even when disabled. To avoid this overhead, install  ddl_rewriter  only for the period during which you intend to use it. The primary use case is modification of statements restored from dump files, so the typical usage pattern is: 1) Install the plugin; 2) restore the dump file or files; 3) uninstall the plugin. To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the  plugin_dir  system variable). If necessary, configure the plugin directory location by setting the value of  plugin_dir  at server startup. The plugin library file base name is  ddl_rewriter . The file name suffix differs per platform (for example, .so  for Unix and Unix-like systems,  .dll  for Windows). 1096 Note 5.6.5.1 Installing or Uninstalling ddl_rewriter • ddl_rewriter  considers only  CREATE TABLE  statements, and only if they are standalone statements that occur at the beginning of an input line or at the beginning of prepared statement text. ddl_rewriter  does not consider  CREATE TABLE  statements within stored program definitions. Statements can extend over multiple lines. •Within statements considered for rewrite, instances of the following clauses are rewritten and each instance replaced by a single space: • ENCRYPTION • DATA DIRECTORY  (at the table and partition levels) • INDEX DIRECTORY  (at the table and partition levels) •Rewriting does not depend on lettercase. mysql>  CREATE TABLE t (i INT) DATA DIRECTORY ’/var/mysql/data’; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql>  SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1105 Message: Query ’CREATE TABLE t (i INT) DATA DIRECTORY ’/var/mysql/data’’ rewritten to ’CREATE TABLE t (i INT) ’ by a query rewrite plugin 1 row in set (0.00 sec)