I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…
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: 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: 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…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… but only for SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… block. so my testing command line looks like: sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time… it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… higher with this partitioning, however since you’ll have to look in each of the ten partitions to query one of… 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.
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… reduced to ~9k INSERTs Per Second. Let’s take a look at the graphs have a better view of the whole…
