… really confirm where should i use Innodb. Big table ie. users? comments? etc… i just compared MyIsam to Innodb while loading users from 145000 rows and found quite a significant speed gain from MyIsam. Will this be…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread… query to retrieve value from PK. The results for InnoDB and MyISAM are comparable and I think this shows both engines are maximally…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… and spoke a lot about using short PRIMARY KEYs with Innodb tables due to the fact all other key will refer… (`url`,`thumb_width`,`thumb_height`) ) ENGINE=InnoDB; Why did I use this solution compared to others: Innodb Tables – This table is getting much… pages, saving IO dramatically. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
August 25, 2010 By 117 Comments
Great work but you just can’t compare myisam with innodb without a group by statement and 10 updates/seccond:) I wish I could do the test by my core duo is just too slow.
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… about Innodb ? Innodb executed the same query in 2.9 seconds which was a bit disappointing for me as I expected MyISAM to… in 4.5 seconds on Innodb which is about 50% slower compared to Joining on Int, for MyISAM however the time became 11… for joins compared to integer keys Performance degradation can range from few percent to couple of times for Innodb tables MyISAM Tables may…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB… page in clustered key index is corrupted. It is worse compared to having data corrupted in secondary indexes, in which case… in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… how does it compare in performance? Â When would I use PBXT instead of a storage engine like MyISAM, InnoDB or XtraDB? Unfortunately… performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your… from “MyISAM-like” to more InnoDB-like. Originally PBXT was conceived as an engine that would be somewhere between MyISAM and InnoDB in both…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… to most storage engines, it certainly can be applied for MyISAM and Innodb. I remember there were plans to implement such handler… see how this one will compare to transparent gzip page compression which is being implemented for Innodb right now. [-] Tablespace per database… may end up in non-recoverable stage. This is why Innodb has “innodb double write buffer”. Jim does not believe this is…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In this article I’ll get in a…: Forward range/index scan will be fast (read_next) as MyISAM will remember previous position and will not uncompress block from… string keys is so much slower compared to integer keys. Integer keys still best but for Innodb for example difference is not…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… to bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary… do not want OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS cache because there is….S I only described Innodb Buffer Pool selection for dedicated Innodb system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or…
