June 18, 2013

Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released

…_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2.* – xtrabackup # MariaDB 5.3.* – xtrabackup # Percona Server 5.0 – xtrabackup_51 # Percona Server 5.1

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

… a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin.  Here are some … $memcacheOpts = array( ‘servers’ =>array( array( ‘host’ => ’192.168.57.51‘, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = Zend_Cache::…

Post: Percona Server 5.1.51-rel11.5

Percona Community, Percona Server version 5.1.51-rel11.5 is now available for download. The main purpose of this … latest version of MySQL 5.1. Functionality Added or Changed  Percona Server 5.1.51-rel11.5 is now based on MySQL 5.1.51.  New Features… comments for 5.1.51-rel11.5. (Oleg Tsarev)  Bug #661844 – Fixed a problem with server variables failing test for 5.1.51-rel11.5. (Oleg Tsarev…

Post: Percona Server 5.1.47-rel11.0

… is a uniform naming scheme for Percona binaries for 5.0 and 5.1 based packages. RPM are named as: Percona-Server-51-5.1.47-rel11.0.46.rhel5.x86_64.rpm Percona-Server-client-51-5.1.47-rel11.0.46.rhel5…-package 51 – suffix, which means the packages are based on 5.1.x versions Together “Percona-Server-server-51” is the package name. 5.1.47…

Post: MySQL 6.0 vs 5.1 in TPC-H queries

5.1 and 6.0 in cold mode (I dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour 6 min 2.21….87 65362.27 2.43 240.66 0.28 0.51 0.50 27.08 As you see we have sequential…

Post: TPC-H Run on MySQL 5.1 and 6.0

… MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0… one query which does not complete within an hour in 5.1 and MySQL 6.0 can complete all queries within an… close and MySQL 6.0 is even significantly slower than 5.1 for number of queries. Honestly I expected more from MySQL…

Post: MyISAM mmap feature (5.1)

… same for Windows, but I did not test it). In 5.1 I implemented a new feature: memory mapping for the datafiles….60 1.35 256 6474.26 8577.43 1.32 update nokey Threads Pread Mmap Mmap/pread ratio 1 7665.51 9114.75 1.19 4 10963.06 14964.02 1.36 16 10472.81 14028…

Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6

… of Percona-Server-shared-51-5.1.67-rel14.3.506.rhel6.x86_64 and Percona-Server-shared-55-5.5.29-rel29.4.401… from 5.1 to 5.5 without uninstalling any software that depended on the old version. # rpm -qa | grep ^Percona Percona-Server-client-51-5.1.67-rel14.3.507.rhel6.x86_64 Percona-Server-shared-51-5.1.67-rel14.3.507.rhel6.x86_64 Percona-Server-server-51-5.1

Post: Data Corruption, DRBD and story of bug

5.1.51+ . Now another interesting point – how can you be sure that 5.1.51 works. The bug 55543 is not mentioned in ChangeLog for 5.1.51 nor 5.1.52. However if you… InnoDB-plugin installed – it is STRONGLY recommended to upgrade to 5.1.51+ – Review your HA schema. DRBD by itself (without additional solutions…

Post: Percona XtraBackup 1.5-Beta

… can now be built from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases (fixes bug #683507… InnoDB plugin xtrabackup_51 – for use with MySQL 5.0 & 5.1 with built-in InnoDB xtrabackup_55 – for use with MySQL 5.5 (this binary… been updated to build from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases. (Alexey Kopytov) Release…