June 19, 2013

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

… GTIDs, you just need to be aware of the current limitations and see if you can accommodate with them (think of…

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

…[0x33e0607851] /lib64/libc.so.6(clone+0x6d)[0x33dfee890d] Trying to get some variables. Some pointers may be invalid and cause the…

Comment: What Are Full, Incremental, and Differential Backups?

Hi Collum, you must be my fellow OU student. Get in touch. We may discuss the thing.

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… using GTID. You will be kept plenty busy trying to get even a pure MySQL 5.6 gtid replication cluster working…

Comment: Sphinx search performance optimization: multi-threaded search

How would you merge the indexes after this? I assume you would want to get 1 index. So, I can run the indexer for idx1p0, idx1p1, idx1p2 but how would I then get the idx1 index? If I try to run indexer for idx1, I get “skipping non-plain index ‘idx1′… ” Thanks, Rob

Comment: MySQL VIEW as performance troublemaker

just to add. i am thinking of working with temporary values getting posted immediately after a transaction eg customer balance on the customers table. Then i wont need a view.

Post: Experiences with the McAfee MySQL Audit Plugin

… on the VM I was working in and didn’t get significant differences between either output option, or between using the… sent to the plugin, and you can control if it gets written on not with this list. I tested this with…

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

These limitations are part of the reason we decided not to merge …

Post: Percona MySQL University @Portland: June 17

… to the cities showing greatest interest. As usual space is limited, so Register Now!

Comment: Benchmarking Percona Server TokuDB vs InnoDB

Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.