One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on… transaction. Why is that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in… the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned.
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… Percona Live MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s New in InnoDB” by Sunny Bains, Senior Principal Software Engineer “MySQL…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…So we see that InnoDB performance steadily declines from 24000 tps to 18000 tps, but InnoDB can’t make 5h …data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb…out-of-box, but I am ready to tune something if there are…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… innodb_flush_log_at_trx_commit to something besides 1 and suddenly you can update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… MySQL interactive performance…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…tuning you might also look into changing how buffer pool is split into young and old sublists via innodb…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…Xtrabackup feature sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my …might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I haven’t explored the performance_schema very much yet…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well could… to use large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for… you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size should…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max\ imum number of threads allowed inside InnoDB. Value 0 will disable…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… good instrumentation in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, and people… it? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are meaningless as a performance analysis metric because…
