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
-
-
-
Anyone used fussionhost.com? Need honest reviews
- Started by hasnainnazeer
- Replies: 1
-
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Jtti: Anniversary promotion, dedicated server starts at 55% off, Xeon E5 dedicated server as low asdedicated server starts at 55% off- jtti
- Updated:
-
# Anniversary promotion# JTTI unlimited traffic VPS cloud host 80%discount, annual payment of $ 24.6JTTI unlimited traffic VPS cloud host 80%discount- jtti
- Updated:
-
Hivelocity | Dedicated Server Deals | 50% off 1st Month Instant Servers - Code Inside!Leading Price-to-Performance with Hosting's #1 Rated Support on a World-Class Network.
- Hivelocity
- Updated:
-
