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…
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… Gearman Worker to take update transactions to apply and pace MySQL transactions to the real master db. You can configure multiple… DB load increases. And better yet, you could use Percona MySQL Cluster to have a dedicated master for all batch job processing… based on load statistics of the other dbs in the cluster. Maybe Percona could implement built-in update pacing using Gearman…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… XtraDB Cluster 5.5.23, which comes with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support… Debian packages. Downloads: http://www.percona.com/downloads/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports…
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… experience to degrade. The first thing you need to know it is not MySQL problem, might be even not problem with your MySQL… load on it the response times will increase and user experience will suffer. So what you can do to prevent this…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… NOT have any features to disable the binary log; my experience has been that this is a very dangerous thing to…
Post: Webinar: MySQL and SSD
May 8, 2012 By Leave a Comment
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
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…. 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…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… seeing. But first I’d like to note that this experiment isn’t really running the iiBench problem. The point of… problem is to measure the cost of index maintenance. This experiment isn’t measuring the cost of index maintenance. Transaction-id… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
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 …. You will also get a signed copy of High Performance MySQL 3rd edition as an attendee.
