… my talks being accepted to MySQL Users Conference 2007 “MySQL Server Settings Tuning” and “MySQL Performance Cookbook”. This is great as MySQL Conferences are always fun and… way to get to know people and learn things about MySQL and connected areas. This will be my 5th time, but only first time, not being MySQL Employee. No word so far about other talk I proposed…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many… many servers are where in wild which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers…
Page: Presentations
May 3, 2006 By
…. Download MySQL Server Settings Tuning MySQL Users Conference 2007, Santa Clara,CA, April 2007 Presentation covering most important MySQL Settings which should be tuned for optimal MySQL performance giving… Optimization MySQL Users Conference 2007, Santa Clara,CA, April 2007 Presentation covering Innodb specific application design recommendations as well as Innodb MySQL Server Settings…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
… also how your scaling is set up. For smaller systems lets say running couple of MySQL servers running another couple can be cheaper… adding more servers, because scaling up and purchasing more and more powerful servers will not tall you far, especially as MySQL Server may have…, to help to access if minor face lifting such as MySQL Server settings tuning, changing indexes and queries is enough to deliver performance required…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server… memory requirements retriving result sets from remove queries. Blobs…tuned as buffers. Watch for these especially now with many storage engines being released for MySQL…
Post: MySQL Connection Timeouts
April 19, 2011 By 2 Comments
Sometimes on very busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If… LISTEN socket is overflow – MySQL is not accepting connections as quickly as it needs. There are 2 tuning places you need to… second to MySQL Server you might be pushing your luck and at very least you’re using a lot of resources setting up…
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 23 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 27 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…
