216 - 'D' is for Database

February 11, 2021 00:51:33
216 - 'D' is for Database
WP Builds
216 - 'D' is for Database

Feb 11 2021 | 00:51:33

/

Show Notes

0.75x
1x
1.25x
1.5x
2x
0:00
...

‘A-Z of WordPress’ with Nathan Wrigley and David Waumsley

It’s the 4th in our series of chats called ‘the A-Z of WordPress’ where we attempt to cover all the major aspects of building and maintaining sites with WordPress.

Today, we are really going set pulses racing with the letter ‘D’ for Database!

Use these show notes to follow along with the podcast audio.

Preamble

The word alone sounds incredibly dull, and for years I pretended it did not exist. Even now I do anything to avoid directly interacting with it.

Are they running too many unnecessary and inefficient queries?

Do they clean themselves up after deletion?

Do I want a WordPress solution that may affect performance when there are 3rd party plugins adding to the database.

One good things to come out of GDPR is that a lot of plugin have to provide way to automatically clear up data.

Other points

What are WordPress’ requirements ?

MySQL version 5.6 or greater OR MariaDB version 10.1 or greater.

Maria being faster, but newer and less used so certainty of support is perhaps a question. https://www.guru99.com/mariadb-vs-mysql

For no good reason at all, here’s a list of the standard WordPress tables:

Would the ideal be that you could move easily from one to the other (I think Cloudways allows one click transfers?). I have moved sites from MariaDB to MySQL with no real issues – only a couple of disconnected images.

Tools to help with database management:

Tried:

WP phpMyAdmin

Advanced Database Cleaner

MainWP Maintenance extension

WP Rocket (also does a clean up)

WP Reset

https://wordpress.org/plugins/wp-dbmanager

https://wordpress.org/plugins/wp-optimize

https://wordpress.org/plugins/wp-sweep

https://wordpress.org/plugins/better-search-replace

Never tried:

https://wordpress.org/plugins/wp-clean-up-optimizer

https://codecanyon.net/item/wp-cleaner-pro/21459036https://codecanyon.net/item/smart-cleanup-tools/3714047

When building sites:

https://wordpress.org/plugins/query-monitor (helps find duplicates and slow queries)

https://wordpress.org/plugins/usagedd (simple, shows speed/number of queries when in a Page Builder editor)

Conclusions:

It’s likely that you now know less about databases than you did before you came to this page. That’s a measure our understanding of databases. They’re weird things and, honestly, most of it is Voodoo.

Unless you know what you’re doing, stay away – there be monsters!

Let’s hope that when we get to the next letter… ‘E’, we know a little more. Hope is a good thing, if not always well placed!

Other Episodes

Episode 0

December 10, 2024 01:35:00
Episode Cover

This Week in WordPress #318

The WordPress news from the last week which commenced Monday 2nd December 2024.

Listen

Episode 0

July 13, 2023 00:51:49
Episode Cover

334 - Building a platform: helping developers commercialise their projects

On the podcast today we have Vova Feldman, the founder of Freemius. Vova is an entrepreneur with a passion for software development. He was...

Listen

Episode

October 15, 2018 00:18:23
Episode Cover

WP Builds Newsletter #34 - Help needed with Gutenberg, Elementor adds Custom Fields integrations and DuckDuckGo on the rise

Listen