There are quite a few “tuning primers” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating… the time these servers are far from optimal. Sometimes the my.cnf parameters are extremely wrong, to the point of causing… who knows very well the complexity of creating a good my.cnf — it’s practically impossible. Much harder than syncing data…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
Post: How to pretty-print my.cnf with a one-liner
June 15, 2009 By 17 Comments
… at a server, I often want to see the /etc/my.cnf file nicely formatted, and with comments stripped. This Perl… -ne ‘m/^([^#][^\s=]+)\s*(=.*|)/ && printf(“%-35s%s\n”, $1, $2)’ /etc/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock…
Post: How to syntax-check your my.cnf file
February 17, 2011 By 12 Comments
… check whether there are syntax errors in a server’s my.cnf file. I do this when I need to shut…
Post: My talks on PL MySQL Conference (+free book inside)
February 14, 2012 By Leave a Comment
On coming PL MySQL conference 2012 I will give one tutorial: Percona XtraBackup: install, usage, tricks. This tutorial I will do in joint with Alexey Kopytov, the lead developer of Percona XtraBackup. Our intent is to provide the comprehensive overview of the XtraBackup architecture and features, …
Post: Slides from my Sphinx talk at RIT++ 2010
April 14, 2010 By 1 Comment
While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here – Improving MySQL-based applications performance with Sphinx. I have …
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes for many workloads. And now it is time to look on systems with 32GB+ of RAM which are not rare nowadays. Working with real customer systems I have wish-list of features I…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and tiny wishes listed so I was making notes. Here is what I’d like to see Packed indexes. In many cases then difference in Performace with MyISAM and Innodb is huge for read only workload it …
