index-wp-mysql-for-speed
index-wp-mysql-for-speed copied to clipboard
OllieJones
LearnDash Support
I also have a few LearnDash sites setup with a HUGE number of users/postmeta, etc, and I think this could be very beneficial as well especially on LearnDash's custom tables (will need to test and check structures)
I'll probably work on setting up a local instance of one of them to test this on and start a monitor this week, is there anything else I can get that would possibly help with this?
I've been a full time WordPress developer for 10+ years but MySQL is definitely not my strong suite (i'm dangerously OKAY 😛 ), so would like to try and contribute as well in any way possible
Sweet! Happy to have help!
I'm about to push version 1.4.1 of the plugin. Once you have it, please use the Monitor feature to capture some of the slow stuff around LearnDash -- start the monitor, then do the slow stuff on the site. You can view the monitor to see what's slow, or upload it so we can take a look.
1.4.2 is out, with a couple of mop-up bug fixes from 1.4.1. No index changes. It would be great to see a monitor with some significant LearnDash traffic in it.
Awesome! Been swamped with work but trying to get you something, I realized when i first ran some of the test I had already done a ton of optimizations ourselves so i'm trying to find an older backup i can restore locally to test on before we made those changes (so it's as basic LearnDash as possible without any DB or code changes)
The LearnDash LMS plugin custom database tables are the following.
wp_learndash_user_activity
wp_learndash_user_activity_meta
https://www.learndash.com/support/docs/developers/database-info/
@tripflex - Please provide samples of the typical queries your plugin generates. I can promptly give you improved indexes. You can probably change the schemas quickly in your plugin (unlike the difficulty we are having with WP, itself). If any of your queries need modifications to the WP schemas, we will look into that.
