June 19, 2013

Comment: Connecting orphaned .ibd files

… your promising tool and imported an .ibd file from 5.1.31 to 5.1.51 under debian. Each step was OK, but at the…:30 debian mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html May 16 14:19:30 debian…

Comment: Percona Server 5.1.52-rel11.6

… mysqld than it previously did? I remember with 5.1.51-rel11.5-132 that it spawned 1 or 2 mysqld processes, but now it…

Comment: InnoDB in self-compiled MySQL 5.1

Phil, I love you!! Why couldn’t I have found this site 5 hours ago. ./configure –with-plugins=innobase works with 5.1.51

Post: What is stored InnoDB buffer pool

… | | 79 | 1 | 3 | 3 | 39 | 0 | 0 | 81 | 17855 | index | PRIMARY | art | author87 | | 80 | 1 | 1 | 0 | 0 | 0 | 0 | 51 | 5 | unknown | | | | | 81 | 1 | 2 | 0 | 0 | 0 | 0 | 51 | 3 | inode | | | | | 82 | 1 | 137 | 807 | 10491 | 0 | 0 | 51 | 17855…

Comment: Percona Server 5.1.54-12.5

… Percona-Server-shared-51-5.1.54-rel12.5.188.rhel5.x86_64.rpm warning: Percona-Server-shared-51-5.1.54-rel12.5.188.rhel5.x86_64… Percona-Server-shared-51-5.1.54-rel12.5.188.rhel5.x86_64 conflicts with file from package Percona-Server-server-51-5.1.53-rel12.4… Percona-Server-shared-51-5.1.54-rel12.5.188.rhel5.x86_64 conflicts with file from package Percona-Server-server-51-5.1.53-rel12.4…

Comment: Percona Server 5.1.54-12.5

… packages you need to update Percona-Server-shared-51 and Percona-Server-server-51 simultaneously either with YUM or rpm command: # yum…-server-51 Percona-Server-shared-51 or # rpm -Uhv Percona-Server-shared-51-5.1.54-rel12.5.188.rhel5.x86_64.rpm Percona-Server-server-51-5.1.54-rel12.5.188…

Post: Testing the Group Commit Fix

… my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have strict…. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The….32 31.26 4 174.97 1672.97 86.97 51.42 8 339.09 2947.88 170.58 95.41…

Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances

… hamysql hamysql|10.248.194.51|i-a23a21c9|ami-1cdf3775|ec2-174-129-89-188.compute-1.amazonaws.com|running|2010-06… ha.cf autojoin none ucast eth0 10.248.194.51 warntime 5 deadtime 15 initdead 60 keepalive 2 crm respawn node monitor… repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an automatic startup script controlled…

Comment: XtraDB storage engine release 1.0.6-9

… is obsoleted by Percona-XtraDB-server-51, trying to install Percona-XtraDB-server-51-5.1.43-9.1.rhel5.x86_64 instead Package MySQL-client-percona is obsoleted by Percona-XtraDB-client-51, trying to install Percona-XtraDB-client-51-5.1.43-9.1.rhel5.x86_64 instead Thanks!

Post: MySQL versions shootout

… question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are… more features, which give more overhead. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance… MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01 593.51 531…