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: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…’ Start Percona Server [root@alarmpi ~]# systemctl start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands… it in /etc/mysql/my.cnf If you setup Percona Server to startup at boot time (step 12), give your little server a reboot (type…
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…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… less secure as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS… I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… Software Repositories). Based on MySQL 5.1.58, including all the bug fixes in it, Percona Server 5.1.58-12.9… advantage of persisting across machine restarts. The configuration variables for my.cnf have been kept for compatibility and warnings will be printed… the option ignore-builtin-innodb is incompatible with Percona Server with XtraDB, the server will not start and print the corresponding error…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple… scripts and results are on Benchmark Wiki and the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file… the moment seems to be the one in Percona Server 5.1. MySQL 5.6.2 multiple purge threads have major issues…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13-20.4 is now the… of also persisting across machine restarts. The configuration variables for my.cnf have been kept for compatibility and warnings will be printed… (Y. Kinoshita) Other Changes Improvements and fixes on the Percona Server Test Suite: , #693415, #794849, #800035, #800559, #782391,#785566, #790199 (O…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…’ (using password: YES) User Statistics If you are using Percona Server then there is a third option to get information about… in my.cnf: 5.5 userstat = 1 5.1 userstat_running = 1 Then we get the information about a particular user: mysql> select… best solution we have nowadays. If you are using Percona Server you can get more detailed information about what a particular…
