June 19, 2013

Post: 5.0.87-build20 Percona binaries

… build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with… version>....rpm Example: MySQL-server-percona-5.0.87-b20.29.rhel5.x86_64.rpm See release notes for…/ gpgcheck=0 As usual you can download binaries and sources with the patches here http://www.percona.com/mysql/5.0.87-b20/ There…

Post: Percona Server 5.0.90-build21

Dear Community, Percona Server 5.0.90, release 21 is available for use. Comparing to the … MySQL-5.0.90 Fixed bugs: Fixed Bug #539190 Percona-XtraDB package doesn’t allow libmysqlclient15off Fixed Bug #479106 mysql-5.0.87 + patches-5.0.86…

Post: Too many connections? No problem!

… that ever happen to you in production? [percona@sandbox msb_5_0_87]$ ./use ERROR 1040 (00000): Too many connections Just happened to… restarting the application? Here’s the trick: [percona@sandbox msb_5_0_87]$ gdb -p $(cat data/mysql_sandbox5087.pid) \ -ex “set max… msb_5_0_87]$ ./use Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.87

Comment: Upgrading MySQL

Speaking of upgrading 5.0 vs 5.1, which Percona build do you recommend be used in production, 5.1.34-5 or 5.0.87-b20? The…

Comment: Percona-XtraDB version 9.1

Peter, There is MySQL-shared-compat in our repo. it provides .12.so – .16.so: MySQL-shared-compat.x86_64 : MySQL shared client libraries for MySQL 5.1.40, 5.0.87, 4.1.22 and 4.0.26

Comment: Disaster: LVM Performance in Snapshot Mode

….1 0.1 0.1 0.7 0.0 1693.7 | 1357.2 0.1 73.6 1480.5 87.1 | 336.5 0.1 0.1 2.1 0.0 1696.2 | 1355.7 0.1 73.8 1520.0 86.4 | 340.4 0.1 0

Post: MySQL 6.0 vs 5.1 in TPC-H queries

… TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a….27 4.87 247.70 0.27 0.52 0.52 27.22 dm-0 0.00 0.00 542.60 0.61 130724.54 4.87 65362.27 2.43 240.66 0.28 0

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

… bound. That said, benchmark was running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data…_prg {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0 Misaligned: #ts…_prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number of…

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

….84 5.6.10 (innodb_old_blocks_time=0) 128M 349.24 178.80 178.55 179.07 5.5.30 4G 200.87 20.53 20.36 20.35 5.6… | 0 | 0 | 90 | 90 | | 5 | Opening tables | 0.270664 | 0.295955 | 0.025996 | 0.024996 | 34 | 35 | 2056 | 1488 | 48 | 48 | | 2 | starting | 0.000230 | 0.000192 | 0.000000 | 0.000000 | 0 | 0 | 0 | 0

Post: What is stored InnoDB buffer pool

5 | unknown | | | | | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 6 | unknown | | | | | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 3 | inode | | | | | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 6 | 17855 | index | CLUST_IND | | SYS_IBUF_TABLE_0 | | 5 | 0