I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program… row-locks are used by one user to lock records for edit/update, so the transaction is not interrupted until the… a program is worth a 1000 instructions. Please do this for us. I am sure there are many in this situation…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… have heard that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However, there… 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
May 18, 2012 By 2 Comments
Thanks for posting the benchmarks. They are very informative. One question: when you configure MySQL, what portion of it resides on the… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other… from downloads area or from our repositories. For this release we will provides binaries for Ubuntu 12.04, they are coming soon…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
….cnf file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf… wonder how many other configuration values have been ignored. Thanks for your help Baron.
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
…, this time I use a different server. For this benchmark it is Cisco UCS C250, while for previous results I used HP ProLiant… to provide full write performance requires 28W. And while many servers can handle 28W on PCIe, this is a non-standard… most stable results and the best absolute performance so far. For reference, other results in series: Fusion-io ioDrive Intel 520…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system… good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data instead of…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… 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…_STATS table. Bug fixed #978036 (Laurynas Biveinis). Release notes for Percona Server 5.5.23-25.3 are available in our online…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… sounds like a potential MySQL bug. Are you sure this is really happening? I would be extremely surprised for such a bug… to do and causes way too many bugs in the server and the tool, so there is no code in the…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
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… sed but only for SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1…
