May 25, 2012

Post: Percona-XtraDB version 9.1

…, DEB and tar.gz packages. New features in version 9.1: MySQL 5.1.43 is taken as the basis packages name changed to…) FreeBSD 8 (x86_64 and i386) OpenSolaris (x86_64) Fixed bugs: Bug #506894: buf_flush_LRU_recommendation() is too optimistic Fixed mysql-tests: mysql mysql… should be installed. It will replace currently installed mysql-server, mysql-client, etc. Centos platform. 1. If you didn’t install yet Percona…

Post: XtraDB storage engine release 1.0.6-9

… new features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8… http://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD. There is an RPM…

Post: Percona Server version 10

… XtraDB storage engine. Since the previous release 9.1 there are following changes MySQL 5.1.45 as a basis for the release I… i386) FreeBSD 8 (x86_64 and i386) OpenSolaris (x86_64) Fixed bugs in the release: Bug #551379:Change SE Name at mysql start Bug #550867:5.1.45+xtradb-10 compilation fails on Ubuntu Karmic Bug…

Post: xtrabackup-0.8

… includes: Support of ARCHIVE tables Addded incremental option to innobackupex-1.5.1 script Rollback XA PREPAREd transaction automatically at –prepare To extend… RHEL4,5, Debian, FreeBSD as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.8/. The…

Post: xtrabackup-0.9

…’t compile with MySQL 5.1” Bug #394781: “xtrabackup requires write permissions on original ibdata1″ Bug #395977: “xtrabackup 0.8 crashes during prepare after… innobackupex-1.5.1” Bug #394464: “batch scp copy of .frm, .MRG etc files” The binary packages for RHEL4,5, Debian, FreeBSD, MacOS…

Post: How Percona does a MySQL Performance Audit

FreeBSD box is different). For example, [percona@db1 ~]$ uname -a Linux hostname.domain 2.6.18-92.el5 #1 SMP…: What I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I…5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL

Comment: What's the recommended MySQL version?

… the 5.1 stage made an already painful upgrade a little easier. Unfortunatly, it wasn’t completely successful for me. I upgraded mysql 5.0.90 to 5.5.20, on FreeBSD 8.1. All of the databases have MyISAM tables… had any InnoDB tables. After upgrading, I can’t start MySQL 5.5 without innodb_force_recovery set. If I try to start…

Comment: PBXT benchmarks

… weird results with mysql on an 8cpu server – it performed 3!! :( times slower than on the same 4cpu server: FreeBSD-6.2…) CPU E5335 @ 2.00GHz (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests done with apache benchmark on…-11 requests/s 4 cores: 18-20 requests/s all 8 cores: 5-7 requests/s, whatever did I try to do…

Comment: Choosing innodb_buffer_pool_size

…. we recently upgrade to mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables(small-sized). the… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far…