June 18, 2013

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… up the plugin: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I ran… store against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin.  Here are some… numbers, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06…

Filed Under: MySQL Tagged With: , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…we also see a drop, and by end of 5 hours the average throughput is 7800 tps. Something …autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb…settings out-of-box, but I am ready to tune something if there are …

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

… bad in standalone Innodb, you might consider relaxing the fsync:  set innodb_flush_log_at_trx_commit to something besides 1 and suddenly you can update much faster.  I see this tuning very… your application has that logic (I usually get less than 5 people who do out of 100). But, what to do…

Filed Under: MySQL, Percona Software, XtraDB Cluster 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…: Innodb Q: Is Group commit still busted in 5.0/5.1? HT: Yes. However, work has been done on it by Inaam. Q19: INNODB…: 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: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2

May 3, 2011 By 13 Comments

… MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5.5 there…_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1… and by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…

Filed Under: MySQL

Post: Tuning for heavy writing workloads

October 14, 2009 By 9 Comments

…5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb_buffer_pool_size = 16G innodb…) innodb_ibuf_active_contract = 1 innodb_adaptive_flushing = false innodb_adaptive_checkpoint = estimate <tuning peak performance> At first, tuning the …

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

Post: Different flavors of InnoDB flushing

January 13, 2011 By 9 Comments

… flushing, because that defines what MySQL InnoDB tuning should apply. The LRU list is used when InnoDB tries to read data from disk… for MySQL 5.1/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…

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

…. 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… | Free Business Forms for Starting or Maintaining a Successful Business | 1.3383517265319824 | | 7112 | Download Idaho Tax Forms for Individual or Business… InnoDB FTS compare to its MyISAM counterpart, and what kinds of tricks can we use to make it go faster? Stay tuned…

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

Post: Innodb Performance Optimization Basics

November 1, 2007 By 75 Comments

… looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed… 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…

Filed Under: Insight for DBAs Tagged With:

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

March 21, 2012 By 10 Comments

… tuned and it is recommended to turn this off. The query used is: select c_custkey, c_name, sum(l_extendedprice * (1… 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows_read 799239 914146 912318 914146 912318 Select_scan 1 1 1 1 1 Sort_scan 1 1 1 1 1 As you can see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb…

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