This minor update is for those of you installing fresh on MySQL 8 (as opposed to those who upgraded to MySQL 8).
MySQL 8 by default makes the ‘information schema’ tables case-sensitive, so there was a bug that meant new installs were not spotting the indexes which had been created causing much confusion.
If you were affected, you would have seen something like this after creating the indexes:
Now that this bug is fixed, you should see the following. If you do not, please delete the indexes and then create them again.
You should see this once the indexes are created.
This is one of our key plugins to solve performance and scalability issues with WooCommerce and WordPress in general. The following items are coming soon to speed things up more:
- Optimised product variants – the way WooCommerce stores product variants is awful. I’ll fix that soon.
- Improved options for sort order – e.g. to keep sort orders in wp-admin but eliminate it and use DB ordering on the front-end
If there are other things you’d like to see, let me know.
Chat to me directly through our on-site chat bubble.
Latest posts by Dave Hilditch (see all)
- Speed up your WordPress site - June 4, 2019
- A-list third-party plugins to improve WordPress site speed - June 4, 2019
- How to analyse slow MySQL 8 performance - June 4, 2019