阅读背景:

InnoDB表优化w/o锁表

来源:互联网 

I've noticed a significant amount of performance gain if I repack a table (ALTER TABLE foo ENGINE = INNODB) after some period of time, or after heavy volume of INSERT/UPDATE/DELETEs. I don't know if this is because indicies etc are rebuilt, or compacting the table space, or something else?I've noticed a significant amount of performanc




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: