… would be important. Otherwise people like me will update their my.cnf and certainly the production site goes down 
Comment: What to tune in MySQL Server after installation
April 15, 2012 By 116 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to change. An example of this is a third-party product whose code you are unwilling or unable to change. We… way here — we focus on far more than my.cnf files. In fact my.cnf files are usually one of the smallest levers we… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this is an action…… it was always 1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set… mmm can cause failover if you stop replication # mmm_control @production set_passive (to avoid automatic failover) 2. stop replication on…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
September 26, 2008 By 34 Comments
…. I agree that also with MySQL Monitor the optimisation of my.cnf is a long term project. Also as tables grow, or… versa, parameters in my.cnf should be modified. Unfortunately modification of certain parameters is not easy in an production environment where downtime should…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… surprised me how little Innodb team seems to think about product usability/ease of use, when it comes to settings, performance…’t mix what do you currently have set in your my.cnf file – For example using values “none”, “disk”, “os” instead of…” ? Using string values would make things much more friendly with my.cnf and “show variables” output being more obvious and self documenting…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 37 Comments
… been 5.1 for some time. And indeed /etc/mysql/my.cnf also drives me nuts (wikimedia uses an empty file in… should only be used for small, simple applications. For a production system I would use the latest GA from MySQL, Percona…-sandbox for development and also (but w/o sandbox) for production. Using tarballs makes it easy to switch version using a…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation… disabled – this is not what you would probably run in production but as I guess benchmark does not require these properties… thing of tuning database options for benchmark rather than running production reasonable options. It is interesting though slow query log remained…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
… short version: this is a tool to help you generate my.cnf files based on your server’s hardware and other characteristics… close to what we were using on our servers, whose cnf‘s were put together by highly trained mysql certified dba… of free browser-based tools helps you become a more productive MySQL user and administrator!
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… benchmarks in a while so be careful with my results and forgiving to my mistakes The environment Here is the summary of… a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld… I was benchmarking, I could clearly see the difference in production as I had another machine running sideways with the same…
Comment: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… on my servers. I mean I’m certainly hitting a MySQL/InnoDB memory leak because whatever values I put in my my.cnf, I… used than when I first launched mysqld. So far all my attempts to find where the leak was failed (the issue… I guess it is difficult to reproduce exactly the same production traffic/workload). Unfortunately in this aspect, MySQL is not really…
