May 25, 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…

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 After doing…

Comment: Percona Server 5.5.23-25.3 released!

@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.

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: Make your file system error resilient

…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway it … if allocated. When an ext* filesystem with “reserved block count: 0” is nearly full, this generates file fragmentation, performance issues, unless…

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…

Post: Percona Server 5.5.23-25.3 released!

… Percona Server 5.5.23-25.3 on May 16, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now the current stable release in the 5.5… table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server 5.5.23-25.3 are available in our online documentation.

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 … binary logging at all. Are you using the 2.0 version of this tool? It was completely rewritten in …

Post: Percona Server 5.1.62-13.3 released!

Server 5.1.62-13.3 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62-13.3 is now the current stable release in the 5.1 series. All of…

Post: Percona Server 5.5.22-25.2 released!

… Percona 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 current stable release in the 5.5… keys. Bug fixed #892951 (Laurynas Biveinis). Release notes for Percona Server 5.5.22-25.2 are available in our online documentation.