June 19, 2013

Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)

December 21, 2010 By 11 Comments

… (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: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

… little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages…: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily…

Filed Under: Insight for Developers Tagged With: ,

Post: MySQL 5.5.8 - in search of stability

January 3, 2011 By 11 Comments

… stable 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_file… received with MySQL 5.5.8 (with innodb_doublewrite enabled). In summary, my conclusion is: You can try to get stable throughput in MySQL 5.5.8Â…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: Percona Welcomes MySQL 5.6!

February 25, 2013 By Leave a Comment

… 2 years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text… previous MySQL versions to MySQL 5.6, and other issues. Our MySQL Remote DBA Team is ready to monitor, maintain, and fine tune our customers’ MySQL 5…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software, Percona Toolkit

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

February 26, 2013 By 1 Comment

… premature. While it is true that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM… that I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll… one configuration change to the default InnoDB settings for MySQL 5.6, and that was to change innodb_ft_min_token_size from the…

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

Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 14, 2013 By 2 Comments

…role_id_note` (`role_id`,`note`) ) ENGINE=InnoDB AUTO_INCREMENT=22187769 DEFAULT CHARSET=…MySQL 5.5. For example, in this case, the actual number of “Handler_read_next” calls was reduced from 8346769 (5.5) to just 266 (5… need more manual care and tuning now. MySQL is conservative about “Using index…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Post: How Innodb Contention may manifest itself

July 28, 2011 By 1 Comment

… though multiple fixes have been implemented in Percona Server and MySQL 5.5, there are still workloads in which case mutex (or rw… you can consider increasing innodb_sync_spin_loops to a higher number. It is worth to note fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements…

Filed Under: Insight for DBAs, MySQL

Post: Innodb Performance Optimization Basics

November 1, 2007 By 75 Comments

… MySQL 5.1 and row level replication. There are bunch of other options you may want to tune but lets focus only on Innodb ones today. You can check about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially… indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…

Filed Under: Insight for DBAs Tagged With:

Post: Percona Server vs MySQL on Intel 320 SSD

February 23, 2012 By 21 Comments

… = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G Versions: MySQL 5.5.20, Percona Server 5.5.19 With… with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course if a tuning is too hard…

Filed Under: Benchmarks, Hardware and Storage, MySQL

Post: Tuning InnoDB Concurrency Tickets

May 24, 2010 By 5 Comments

…1 Warnings: 0 mysql> ALTER TABLE test_table ADD INDEX (id); — 5 Tickets Used Query … throughput in this scenario, you will tune innodb_concurrency_tickets to the 99th percentile…mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb…

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , ,
« Older Posts
Newer Posts »