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

One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…

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

… have heard that Oracle made the decision not to support MySQL for IBM i any longer. This is certainly understandable. However…. Everything works on Zend DBi just as it works on MySQL, with no need to rewrite applications, management scripts, or anything… own Percona Server variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs…

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 would…

Post: Training in London next week

I’m going to deliver MySQL Training next week (May 21-24) in London. This is …. You will also get a signed copy of High Performance MySQL 3rd edition as an attendee.

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…

Post: Announcement of Percona XtraDB Cluster 5.5.23

… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated…

Comment: Load management Techniques for MySQL

… all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having the batch job only use… apply and pace MySQL transactions to the real master db. You can configure multiple workers for quicker batch job execution if the… yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job processing and use Gearman Workers to…