I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…
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… 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
May 16, 2012 By 11 Comments
…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: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated… and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com/downloads/Percona…
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…
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… 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
May 3, 2012 By 1 Comment
… 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: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 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…
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.
