May 25, 2012

Post: 5.0.75-build11 percona binaries

… you may know Sun / MySQL made release of community 5.0.75 only as source code release. We made binaries with our patchset. Patches are mostly equal to build 10 http://www.mysqlperformanceblog.com/2008/12/11/mysql-binaries-percona-build10…/percona-patches/+bug/308849 You can download binaries (RPMS x86_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b11/

Post: 5.0.75-build12 Percona binaries

After several important fixes to our patches we made binaries for build12. Fixes include: Control of InnoDB insert buffer to … to tune the insert buffer. * innodb_ibuf_active_contract (default 0) – By default (same to normal InnoDB), the each user threads… Ruby on Rails application. You can download binaries (RPMS x86_64) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/

Comment: 5.0.75-build12 Percona binaries

….com/mysql/5.0.75-b12/source/mysql-5.0.75-percona-b12-src.tar.gz, but each time I try to decompress it, I get an error: mysql-5.0.75/Docs/INSTALL-BINARY mysql-5.0.75

Post: Just how useful are binary logs for incremental backups?

… day of binary logs  it would take an additional 20 hours ((12 * 0.9) + (12 * 0.75) = 19h48m). …apply the binary logs continuously until it catches up, you will be waiting almost 5 days until that…Eventually this problem should be lessened by a MySQL Server feature – parallel execution on slaves.  …

Post: Xtrabackup, doing once...

… in code / not fully scripted builds / not fully tested all MySQL versions, but backups work just fine! I am able to… solution for InnoDB / XtraDB engines for MySQL 5.0 / 5.1 versions. Currently we tested only for 5.0.75 / 5.0.77 and it works just fine. We…:~percona-dev/percona-xtrabackup/alpha-0.2 , after some polishing and more testing we will prepare binary builds. Test it if you…

Post: MySQL 5.5.8 - in search of stability

MySQL 5.5.8 (the tar.gz binary from dev.mysql.com), and for the other tests I used Percona Server based on 5.5…we disable doublewrite; that is, set innodb_doublewrite=0. Now, although throughput is not a perfect line,…run, but with innodb_max_dirty_pages_pct=75. The 75% dirty pages line is at a stable…

Post: What is stored InnoDB buffer pool

MySQL 5.0 which show innodb buffer pool content mysql

Post: Copying InnoDB tables between servers

…/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… you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds with 5.1.36. On…65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85…

Comment: Returning to InnoDB scalability

…20:56:56 [Note] /opt/mysql/bin/mysqld: ready for connections. Version: ‘5.0.22-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution…you hit a bug. It is also possible that this binary or one of the libraries it was linked against is…65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 …