June 20, 2013

Post: MySQL Users Conference - Innodb

… same as bunch of others due to statement level MySQL Replication which among other …MySQL 5.1+ it is also possible to fix this problem for cases when number of rows in auto-increment batch insert isis still important. IO Scalability patches Mark Callaghan from Google released so many MySQL patches…

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5MySQL handled this problem. While working for MySQL we spotted this problem early in MySQL 5.0 release

Post: How Percona does a MySQL Performance Audit

release Red Hat Enterprise Linux Server release 5.2 (Tikanga) From this, I can see a couple of important things. One thing isMySQL is probably a good place to look for performance problems. Everything I’ve done up till now is just due

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the above Philosophy on backups  It isWhen do we typically use xtrbackup restores: Setting up new slaves When we lose an entire server due to hardware failure, corruption, etc When

Post: Percona Server 5.5.17-22.1 released

MySQL 5.5.17, including all the bug fixes in it, Percona Server 5.5.17-22.1 is now the current stable release in the 5.5when using SET user variables it was possible to have SHOW SLAVE STATUS give incorrect output due

Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1

for State Snapshot Transfer would fail due to…When installing from yum repository, Percona-XtraDB-Cluster-server and Percona-XtraDB-Cluster-client would conflict with mysql and mysql5.5.29-29.4 including all the bug fixes in it, Percona XtraDB Cluster 5.5.29-23.7.1 is now the current stable release

Post: Watch out for Marketing benchmarks

MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 isMySQL for other applications or checked MySQL when new version was released. In general I also have to admit it is

Post: Announcing Percona XtraDB Cluster 5.5.28-23.7

When server was started with no wsrep_provider and with regular MySQL replication slave configured, could cause intermittent failure to start MySQL5.5.28-29.1 including all the bug fixes in it, Percona XtraDB Cluster 5.5.28-23.7 is now the current stable release

Comment: Where to get recent MySQL version ?

… that MySQL Support won’t support the older versions because that wasn’t the practice whenis due to an old bug, we’ll ask people to upgrade to prove it. Peter, the last Community release of 51.19 and a bit longer between 4.1.21 and 4.1.22. What is really visible so far is the increase in service for

Post: Aligning IO on a hard disk RAID – the Benchmarks

for brevity I have removed some irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release1 87.0 0.5 0% 0.0 0.7 93% 0 While number of operations from the OS perspective is very similar, due