June 19, 2013

Post: How Percona does a MySQL Performance Audit

… attention. I use “tuning” in a generic way here — we focus on far more than my.cnf files. In fact my.cnf files are usually… reading from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql and an /etc/my.cnf, and the… 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 seeing…

Post: What's required to tune MySQL?

… simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see… The schema design (table design, data types, indexing, etc) The data itself All of these things interact,…. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done …

Post: New SpecJAppServer results at MySQL and Sun.

… are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction… benchmark does not require these properties and so they are tuned away…. though I bet the over vendors do the same thing of tuning database options for benchmark rather than running production reasonable options…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll explain below) – the… few people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the case… initial states, run some queries, and compare the output. Stay tuned, it gets rather curious.

Post: Why you should ignore MySQL's key cache hit ratio

… MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and… shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite, mathematical… magnitude, lack of timing information, etc) apply to all types of ratio-based and counter-based tuning techniques. Summary Major points in…

Comment: The ultimate tool for generating optimal my.cnf files for MySQL

…there is a difference between “better than default my.cnf” and “optimal my.cnf” – It is indeed possible to automate things, often…file automatically. This is in particularly so because during tuning there are many questions which human needs to answer…. and no O_DIRECT) balancing reads vs writes etc

Comment: The ultimate tool for generating optimal my.cnf files for MySQL

…: “The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many …with your application and your data.” Baron: Oracle’s auto tuning is super great, but it has its limits. It’s…you’re taxing any element (cpu, disk i/o, network, etc) to the limit, all bets are off. It’ll do…