#T13 Halloween 2016 - Database Optimization

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...

https://wp-rocket.me/

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.