May 26, 2012

Comment: How much memory Innodb locks really take ?

I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…

Post: Percona Server 5.5.22-25.2 released!

Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now the… keys. Bug fixed #892951 (Laurynas Biveinis). Release notes for Percona Server 5.5.22-25.2 are available in our online documentation.

Post: Introducing Zend DBi as a MySQL Replacement on IBM i

… difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically on Zend… by providing our own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs…

Comment: Testing Fusion-io ioDrive - now with driver 3.1

… benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1…

Comment: How to change innodb_log_file_size safely

….cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf…

Post: Zero-Downtime Schema Changes In MySQL

…x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I …to do and causes way too many bugs in the server and the tool, so there is no code in … of this tool? It was completely rewritten in version 2.1. Q: qw() as use of () is deprecated That …

Post: Percona Server 5.5.23-25.3 released!

… Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3….5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server would crash on a DDL statement if an XtraDB internal… table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server 5.5.23-25.3 are available in our online…

Post: Percona Server 5.1.62-13.3 released!

Percona is glad to announce the release of Percona Server 5.1.62-13.3 on April 25, 2012 (Downloads … Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3… is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13.3 are available in our online…

Post: Benchmarking single-row insert performance on Amazon EC2

… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following…_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct… I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… boxs with MySQL 5.5 (Ubuntu Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make…