… witnessing the LOAD DATA INFILE command being replicated in verbatim on our master / slave pairs? To reiterate, are you suggesting that… INFILE command is executed on master? (cuz that’s not what I’m seeing on our systems, with binlog left on at master when…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 27, 2012 By 10 Comments
… issue (shouldn’t affect reads that much though, but it’s possible with high random I/O pattern) as these drives… as well? I know it’s not normally an environment to run MySQL on, but IF there’s reasonable advantage with SSDs, then…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I … still the tool serves well for benchmark purposes. OK, let’s start off with the configuration details. Configuration First of all… cause read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and hence…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… not properly indexed. Here’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse and… years ago when the iiBench project started, today the challenge would be to index 10B rows, not 1B rows. And it’s…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
Following my series of posts on testing different SSD, in my last post I mentioned that SATA SSD performance is getting closer to… before getting to that, let me review the same workload on Fusion-io ioDrive PCIe card. This is yet previous generation… read IO cases. Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… this test I also use Cisco UCS C250 server, and on the graph I show the results for both single card…: We see stable and predictable write performance, with throughput: 660 MiB/s for single, and 1300 MiB/s for Duo Random reads: Again… more stable performance results comparing to previous generation ioDrive. Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… see a healthy thread spread across a good number of years. Thanks Baron! As I was reading the part about replication… idea to turn off the session’s binary log in general. But if it’s left on, the replication logic only replicates that… the LOAD DATA can happen asynchronously on all boxes. Yes, it’s a pain, but it’s better than replication clogging up for…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… replacement for MySQL on the IBM i platform. Zend approached us to say that they want to ensure there’s a way… IBM i. It’s a 100% compatible drop-in replacement. Everything works on Zend DBi just as it works on MySQL, with no… to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona…
Post: Testing Fusion-io ioDrive - now with driver 3.1
May 7, 2012 By 2 Comments
… flawless, after a firmware upgrade I had to perform low-level formatting, which erase all data. So … improvement for random reads. The results is stable on 640 MiB/sec level and it is higher … before). Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id…
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 … you have if you put too heavy of concurrent load on it the response times will increase and user experience will…
