…the query execution plan, is not sufficiently tuned and it is recommended to turn this …MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5…MySQL 5.5, as can be seen by the numbers reported for the status counter Innodb_rows_read. While MySQL 5…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
…, only innodb_io_capacity is insufficient to tune the insert buffer. * innodb_ibuf_active_contract (default 0) – By default (same to normal InnoDB), the each…_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… and make binaries with them available. With current MySQL 5.0 I still see Innodb having serious scalability problems in some environments with 4….0 at this point but we hope to port some of them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb… properly before really enabling it. Innodb IO Tuning I should also mention Paul Tuckfield Keynote about Scaling Innodb at YouTube. There were many…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… page 0 … It is important to understand which list is being used for flushing, because that defines what MySQL InnoDB tuning should…InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are important for tuning…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… Innodb Scalability Limits You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0… MySQL 6.0 are different from MySQL 5.0 – we’ll cover different workloads and see when we see gains and when regressions. Practical MySQL Variables Tuning…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (…data/mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… line in MySQL 5.5.8 by tuning innodb_max_dirty_pages_pct and innodb_io_capacity; but the limiting factor is still innodb_log_… 16 innodb_io_capacity=500 innodb_max_dirty_pages_pct = 60 innodb_purge_threads=1 innodb_adaptive_flushing=0 innodb_doublewrite=1 innodb_flush_neighbor_pages=0 innodb_…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
…: innodb_log_file_size=4G (innodb_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none For MySQL 5.5.8, I used: innodb_log_file_size=2000M (innodb_log… good choice for if you are looking for high MySQL performance, and we tune Percona Server to get the most from such…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… commit of InnoDB doesn’t work after MySQL 5.0 with binlog. We pretend to fix this and added “innodb_enable_unsafe_group_commit=[0|1… in asynchronous innodb_ibuf_accel_rate — This parameter is additional tuning the amount of insert buffer processing by background thread. innodb_flush…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… other big issue is using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved in 5.0.37 which I’d expect to show significant gains. This is not to mention specific tuning for Benchmark… slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL 5.2
