June 20, 2013

Post: Percona RPMS for RedHat 5 / CentOS 5 x86_64

… of our release for RedHat 5 / CentOS 5 x86_64 platform. http://www.mysqlperformanceblog.com/mysql/RPM/RHEL5/5.0.62/ There was question what patcheset… patch). More here http://www.mysqlperformanceblog.com/2008/04/24/mysql-extensions-for-hosting/

Comment: Percona Server and Percona XtraBackup

… file or directory *** Error code 1 Stop in /usr/mace/mysql/unp/mysql-5.0.62-percona/sql. *** Error code 1

Post: Identifying the load with the help of pt-query-digest and Percona Server

…, not just for new connections as in MySQL. This is very helpful for measurement as …0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0… r bytes 0 0 0 0 0 0 0 0 # IO r ops 0 0 0 0 0 0 0 0 # IO r wait 0 0 0 0 0 0 0 0 # pages distin 40 11.77k 34 44 38.62

Post: What is stored InnoDB buffer pool

… we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_… | | | | 60 | 0 | 60 | 132 | 0 | 0 | 0 | 62 | 4 | ibuf_free_list | | | | | 61 | 0 | 61 | 69 | 0 | 0 | 0 | 63 | 4 | ibuf_free_list | | | | | 62 | 0 | 62 | 44 | 0 | 0 | 0 | 64 | 4 …

Comment: Percona builds with patches

Hello, I still miss the binarys for: mysql-common_5.0.62_all.deb mysql-server_5.0.62_all.deb mysql-client_5.0.62_all.deb regards Ricardo

Comment: Percona builds with patches

…/mysql/debian/, but I think I´m to foolish to install. I installed the packages mysql-common_5.0.62_all.deb mysql-server_5.0.62_all.deb mysql-client_5.0.62_all.deb with dpkg -i but…

Comment: Percona builds with patches

…/mysql/debian/, but I think I´m to foolish to install. I installed the packages mysql-common_5.0.62_all.deb mysql-server_5.0.62_all.deb mysql-client_5.0.62_all.deb with dpkg -i but…

Post: New patches, new builds

… announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches… it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it with MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC. Along with previously mentioned patches, to 5

Post: Copying InnoDB tables between servers

… percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line table…/vadim/mysql/export/ xtrabackup Ver 0.8.1rc Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql… 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72…

Post: FreeBSD tests

… in FreeBSD and did not saw http://wikitest.freebsd.org/MySQL before. This page recommends to use libthr instead of libthreads… Suse 10.0 Suse/ FreeBSD ratio 1 344.72 429.89 1.25 4 531.6 863.23 1.62 16 494… Core Athlon 3800+, 1Gb of RAM, Motherboard ASUS A8N-E MySQL 5.0.22 params for InnoDB: –innodb-buffer-pool-size=500M –max…