I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… 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…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is… of ~25k INSERTs Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs Per Second. Let’s take… is pretty much constant remaining between ~25k to ~26k INSERTs Per Second. But on the other hand, with the table having secondary…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… 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 details of the release can be found in the 5.5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… 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… encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13.3 are available in our online documentation.
Post: Percona Server 5.5.22-25.2 released!
April 26, 2012 By Leave a Comment
… 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 details of the release can be found in the 5.5.22-25.2 milestone at Launchpad. Bugs Fixed: While running…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…. For 2 or more, the throughput varies a lot from second to second. I draw boxplots, which show 25-50-75 percentiles… MiB/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… my 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… in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary…
Comment: Testing Virident FlashMAX 1400
May 8, 2012 By 3 Comments
Austin, I am not aware that Turbo=1 affects life time by itself. It is just that wit turbo=1 you will be able to perform more writes per second, and if you do, then physical time of life may be shorter, because you will use all 15PB of writes in shorter period of time.
