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: 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? Do… am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3…

Post: Load management Techniques for MySQL

… performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… response times will increase and user experience will suffer. So what you can do to prevent this problem from happening ? The…

Post: Zero-Downtime Schema Changes In MySQL

… recording of yesterday’s webinar, as well as a PDF of my slide deck,…tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a run. will that cleanup ? Q: …x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I …

Post: Percona Server 5.5.23-25.3 released!

… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it… in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can…

Post: Webinar: MySQL and SSD

Just as a reminder – tomorrow, May-9, 2012, at 11am PDT I will be giving a free webinar “MySQL and SSD”. This is the same talk I gave on Percona Live MySQL Conference, so if you were there – you probably will find nothing new. Otherwise, you are welcome to join!

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

… still users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have… DBi. It is basically a renamed build of MySQL for IBM i. It’s a 100% compatible drop-in replacement. Everything works… to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona…

Post: Percona Server 5.1.62-13.3 released!

… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can…

Post: Percona Server 5.5.22-25.2 released!

… available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it… in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can…

Post: Benchmarking single-row insert performance on Amazon EC2

… m2.4xlarge instance as that’s the instance type with highest memory available, and memory is what really really matters. High-Memory… EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…