Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / MySQL Server Administration  / MySQL Server Plugins  / The Rewriter Query Rewrite Plugin  /  Installing or Uninstalling the Rewriter Query Rewrite Plugin

5.5.4.1 Installing or Uninstalling the Rewriter Query Rewrite Plugin

Note

If installed, theRewriter plugin involves some overhead even when disabled. To avoid this overhead, do not install the plugin unless you plan to use it.

To install or uninstall theRewriter query rewrite plugin, choose the appropriate script located in theshare directory of your MySQL installation:

  • install_rewriter.sql: Choose this script to install theRewriter plugin and its associated elements.

  • uninstall_rewriter.sql: Choose this script to uninstall theRewriter plugin and its associated elements.

Run the chosen script as follows:

$> mysql -u root -p < install_rewriter.sqlEnter password:(enter root password here)

The example here uses theinstall_rewriter.sql installation script. Substituteuninstall_rewriter.sql if you are uninstalling the plugin.

Running an installation script should install and enable the plugin. To verify that, connect to the server and execute this statement:

mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled';+------------------+-------+| Variable_name    | Value |+------------------+-------+| rewriter_enabled | ON    |+------------------+-------+

For usage instructions, seeSection 5.5.4.2, “Using the Rewriter Query Rewrite Plugin”. For reference information, seeSection 5.5.4.3, “Rewriter Query Rewrite Plugin Reference”.