Wordpress InnoDB or MyISAM ?

DenisMNE · Apr 20, 2018

Hello!

For Wordpress users, which one do you use as an engine for storage ?

InnoDB or MyISAM ?

Which one is better ?

KnownHost-DanielP · Apr 20, 2018

Sadly InnoDB is the way to go. The big difference between them is that when performing certain actions InnoDB only locks a single row of a database table, where-as MyISAM locks the entire table during the operation. So your main advantage is table vs row locking which allows InnoDB to out perform MyISAM when it comes to write operations.

Now here's the tricky part, MyISAM is a LOT easier to repair/recover from where-as InnoDB is much more apt to suffer corruption as it uses a couple of methods to index changes / actions so a lot more moving parts to get out of sync.

Regardless I think InnoDB wins as long as managed properly as backups are very important!

Wordpress InnoDB or MyISAM ?

DenisMNE

Well-known member

KnownHost-DanielP

Well-known member

DenisMNE

Well-known member

KnownHost-DanielP

Well-known member

DenisMNE

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud