与InnoDB相比，MyISAM快多少? [英] How much faster is MyISAM compared to InnoDB?

问题描述

人们说InnoDB不如MyISAM快.但是慢了多少?当然，就像风中的经验法则一样.我的意思是...它通常是MyISAM的0.5倍吗?甚至更糟?还是普通的访问者在浏览MyISAM平台与使用InnoDB进行相同操作时是否看不到任何时间差异?

People say InnoDB is not so fast like MyISAM. But how much slower? Just as a rule of thumb in the wind, of course. I mean... is it usually 0.5x as fast as MyISAM? or even worse? Or does the average visitor not recognize any temporal difference when surfing an MyISAM platform vs. same thing with InnoDB?

推荐答案

如果您发现实际存在任何实际差异，除非您正在运行一个非常占用资源的大型网站，我会感到非常惊讶.

I'd be very surprised if you noticed any practical real world difference unless you're running a very large/resource intensive web site.

有一些(尽管很老)基准测试(

There are some (albeit quite old) benchmarks out there (here for example), but your experience will obviously differ depending on your specific usage pattern.

这篇关于与InnoDB相比，MyISAM快多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！