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

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -