![]() ![]() InnoDB is the newer (and some would say sexier) engine. MyISAM uses table-level locking, which means than when a row is being updated, the table is locked and no other operations can update any other rows until the first row is updated and the lock on the table is released. It supports up to around 4 billion rows of data and 64 indexed fields per table. ![]() ![]() The general consensus is that in most cases, it’s faster than InnoDB for typical CRUD operations. Of the two engines, MyISAM is the older of the two, and the default engine. If you’re not familiar with MySQL, you’re probably asking “What’s the difference between InnoDB and MyISAM?” The next choice to make is selecting the storage engines to be used: MyISAM or InnoDB. in this configuration, MySQL will be configured to use all available system resources.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |