Big Database

  • Resolved NiceGuy211

    (@spargut)


    3 years, 1 month ago

    Hello,

    We had a big Woocommerce database with about 29.000.000 entries. wp_postmeta had about 16.300.000 entries. Can we also use this plugin?

    Thank you for this great plugin if its work.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author OllieJones

    (@olliejones)

    Yes, it should work for you.

    You may want to use wp_cli to do the rekey operation from a command line.

    wp index_mysql enable wp_postmeta

    As always, please let me know if you have problems.

    Thread Starter NiceGuy211

    (@spargut)

    Hello,

    Is the plugin compatible with Redis? because when i activate Redis on my site the CPU goes high and the max process will reach shortly. (Redis Object Cache)

    Thank you

    Simon

    Plugin Author OllieJones

    (@olliejones)

    I have tested it with Redis. I will test it again. The plugin only affects data lookups that make it past redis to the database.

    It puts no code anywhere in WordPress except to render its Dashboard page and do its work totally within that page. I don’t think it should interact with the redis-based object cache at all.

    Can you tell me more about your particular site?

    Thread Starter NiceGuy211

    (@spargut)

    Hello,

    Thank you for your fast reply.
    I check it again and same issue – i also wait 2 hours if it calms down but 2 hours max process and max cpu consumption.
    Can i send you the details via email?

    Thank you

    Plugin Author OllieJones

    (@olliejones)

    Sure, email me. You can find my contact on my Github profile …

    github[dot]com[slash]OllieJones

    Plugin Author OllieJones

    (@olliejones)

    As it turned out, this was resolved by flushing the redis Object Cache.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Big Database’ is closed to new replies.