
#T13 Halloween 2016 - Database Optimization
- 09:06
- October 13th 2016
Just like a computer (Windows) you need to take care of your MYSQL database, otherwise you will start to see performance issues. Here is how you can take care of your database.
WP Sweep
Use with care
https://en-gb.wordpress.org/plugins/wp-sweep/
WP Rocket
Caching with optimization baked in! Nice...
How to use the optimize and repair in WordPress
First paste this into your wp-config.php:
define( 'WP_ALLOW_REPAIR', true );
Then go to /wp-admin/maint/repair.php on your website and follow the onscreen instructions. Don't forget to remove that line when you are done!
WP Optimize
Use with care
https://en-gb.wordpress.org/plugins/wp-optimize/
Complete Guide by WPMU
Brilliant guide unpacking database optimisation and the tools and snippets you can use.
https://premium.wpmudev.org/blog/optimizing-your-wordpress-database-a-complete-guide/
---
OUR EVENT:
Do you want to make real change in your business? Join us at our in-person event Agency Transformation Live
Meet Troy Dean; Lee Jackson, Chris Ducker, Kelly Baader, Amy Woods, Paul Lacey, Dave Foy and other legends in this fantastic conference focused on actionable steps that you can use to transform your agency.
---
See acast.com/privacy for privacy and opt-out information.
Trailblazer FM: WordPress without the drama
For agencies and developers who want fewer WordPress headaches.
Lee Matthew Jackson brings practical advice, real-world problem-solving conversations, and the occasional dad joke… all to help you build smarter, deliver faster, and enjoy the work again.
PS: Troll-free zone. If you want a fight, go to X.