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: 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… wave-like pattern with throughput 350-400 MiB/sec. Random reads, async: Interesting to see that there is quite unstable throughput… usual for read-only workload to have such variety in throughput. It gets even more interesting when we go to read sync IO…
Comment: Make your file system error resilient
April 26, 2012 By 8 Comments
…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway it just would …
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
That depends, did you run the read-only case closely following the writes? GC normally runs at low …
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
Rodalpho, It can be related to garbage collection routines, but it can see it also in read-only case, which makes me puzzled. Garbage collector should not act that much in read-only.
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… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… I was reading the part about replication, can you help re-affirm this statement about replication? I’ve observed things differently in MySQL 5… log in general. But if it’s left on, the replication logic only replicates that “command” across the slaves, not the actual imported…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL…
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…-Based and Statement-Based replication. This was possible before by using tools like grep, awk and sed but only for SBR, because…
