MySQL performance management and architecture design---theory

MySQL performance management and architecture design

One, IO, memory , Throughput Understanding

IO refers to the number of operations between the device and the device, such as MySQL and PHP plug-in
Memory is that the program is running inside the execution
Throughput is the number of requests processed within a unit of time

Two, is it Myisa or InnoDB?

As the industry argues, the low-version default engine is MyISAM, The high-version MySQL default engine is InnoDB, which is also a InnoDB high version of a terrier bar, try to use the InnoDB engine, do not mix MyISAM These two engines, because in things, if rollback, table connection MyISAM is no way to rollback, INNODB support concurrency than MyISAM better, support hot backup, disaster recovery is better than MyISAM, Big data or using InnoDB is better!

MySQL performance management and architecture design

memory throughput comprehension

io       
memory      is the program runs inside the execution
throughput   is the number of requests processed within a unit of time

two, in the MyISAM and InnoDB industry debate, the lower version of the default engine is MyISAM, The high-version MySQL default engine is InnoDB, which is also a InnoDB high version of a terrier bar, try to use the InnoDB engine, do not mix MyISAM These two engines, because in things, if rollback, table connection MyISAM is no way to rollback, INNODB support concurrency than MyISAM better, support hot backup, disaster recovery is better than MyISAM, Big data or using InnoDB is better!

MySQL performance management and architecture design---theory