KnownHost-DanielP
Well-known member
- Joined
- Mar 1, 2018
- Messages
- 121
- Points
- 28
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!
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!
Older Threads
Newer Threads
Latest Threads
Recommended Threads
Similar Threads
Latest postsNew threads
-
New threads
-
-
How much bandwidth is enough for a growing website?
- Started by Ridoy
- Replies: 1
-
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Save an incredible 90% off! The Best HostPapa Deal so Far: Unlimited SSL, 50 GB NVMe, 24/7 supportEssentials Hosting provides reliable and affordable web hosting solutions!- cancan
- Updated:
-
Affordable Dedicated Servers - Raspberry Pi & Intel N95 | From €12.90/mo - Unlimited Traffic.Affordable Raspberry Pi & Intel N95 Dedicated Servers with SSD Storage and Unlimited Traffic.- Tinyservers.eu
- Updated:
-
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gbAffordable enterprise grade dedicated servers at a price you can afford.- systeminplace
- Updated:
-
