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…
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: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… recording of yesterday’s webinar, as well as a PDF of my slide deck,…run. will that cleanup ? Q: dose the tool exit gracefully while interupted? The tool doesn’t clean up the temporary table …x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I …
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… still users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have… DBi. It is basically a renamed build of MySQL for IBM i. It’s a 100% compatible drop-in replacement. Everything works… to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
…here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in…release in the 5.1 series. All of Percona‘s software is open-source and free, all the …Statement-Based replication. This was possible before by using tools like grep, awk and sed but only for SBR,…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… which this tool was originally built is long over, but still the tool serves well for benchmark purposes. OK, let’s start off… EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it… stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… spread across a good number of years. Thanks Baron! As I was reading the part about replication, … about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA … sure to delete the INFILE from the slave’s filesystem). e.g. To reiterate this, make sure ‘/…
Post: Zero-downtime schema changes webinar recording
May 8, 2012 By Leave a Comment
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!
