help with loading problem when adding products in WooCommerce and error when opt

  • Resolved martinsweb

    (@martinsweb)


    3 months, 3 weeks ago

    I am facing a problem and would like to know if you can help me. The scenario is as follows:

    Whenever I click on the "Add New Product" button in WooCommerce, it keeps loading indefinitely and eventually the page does not load properly. Also, when I try to publish a product, the process also gets stuck and the page crashes.

    I recently had a client with a similar issue and I was able to resolve it using your "Index WP MySQL For Speed" plugin which worked perfectly. However, for this particular client, I am having difficulty optimizing the data. Below are the tables and the number of rows in each that need to be optimized:

    LzoePrbZ_postmeta: ~12,947,555 rows
    LzoePrbZ_posts: ~235,548 rows
    LzoePrbZ_termmeta: ~46 rows
    LzoePrbZ_usermeta: ~4,810,144 rows
    LzoePrbZ_users: ~128,489 rows
    LzoePrbZ_woocommerce_order_itemmeta: ~2,879,165 rows
    The client also has a significant number of orders: 238,743 orders.

    When clicking the "Add Keys Now" button, the following error occurs:

    A timeout occurred Error code 524
    Visit cloudflare.com for more information.
    2024-12-01 17:55:49 UTC

    I would like to know:

    Is there any way to solve this problem and optimize all these items?

    Would it be possible to avoid the timeout error when trying to add the keys with the plugin?

    Are there specific settings in the plugin or on the server that I should adjust to handle databases of this size?

    How to solve this error:
    Index for table 'LzoePrbZ_postmeta' is corrupt; try to repair it

    Thank you in advance for your attention and help!
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for your question. Did you notice the words displayed at the top of the plugin’s dashboard page?

    This plugin supports?WP-CLI.?Please use it if possible: it avoids web server timeouts when changing keys on large tables. To learn more, type?wp help index-mysqlinto your command shell.

    The way to add keys to large tables without web server timeouts is to use wp-cli. Your postmeta table is quite large; it may make sense to add keys to it separately. And, it may make sense to do this sometime when your web site is quiet, when traffic is low. Use these wp-cli shell commands. The first one handles your postmeta table and the next one handles the rest of the tables.

    wp index-mysql enable LzoePrbZ_postmeta
    wp index-mysql enable --all

    You can try these commands to fix the corrupt index in your table if the enable command doesn’t help.

    wp db query "OPTIMIZE TABLE LzoePrbZ_postmeta"
    Plugin Author OllieJones

    (@olliejones)

    I haven’t heard back. If I can help you further please start another support topic. Season’s Greetings!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.