… different memory allocators and what difference we will see in MySQL performance in this scenario? Let me share a conclusion first: If… the query processing. I believe that both allocators can be tuned to handle such cases better – for instance allocate more arenas… not by MySQL. Notes regarding jemalloc version I’ve used in my tests: I’ve noted notable impact on MySQL performance after version…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… sets. Internals of new InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job… 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: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…. I claim that somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when you… good instrumentation in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, and people…-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are meaningless as a performance analysis metric because…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row… today. You can check about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming…). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL 6…see gains and when regressions. Practical MySQL Variables Tuning This session takes practical approach to MySQL variable tuning. Instead of giving you theoretical …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… with default settings. Even though you can tune quite a lot of variables in MySQL Servers only few of them are really… may decrease performance. I normally leave per session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… a human with many years of experience, deep knowledge of MySQL and the full application stack, and familiarity with your application… be-all and end-all of performance. Tuning your server settings has far less impact on performance than tuning your schema, indexing, queries and… performance improvements. Tuning my.cnf only helps a lot when my.cnf has extremely bad parameters. The kind you’ll get from tuning…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…huge wins. If MySQL is actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance. But such…configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… engine transactions which require a lot of complications and performance overhead. MySQL has to do several fsync() calls per transaction …deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…
