Re: InnoDB Performance

[Jigal van Hemert]

From: "David Lloyd"
> journalling file system. It's not always that clear cut. I've just
> switched a number of big customer databases to InnoDB and noone's
> noticed any difference - if anything it's going faster.

For small tables (<50,000 records) MyISAM is usually a lot faster. However,
MyISAM gets slower as the table size increases if it is used in a medium to
high concurrency environment. If you only use selects (low concurrency)
MyISAM will probably be fast, but when it comes to large tables with lots of
select, update and insert queries you will most likely see that the speed of
InnoDB remains roughly constant as the database grows.
You will see a slower performance as :
- InnoDB runs out of table space and has to autoextend the data file(s)
- the conf file is not suitable for the db size anymore
- the hardware is not suitable for the db size anymore (e.g. not enough
memory)
But this is not really InnoDBs fault ;-)

Regards, Jigal.