4 ms·
Yup, looks like InnoDB. I find MyISAM locking to work just fine out-of-the-box. Also, adding proper indexes is one of the basic database tasks to do if you wan
by babuskov 13y ago
Yup, looks like InnoDB. I find MyISAM locking to work just fine out-of-the-box.
Also, adding proper indexes is one of the basic database tasks to do if you want any reasonable performance. I'm often adjusting tables' structure outside of 3rd normal form, just to be able to use good indexes for the expected use cases.
- fideloper 13y agoIf your apps are write-heavy, it makes sense to allow row-locking (InnoDB) vs table-locking (MyISAM).