Question before using

  • Resolved bibberle

    (@bibberle)


    1 year, 5 months ago

    Hi,

    I am running a big property listing site (10k+ listings) and would like to improve the performance of my queries (which take about 1000ms).

    I installed your plugin on my staging website and it seems to work fine. Queries are working 10 times faster.

    However, I am really afraid of installing in live application and wonder if the Plugin might break anything?

    Does the plugin just ?optimize the way the data is stored“ or is it more like a huge, structural change where I should explicetly test all of my functions, test orders, …?

    Thank you in advance!

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

    (@olliejones)

    Thanks for the question!

    It just optimizes the way data is retrieved from MariaDB / MySQL. It doesn’t change anything about the organization of your data. You should not have any problems using this on your live site. You certainly don’t need a full QA cycle.

    This plugin does key optimization. In many data centers, key optimization is a routine operational maintenance task that doesn’t affect the software (in your case WordPress, WooCommerce, and plugins / themes). Large influential users of MySQL or MariaDB (facebook,airbnb, the wordpress.com hosting service) routinely do this kind of re-keying. Rest assured there would be loud howling by rich people with lots of tech clout if it didn’t work. (Plus, I have a contact or two at MariaDB, and I can howl too. But I’ve never had to.)

    • This reply was modified 1 year, 5 months ago by OllieJones.
    Thread Starter bibberle

    (@bibberle)

    Wow, thank you so much for your answer – rally appreciate it!! 2 more little questions ??

    • would you recommend to put site on maintenance mode while doing the change?
    • My postmeta table has about 1 Million rows. Should plugin be able to handle this or might it break / timeout while doing this operation?
    Plugin Author OllieJones

    (@olliejones)

    First of all, with a site that size you should use wp-cli to run the plugin’s rekeying operations, rather than the web-based user interface in Tools -> Index MySQL. The plugin’s writeup explains how. wp-cli doesn’t time out.

    wp index-mysql enable wp_postmeta

    is the basic command line to use.

    It’s possible to rekey large tables without putting the site into maintenance mode. Still, if you can schedule a maintenance window and put the site into maintenance mode, that’s a good idea; the rekeying will finish faster and your users will not experience slowness or timeouts because of MariaDB / MySQL congestion.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Question before using’ is closed to new replies.