I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program… do this for us. I am sure there are many in this situation.
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… to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1.1 driver…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… hands. In this post I show the results of raw IO performance of this card. The benchmark methodology I described in previous posts, so let me jump directly to results… grow in throughput after 2 threads, and the result averages at 300 MiB/sec. I am still interesting in asynchronous IO, as MySQL 5…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
… throughput I’ve seen so far in my benchmarks. To see distribution of response time, the results for random read synchronous IO… FlashMAX shows the most stable results and the best absolute performance so far. For reference, other results in series: Fusion-io ioDrive Intel…
Comment: Version 1.0 of Percona Monitoring Plugins Released
April 27, 2012 By 7 Comments
Hi Baron, I see that the pmp-check-mysql-innodb plugin for Nagios leaves a lot of files (e.g. pmp-check-mysql-innodb.1196) in /tmp. Is that a desired feature? Thanks Daysen
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… result is Zend DBi. It is basically a renamed build of MySQL for IBM i. It’s a 100% compatible drop-in replacement… on MySQL will run identically on Zend DBi with no modification, and vice versa. In addition, Zend DBi will remain compatible with MySQL in the future, so it is a no-lock-in solution. If you…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…: Isn’t it possible to take all the locks required in the beginning to prevent dead locks? So you would get… MySQL bug. Are you sure this is really happening? I would be extremely surprised for such a bug to be happening. In… 2.0 version of this tool? It was completely rewritten in version 2.1. Q: qw() as use of () is deprecated…
Post: Training in London next week
May 16, 2012 By Leave a Comment
I’m going to deliver MySQL Training next week (May 21-24) in London. This is a rare opportunity as I do…. You will also get a signed copy of High Performance MySQL 3rd edition as an attendee.
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many…. Introduce Throttling Sometimes even single process overloads system too much in this case throttling by having relatively short queries and introducing…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and… 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server… 181G. Now let’s come down to the interesting part. Results With the table purchases_noindex, that has no secondary indexes…
