…a book to help people optimize their my.cnf settings, yet you were wailing against the available (and …able able to help out in certain situations because servers and the programs they run are never exactly the…comings. Indeed a DBA might be able to fine tune it better, but your book is not a living…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
March 14, 2012 By 34 Comments
Page: Presentations
May 3, 2006 By
… 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… Innodb specific application design recommendations as well as Innodb MySQL Server Settings and Hardware selection aspects. Download Effective Full Text Search for…
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… adding more servers, because scaling up and purchasing more and more powerful servers will not tall you far, especially as MySQL Server may… help to access if minor face lifting such as MySQL Server settings tuning, changing indexes and queries is enough to deliver performance required…
Post: UC2007 Presentation and Notes
May 2, 2007 By 5 Comments
… lightning talks. I’ve now published PDFs for these: MySQL Server Settings Tuning MySQL Performance Cookbook Innodb Performance Optimization Last one was presented…
Post: Speaking at MySQL Users Conference 2007
January 16, 2007 By 2 Comments
… my talks being accepted to MySQL Users Conference 2007 “MySQL Server Settings Tuning” and “MySQL Performance Cookbook”. This is great as MySQL Conferences…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… 0.001% Which server is badly tuned? Maybe you’re objecting that you don’t know enough about the servers. OK, I’ll… MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and… unscientific-ness, they shouldn’t. The reality is that this server setting is very subjective, and there is no good instrumentation in…
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… servers are where in wild which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload. After you get these settings right other…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… At first, <tuning peak performance>. The next, <tuning purge operation> to stabilize performance and to avoid decreasing performance.
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
…-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: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… we solve it in Percona Server ? There is whole set of improvement we made, like: Big log files Tuned flushing algorithm Disable flushing….5.20, Percona Server 5.5.19 With these settings we have following results: As you see with Percona Server we have stable… with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course if a tuning is too hard…
