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

Post: Announcement of Percona XtraDB Cluster 5.5.23

Cluster 5.5.23, which comes with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysqlUbuntu 12.04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster

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… disables binary logging at all. Are you using the 2.0 version of this tool? It was completely rewritten in version…

Post: Benchmarking single-row insert performance on Amazon EC2

…RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-…= 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool …can be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with …

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: 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… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…

Post: Testing Fusion-io ioDrive

… PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me review the…-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks, first… for Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns in the…

Comment: Percona Server 5.5.23-25.3 released!

@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.

Comment: Benchmarking single-row insert performance on Amazon EC2

… version you used is http://tokutek.com/downloads/iiBench-1.0.3.1.tar.gz One of the advantages of the… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…