Issue when running the post_meta conversion

  • Resolved sirrahikkala

    (@sirrahikkala)


    10 months, 1 week ago

    Hey,

    We have 5,9 million rows in our post_meta table and first it had timeouts all the time when running the plugin actions but then I added the litespeed .htaccess rows which someone else had found successful. Then the conversion ran for about 15minutes and I got some error that it could not drop some ID (accidentally lost the whole error). How can I check if the post_meta table is ok now?

    • This topic was modified 10 months, 1 week ago by sirrahikkala.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the question.

    If you have that many rows, you should use wp-cli to add the keys to your table rather than trying to do it from the user interface on the dashboard panel. This is the command. wp index-mysql enable wp_postmeta

    Page caches (like the Litespeed cache) don’t have any bearing on this operation.

    If you upload your metadata (see Tools -> Index MySQL -> About) I can take a look at your situation to see whether your table is OK. But, if your site works correctly it probably is OK.

    Please upload your metadata and reply to this topic with your upload id.

    Thread Starter sirrahikkala

    (@sirrahikkala)

    Thank you for your answer. We do indeed have Litespeed but no access to wp cli due our hosting. Here is the meta ID: ehKvcT8J

    Plugin Author OllieJones

    (@olliejones)

    Thanks for the upload. Your tables, including wpse2015_postmeta, do have this plugin’s high-speed keys. Your database looks like it is configured correctly. All is well, it looks like to me.

    The version of MySQL at your hosting service, 5.7.44, came to the end of its support life last October. It is probably time for your hosting service to upgrade, or possibly for you to migrate to a more attentive service.

    Thread Starter sirrahikkala

    (@sirrahikkala)

    Hey, thanks for the info. I will pass the info about the DB version to our hosting company but since it’s partly shared platform, I doubt they will change it.

    EDIT: I see from phpmyadmin that the version is 5.7.44-cll-lve

    https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-44.html

    2023-10-25, General Availability

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Issue when running the post_meta conversion’ is closed to new replies.