且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

适用于大型日志表的MySQL存储引擎

更新时间:2023-01-31 09:05:03

如果您使用INSERT和UPDATE,则高性能比MyISAM使用InnoDB更好. 如果在INSERT/UPDATE使用MyISAM之前使用更多的SELECT语句. InnoDB支持ACID(原子性,一致性,隔离性和持久性),因此SELECT和JOIN越慢,但INSERT越快.

if you use INSERT and UPDATE high performance uses InnoDB over MyISAM is better. and if you use more SELECT statements before the INSERT / UPDATE uses MyISAM. The InnoDB has support with ACID (Atomicity, Consistency, Isolation and Durability) therefore the more SELECT and JOIN is slower but is faster for INSERT.

EYE:如果您需要交易这样的支付网关,则应该使用InnoDB具有交易支持的

EYE: If you need to transact such a payment gateway, you should use InnoDB has transaction support