…. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re thinking about… obvious disclaimer here in that the aforementioned statements reflect only my opinion and not any official Percona position, and I will… admit that this was probably the most interesting question asked; my initial reaction was, honestly, why would you ever want to…
Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 15, 2013 By 2 Comments
… since the upgrade of percona this week: pt-heartbeat -F/etc/my.cnf -Dpt_heartbeat –check The –master-server-id option must be…
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
…, so I update this software to 2.0.7. But my backup script get this error: “innobackupex: fatal error: no ‘innodb… ‘mysqld’ in MySQL options” My server is MySQL 5.5, my command is “innobackupex –defaults-file=/etc/my3.cnf –host=192.168.10.118…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node… fixed #1153727 (Teemu Ollakka). Fixed the wrong path in the /etc/xinetd.d/mysqlchk script. Bugs fixed #1000761 and #1132934 (Raghavendra…
Post: How to pretty-print my.cnf with a one-liner
June 15, 2009 By 17 Comments
… looking at a server, I often want to see the /etc/my.cnf file nicely formatted, and with comments stripped. This Perl one…: perl -ne ‘m/^([^#][^\s=]+)\s*(=.*|)/ && printf(“%-35s%s\n”, $1, $2)’ /etc/my.cnf [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 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 server is installed in /customsoftware/mysql with a different my.cnf file. The way to find… 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…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… user mysqld will now run under (check ‘user’ setting in my.cnf also) (see here if this is not clear) Now, before… –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld to your settings file etc. After… allocation functions) malloc/new/new[], –alloc-fns, etc. ->84.91% (349,404,796B) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5…
Comment: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… which my.cnf files are being used by the server (I hate hunting them down). Is it /etc/my.cnf? /etc/mysql/my.cnf? /usr/local/mysql/data/my.cnf? /var/lib/mysql/my.cnf?
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
…_default=”/usr/local/bin/mysqld_safe” OCF_RESKEY_config_default=”/etc/my.cnf” OCF_RESKEY_datadir_default=”/var/mysql” OCF_RESKEY_user_default…/bin/mysqld_safe” OCF_RESKEY_config_default=”/usr/local/mysql/etc/my.cnf” OCF_RESKEY_datadir_default=”/usr/local/mysql/data” OCF_RESKEY… p_mysql ocf:heartbeat:mysql \ params config=”/usr/local/mysql/etc/my.cnf” pid=”/usr/local/mysql/mysqld.pid” socket=”/tmp/mysqld.sock…
