June 20, 2013

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…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…caption id=”attachment_13334″ align=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is… like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to set innodb_ft_min_token_size to…: 0 Warnings: 0 As far as I can tell, this little gotcha doesn’t appear to be mentioned anywhere in the MySQL 5.6…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…true that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6… editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with…) Records: 245051 Duplicates: 0 Warnings: 0 mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE |…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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…

Filed Under: Events and Announcements Tagged With:

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…

Filed Under: Benchmarks

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

March 21, 2012 By 10 Comments

…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…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , , , , , , , , , , , ,

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_…

Filed Under: Benchmarks, MySQL Tagged With: ,

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…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , ,

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…

Filed Under: Percona Software Tagged With: , , ,

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

… of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job, and getting up to 5.6….  Codership is really planning some exciting things for their 3.0 release. Day 3 Migrating to Percona XtraDB cluster - Once again… archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa, Pythian) — This seems like a great 5.6…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,
« Older Posts
Newer Posts »