Analyze Table

  • Resolved CamZL1

    (@danishhaidri)


    10 months, 4 weeks ago

    Hello @olliejones,

    Thank you for this plugin. I have just received the update for 1.4.2. and noticed your note: Do ANALYZE TABLE after each rekeying operation.

    For someone who has no idea about DB Tables, what do I do? Will this update result in DB errors? How do I analyse table?

    Sorry for the multiple questions but if this update results in any critical errors than we have no skills to fix them unfortunately. ??

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

    (@olliejones)

    ANALYZE TABLE table_name inspects the contents of a table to refresh key statistics. What are key statistics? They’re information internal to your MariaDB or MySQL server that help it decide which keys to use to satisfy queries.

    The plugin does this for you; you don’t need to do it yourself. If the plugin encounters errors it deals with them correctly.

    Thread Starter CamZL1

    (@danishhaidri)

    Thank you so much for clarifying this to a novice Ollie. We are using the latest version of MariaDB running on PHP8.2. BTW since we are not an e-commerce platform with WC products/search, is this plugin still relevant for us? Does this plugin help with things like blog search or job search on the website?

    Plugin Author OllieJones

    (@olliejones)

    High-performance keys on your database tables help WordPress run faster when you have many posts or users. These keys work by exploiting features in recent versions of MariaDB and MySQL that aren’t used by standard WordPress. Standard WordPress can’t use them because it has to be compatible with MySQL 5.5 and 5.6, which don’t have the superior features.

    If you want to improve the performance of search (when users type things into the search box) I suggest you try Mikko Saari’s Relevanssi search plugin. Mikko replaced the slow native WordPress search algorithms with something substantially better.

    • This reply was modified 10 months, 4 weeks ago by OllieJones.
    Thread Starter CamZL1

    (@danishhaidri)

    Thank you and best wishes for 2024!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Analyze Table’ is closed to new replies.