Massive wp_postmeta table

  • Resolved chrisdperry91

    (@chrisdperry91)


    2 years, 10 months ago

    Hello, this plugin has worked great for me for the time I have been using it but I still have not been able to rekey my very large wp_postmeta table. I have tried several times with several different versions of this plugin but it always ends in a timeout or database errors partial way through the process. Server is on dedicated hosting.

    Are there any steps I can take to try and get this to successfully complete the rekey for wp_postmeta. Run commands in phpMyadmin? wp-cli? Any database adjustments I can make beforehand? Table is approx. 10.7M rows.

    Metadata uploaded to j3cjcDKU. Thanks!

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

    (@olliejones)

    Thanks for the upload. Yeah, ten megarows in wp_postmeta, that’s a lot. Did you try using wp-cli to do the rekeying operation?

    wp index-mysql enable wp_postmeta

    is how you do that. With a table that size you may want to pick a quiet time on your site.

    • This reply was modified 2 years, 10 months ago by OllieJones.
    Thread Starter chrisdperry91

    (@chrisdperry91)

    Yes, tried wp-cli the site never crashes and server never shows a dangerous load, while monitoring with phpMyadmin it always loses database connection around 15 minutes into the “altering tables” process.

    Plugin Author OllieJones

    (@olliejones)

    Great. The way php works (either in WordPress or in phpmyadmin or whatever), the web timeouts are a huge freaking hassle. But php-based web servers servers couldn’t survive heavy loads without the timeouts to clear out stuck requests.

    One wishes php 9.0 would figure out some kind of concurrency like nodejs or threading like inside nginx or in IIS.

    Thanks for the followup.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Massive wp_postmeta table’ is closed to new replies.