regulation on SQL rules update

  • Resolved opswordpress

    (@opswordpress)


    5 years, 2 months ago

    Hello

    I would like to limitate the writes in tables options about redirection.
    Each 30 minutes the rules are emptied

    UPDATEwpl_XX_optionsSEToption_value= '' WHEREoption_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

    (@johnny5)

    5 years, 2 months ago

    Why do you think this is part of Redirection?

    Thread Starter opswordpress

    (@opswordpress)

    5 years, 2 months ago

    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

    (@johnny5)

    5 years, 2 months ago

    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

    (@opswordpress)

    5 years, 2 months ago

    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

    (@johnny5)

    5 years, 2 months ago

    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

    (@opswordpress)

    5 years, 2 months ago

    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.