… written to the bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks… on the __tmp_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I… code in the tool that disables binary logging at all. Are you using the 2.0 version of this tool? It was…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… that the insights to the binlog would likely show what you‘ve said and I do agree that turning off session… you explain why I’m witnessing the LOAD DATA INFILE command being replicated in verbatim on our master / slave pairs? To reiterate, are you…
Comment: FlashCache: first experiments
May 3, 2012 By 18 Comments
You said “* InnoDB files layout: ibdata1 and ib_logfile* are placed on separate RAID partition ( not on FlashCache or SSD)” Why did you exclude…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… it is hard to emulate high IO load. That’s why I was looking for alternatives, and Zipfian distribution seems decent…,000^1.1) = 39 times. Obviously with θ=0 we are getting uniform distribution – each row is accessed equal times ( for… tree https://code.launchpad.net/~vadim-tk/sysbench/zipf-distribution, you are welcome to try if it sounds interesting. I am going…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
You might have heard that Oracle made the decision not to … understandable. However, there are still users who want to continue running IBM i and MySQL. That’s why we’re happy to… you want to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… and “INSERTs Per Second” on the y-axis. The reason why I have chosen to show “millions of rows” on the… insert rate was decreased. Conclusion As we all now there are pros and cons to using secondary indexes. While secondary indexes… with no secondary indexes. Other important things to consider when you are concerned with write performance is using partitioning to reduce the…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… understand you need the fixes in your kernel, and many of Percona’s customers are in the same situation. That’s why we…, we’re currently on 3.0). But I agree with you that there’s a difference between when the developers consider… can actually get the fix, regardless of whether or not you‘re on a slow track with RHEL or on a…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… its write performance – I wrote about it before, that’s why I am looking for comparable alternatives. Samsung 830 256GB looked… throughput than Intel 320 (some results for Intel 320). If you are interested more in SSD and MySQL questions – I will be… talk on Percona Live MySQL Conference 2012, if you did not attend my talk – you are welcome to join the webinar. Follow @VadimTk…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… event you should not miss if you‘re at all interested in MySQL. We really want you to be there — and that’s why… 10th-12th Three first prizes are a free full conference pass to the conference and tutorials; you are responsible for your own travel… conference or mailed to winners who are unable to attend. You’re not eligible to win if you’re affiliated with the event…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… points to problem with optimizer performance. Note though if you have subqueries these might need to be executed …. I was wondering if 0 is automatic selection why do we have value of 62 being default … than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins of …
