… will be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5.6 is… I have not tuned MySQL 5.6 for best performance going with defaults outside of few variables MySQL Sandbox sets explicitly but yet this is likely course of action for many MySQL users out there, also…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and…. It may be as simple as adding few indexes and tuning MySQL Server settings. It is more the question of knowing there to change… as part time DBAs for some projects helping to secure MySQL setting up backup policy and monitoring and make sure it is…
Post: Online MySQL Configuration Wizard from Percona
December 23, 2011 By 24 Comments
… your MySQL servers. Our online MySQL Configuration Wizard can help you generate a good basic configuration file for a server. This MySQL tuning wizard … planned for future releases, including advanced configuration options, supersafe settings to prevent bad things from happening, and much more. …
Post: UC2007 Presentation and Notes
May 2, 2007 By 5 Comments
… as well as related to storage engine design. As usually MySQL would save some major announcement for the conference. This time… contributors lightning talks. I’ve now published PDFs for these: MySQL Server Settings Tuning MySQL Performance Cookbook Innodb Performance Optimization Last one was presented by…
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… 0.001% Which server is badly tuned? Maybe you’re objecting that you don’t know enough about the servers. OK, I’ll…. The reality is that this server setting is very subjective, and there is no good instrumentation in MySQL to guide your decisions. It…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… lot of extra calls checking various server changes which typically never change). We can also see Server prepared statements were disabled for… it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included… server: UFS Options for log and data noatime, nologging mysqld moved into the FX scheduling class via priocntl -s -c FX mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…with systems that are at any level of tuning, from completely untuned to a system that’s…stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that… all of which we can frequently help customers set up much more efficiently and with better results,…
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…-all and end-all of performance. Tuning your server settings has far less impact on performance than tuning your schema, indexing, queries and — you guessed it — thinking deeply about your application architecture. Server settings are a distraction…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve… the tested setting–multiple purge thread implementation at the moment seems to be the one in Percona Server 5.1. MySQL 5.6…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… server configuration itself really isn’t something you should expect to deliver huge wins. If MySQL …addition to unlikely circumstances, I sometimes see unlikely settings, such as making the sort buffer size…[1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be …
