multisite and wp_load_alloptions (4 posts)

  1. tsuruta
    Posted 4 years ago #

    When multisite is 'on' too many database queries are called, and bursts network bandwidth between web server and database server.

    The query is below.
    "SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'"

    This is caused by a limitation of object cache and multisite.
    When multisite is on, wordpress cannot use wp_cache_get for that query in wp_load_alloptions function.

    Moreover, wp_load_alloptions is called when each get_option function is executed.
    If wp_options table has huge data (ex. serialized 'rewrite_rule'), it costs so many time.
    Perhaps, it's a solution of multisite confusion by wp_cache_get, but it causes another problem.

    I think, even no object cacheing is better than so many database query.

  2. whiteatom
    Posted 4 years ago #

    Are you having a problem or is this a suggestion for improvement?

  3. tsuruta
    Posted 4 years ago #

    Yes, I have a problem.
    And try to solve that...

  4. whiteatom
    Posted 4 years ago #

    Ok.. what is your problem? There are a lot of database queries.. but are they causing an error?

    If you are having a problem with too man options being loaded.. maybe you have too many plugins?

    I'm sorry, but it's not clear what you want from the community.


Topic Closed

This topic has been closed to new replies.

About this Topic