Many in the MySQL community are snobbish about using MyISAM (not using it that is) and that if not using InnoDB you aren… should not use MyISAM. If you have a huge number of concurrent writes and selects and query performance must be consistently fast in this use case – you should not use MyISAM. If none of the…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would be some changes… indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql… stage and performance parameters may vary a lot in next releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… at performance penalty. If using Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and…, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, instead it…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… distribution but good enough for performance gotcha illustration purposes. The benchmark shows following results for MyISAM using MySQL 5.0.45 run on…. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key cache contention issue…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb… besides MySQL table_cache Innodb maintains …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best …cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but … schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things… write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set… bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… in the batch performance improved, especially for network tests, however going to batches of 100 and 1000 values performance started to degrade… is something nasty going on on Innodb level, so I tried running the test with MyISAM tables instead. The process completed in… may be kind of performance bug of 5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the SQL…
