Title: regulation on SQL rules update
Last modified: March 29, 2021

---

# regulation on SQL rules update

 *  Resolved [opswordpress](https://wordpress.org/support/users/opswordpress/)
 * (@opswordpress)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/)
 * Hello
 * I would like to limitate the writes in tables options about redirection.
    Each
   30 minutes the rules are emptied
 * `UPDATE`wpl_XX_options`SET`option_value`= '' WHERE`option_name`= 'rewrite_rules'`
 * Then another update to re set the rules.
 * On a big multisite wordpress installation, with binary logs activated, it generates
   a lot of entries for sites that don’t have much backend activity.
 * Is there possible to disable this feature and have theses rules updated only 
   when needed ? Or maybe there is a hook triggered wrongly, then i need to learn
   about it.
 * Thank you

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [John Godley](https://wordpress.org/support/users/johnny5/)
 * (@johnny5)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14248960)
 * Why do you think this is part of Redirection?
 *  Thread Starter [opswordpress](https://wordpress.org/support/users/opswordpress/)
 * (@opswordpress)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14248986)
 * Hello John
    I can share the update SQL queries, definitly triggered by the plugin
   in my opinion :
 * UPDATE `wpl_XX_options` SET `option_value` = ” WHERE `option_name` = ‘rewrite_rules’
   
   UPDATE `wpl_XX_options` SET `option_value` = ‘a:126:{s:19:\”sitemap_index\\.xml
   $\”;s:19:\”index.php?sitemap= …… WHERE `option_name` = ‘rewrite_rules’
 * Just need to understand how and why the plugin trigger theses updates.
 *  Plugin Author [John Godley](https://wordpress.org/support/users/johnny5/)
 * (@johnny5)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14248993)
 * Sure, but why do you think Redirection is doing this? It doesn’t change the rewrite
   rules, and it appears to be related to a sitemap.
 *  Thread Starter [opswordpress](https://wordpress.org/support/users/opswordpress/)
 * (@opswordpress)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14249269)
 * i supposed having the “rewrite_rules” updated is caused by a hook in Redirection
   plugin.
    If your plugin does not write in this option field, then i’m just sorry
   🙂
 *  Plugin Author [John Godley](https://wordpress.org/support/users/johnny5/)
 * (@johnny5)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14249347)
 * You said it was definitely triggered by the plugin so I assumed you’ve tested
   this and found it was doing it? If not, then no, the plugin is not involved with
   rewrites.
 *  Thread Starter [opswordpress](https://wordpress.org/support/users/opswordpress/)
 * (@opswordpress)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14249398)
 * ok. Thank you for the quick answer !

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘regulation on SQL rules update’ is closed to new replies.

 * ![](https://ps.w.org/redirection/assets/icon-256x256.jpg?rev=983639)
 * [Redirection](https://wordpress.org/plugins/redirection/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/redirection/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/redirection/)
 * [Active Topics](https://wordpress.org/support/plugin/redirection/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/redirection/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/redirection/reviews/)

## Tags

 * [wp_options](https://wordpress.org/support/topic-tag/wp_options/)

 * 6 replies
 * 2 participants
 * Last reply from: [opswordpress](https://wordpress.org/support/users/opswordpress/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/regulation-on-sql-rules-update/#post-14249398)
 * Status: resolved