June 18, 2013

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

server.spec Percona Server rpm packages couldn’t be built on RHEL 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump… provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey… Authentication Plugin couldn’t be loaded with Perl and Python clients …

Post: Percona Server for MySQL 5.5.30-30.2 now available

server.spec Percona Server rpm packages couldn’t be built on RHEL 5 and CentOS 5. Bug fixed #1144777 (Ignacio Nin). When mysqldump… provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey… Authentication Plugin couldn’t be loaded with Perl and Python clients …

Post: Side load may massively impact your MySQL Performance

…we have significant variance in the load and many things can be happening … to spare. We’re using Percona Server 5.5.15 for this test… than 150 times when heavy mysqldump is running concurrently. mysqldump itself also slows down … young sublist and as such placing high pressure on buffer pool. There is…

Post: Percona Server 5.1.59-13.0

… the server: replay statements and then rollback at commit. That makes prefetch simple but has high … mistake. Block startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-…. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore …

Post: Percona Server 5.5.16-22.0

… the server: replay statements and then rollback at commit. That makes prefetch simple but has high … mistake. Block startup until LRU dump is loaded Added a new boolean option, –innodb-blocking…. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore …

Post: Living with backups

mysqldump is used or reading a lot of data when copying physical files, so the price may actually be rather high. And the more effectively the server resources are utilized, … things like processlist information, CPU load avergages, I/O load, etc. In this case …

Post: Common MySQL traps webinar questions followup

… recommendation for finding Hot Spots in a high load application? Or some material to help determine …load. You will sometimes see that a single query takes most of the total response time of the server… any logical backup facility provided by Percona like mysqldump? No, on the backup side, we’re …

Post: MySQL Upgrade Webinar Questions Followup

… in dumping table via mysqldump and loading it back. If performance is of importance I would recommend using Percona Server with enabled expand… Percona Server features which are marked as making database binary incompatible with MySQL. Our focus on compatibility is indeed so high there…