Performance of an innodb compared to memory-table - part2

2006-12-08 Thread kirchy
Hi, I sent a mail to this list almost a year ago asking if our current way of keeping some of our tables memory could be improved by using the cluster-engine since we were getting problems with too long locks. A few people suggested I should use innodb and said it should be able to handle the l

Re: Large tables

2005-04-09 Thread Kirchy
Daniel Kiss schrieb: However, I'm more interested in practical experience with huge databases. How effective is MySQL (with InnoDB) working with tables containing millions or rather billions of rows? How about the response time of queries, which return a few dozens of rows from these big tables