Rewriter plugin operation uses a stored procedure that loads the rules table into its in-memory cache, and a helper loadable function. Under normal operation, users invoke only the stored procedure. The function is intended to be invoked by the stored procedure, not directly by users.
flush_rewrite_rules()
This stored procedure uses the load_rewrite_rules() function to load the contents of the rewrite_rules table into the Rewriter in-memory cache.
Calling flush_rewrite_rules() implies COMMIT.
Invoke this procedure after you modify the rules table to cause the plugin to update its cache from the new table contents. If any errors occur, the plugin sets the message column for the appropriate rule rows in the table and sets the Rewriter_reload_error status variable to ON.
This function is a helper routine used by the flush_rewrite_rules() stored procedure.