… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding … that have been certified but not yet applied, so multi-node writing will not lead to inconsistencies, … Queue Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn Up …
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… the user mysqld will now run under (check ‘user’ setting in my.cnf also) (see here if this is not clear) Now, before… for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld to your…/percona/mysql-5.5.28/usr/sbin/mysqld) | | | ->10.10% (7,135,744B) 0x3ECF60677B: start_thread (in /lib64/libpthread-2.5.so) | | | ->10…
Post: How to syntax-check your my.cnf file
February 17, 2011 By 12 Comments
…trick to check whether there are syntax errors in a server’s my.cnf file. I do this when I …error. The trick is to examine the currently running MySQL server’s command-line from ps -eaf | grep mysqld…doesn’t have write privileges to the database directory, so it can’t actually mess with the server’…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… upon restart. MySQL also does not have option to re-read config file without restarting as some other software so approach to… settings 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 if default option was used and we change it in run time we can’t detect such change easily because MySQL…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… (BLOB, VARCHAR, TEXT) in the index record, and the remainder stored in overflow pages. COMPACT became the default after MySQL 5.0.3…=COMPRESSED. In our case we only wanted MySQL to try to move the larger (greater than 16KB) TEXT fields off-page so we… innodb_file_format=BARRACUDA (don’t forget to set it in my.cnf!): SET GLOBAL innodb_file_format=BARRACUDA; One caveat: you must…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… there are not too many audit capabilities in MySQL Community so the first option to audit MySQL‘s authentication process is to get all… Statistics in my.cnf: 5.5 userstat = 1 5.1 userstat_running = 1 Then we get the information about a particular user: mysql> select…. Conclusion We don’t have too many audit capabilities in MySQL Community so logging all events and then filter them with custom-made…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
…my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL…my.cnf files I see only need minor tweaks, which give only so-so performance improvements. Tuning my.cnf only helps a lot when my.cnf…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld…. entries defining the 3 nodes I have in my cluster. One attribute is required to each … this example configuration has no stonith devices defined so stonith is disable. At the end of …
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… same MySQL version. I had already added the relevant config options in the ‘mysqld’ section of the my.cnf: [mysqld] ssl-key=/etc/mysql/ssl/server-key.pem ssl-cert=/etc/mysql/ssl/server… SSL worked fine there. MySQL worked fine outside the chroot, and so did the basic openssl server, so how do I test the…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… another machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this is an action… value was not ok in show global variables… it was always 1 !! There was a hidden character in my.cnf that was unvalidating the… MASTER STATUS on mysql 4 (this position will increase every time writes are performed on the active master, so just take a…
