Why MySQL mysql table is still is MYISAM when InnoDB is encourage to use? -
i know why still version mysql server 5.6+
mysql store meta database('mysql') tables in myisam type when encourage developers/users use innodb default database engine , considered outdated use myisam anymore ?
of course no 1 can speak dev team, myisam seems appropriate choice these tables :
- no real need row-level locking: there little if need concurrency, since few threads (typically one: administrator) supposed ever write database @ time. table-level locking should suffice.
- very rare need transactions: typical access read-only
- little need support of foreign keys: structure trivial, mysql devs don't need safeguard maintain referential integrity (not you, smart administrator, not supposed fiddle database: administrative tools , commands exist reason)
- speed matter here: myisam still faster innodb, reads
- if ain't broke, don't fix it
i see 1 reason switch innodb though: its resistance crashes , ability recover one, due transactional nature.
Comments
Post a Comment