…use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re…re not that familiar with, I’d suggest reading over the manual’s description of how …disclaimer here in that the aforementioned statements reflect only my opinion and not any official Percona position, and…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old…keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local…open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… for the binlog position of a specific event. The only part were we should pay attention is the server … which is crashed, the server UUID can be read in the auto.cnf file in the datadir). So the last …There is a solution of course, but very poor in my opinion: look for the binlog file/position of the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read…-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read…-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…in standard async MySQL replication. It is my belief that the lack of understanding of…EDIT: actually the cost of certification depends only the size of the transactions, which …READ LOCK on node3: [root@node3 ~]# myq_status wsrep Wsrep Cluster Node Queue Ops Bytes Flow Conflct time name P cnf…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
Baron: Well I have read this blog entry twice and still cannot see any hints regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf (but… when you read the blog post named “The ultimate tool for generating optimal my.cnf files for MySQL” ? 
The meaning of tuning my.cnf is…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…wsrep_connected | ON | | wsrep_local_index | 1 | | wsrep_ready | ON | only wsrep_local_index defers as expected. Now …properly currently, I needed to change it in my.cnf and restart the nodes) wsrep_provider_options = “pc… 2012-07-24 11:42:50.237 INFO: Read config: daemon: 0 address: gcomm://192.168….
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…sort performance and today I’ve discovered even read_buffer_size selection may be less than obvious….set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings…see the difference in percents is smaller with only 10% difference between best and worst numbers …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… don’t have a single person knowing everything about you (only one is billable, though). The second person will be from…’s reading from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql and an /etc/my.cnf… 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…
