… with the current my.cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf After doing…
Post: How to syntax-check your my.cnf file
February 17, 2011 By 12 Comments
… errors in a server‘s my.cnf file. I do this when I need to shut down and restart the server, and I’ve… syntax error. The trick is to examine the currently running MySQL server‘s command-line from ps -eaf | grep mysqld, and then…, it will actually remove the pid file from the running server, and that can break init scripts. Because of the above…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…. As the names suggest, they are used to watch the server, gather diagnostic data when the condition occurs, and help you… sure that the script can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you…, and sometimes the disks are responding very well but the server is abusing them and overloading them. And sometimes, of course…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL and the… out “optimal” parameters for my.cnf. Most of the time these servers are far from optimal. Sometimes the my.cnf parameters are extremely wrong, to… your application architecture. Server settings are a distraction and a waste of time for most people. Most my.cnf files I see only…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… in running server this change is not persisted in any way and server will be back to old value upon restart. MySQL also… in my.cnf to those server is currently running with. The problem however this only works well if settings are set in my.cnf as… easily because MySQL Server does not seems to have an easy way to check what was the default value for given Server Variable…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… know is that server configuration itself really isn’t something you should expect to deliver huge wins. If MySQL is actually badly… more than simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see something wrong… at several important factors, including the following: The hardware The server configuration The workload The queries The schema design (table design…
Post: Fixing MySQL with a comment in the config file
February 4, 2011 By 5 Comments
A customer called with an emergency issue: A server that normally runs many MySQL instances wouldn’t start them up. Not only… the mysql_multi init script. Perhaps you already know what was wrong! It turns out that this server‘s /etc/init.d/mysql_multi wouldn’t start unless it found the text “mysqld_multi” in the /etc/my.cnf file…
Post: How to pretty-print my.cnf with a one-liner
June 15, 2009 By 17 Comments
When I’m looking at a server, I often want to see the /etc/my.cnf file nicely formatted, and with comments stripped… -ne ‘m/^([^#][^\s=]+)\s*(=.*|)/ && printf(“%-35s%s\n”, $1, $2)’ /etc/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld...] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
…: this is a tool to help you generate my.cnf files based on your server‘s hardware and other characteristics. We’ve gotten… what we were using on our servers, whose cnf‘s were put together by highly trained mysql certified dba’s. So what’s… advisor, a query analysis tool, a way to register a server‘s essential characteristics and then get advice when there’s…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark on enabling… space and restart time. The core file will dump all MySQL Server memory content including buffer pool which can be tens on… files. First you need “core-file” option to my.cnf which will instruct MySQL to dump core on crash. This alone will unlikely…
