… from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one… do this for us. I am sure there are many in this situation.
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… the fixes in your kernel, and many of Percona’s customers are in the same situation. That’s why we don’t use RHEL… I ran the benchmark above, we were using Linux 2.6.32, as my blog says. We‘re now on 2.6.38… ‘x’ we use then, we‘re currently on 3.0). But I agree with you that there’s a difference between when the developers…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
Bartosz, You are right this is due to an optimizer inefficiency. But till the time the optimizer is not efficient enough we would have to use workarounds. In fact hints tend to be used a lot because although mostly optimizer makes good choices but sometimes it doesn’t.
Comment: Load management Techniques for MySQL
May 10, 2012 By 3 Comments
… these workers can easily throttle themselves when the DB load increases. And better yet, you could use Percona MySQL Cluster to have… all batch job processing and use Gearman Workers to apply updates to this dedicated master, using pacing in the Gearman Workers based on load statistics of the other dbs in the cluster. Maybe Percona could implement built-in update…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… of previous benchmarks, first is random write async 16KB case. We can see some wave-like pattern with throughput 350-400… read-only workload to have such variety in throughput. It gets even more interesting when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (i.e. 4 threads) we…
Comment: Testing Intel SSD 520
May 3, 2012 By 7 Comments
Vadim, “End-to-End Data Protection” means it uses checksums when retrieving the data from flash chips. Compression is used, because in 520 Intel uses the SandForce controller and not their own controller like in 320. Good point that it’s the fact, that may spoil the results!
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… free, all the details of the release can be found in the 5.1.62-13.3 milestone at Launchpad. New… the mysqlbinlog utility that allows the changing names of the used databases in both Row-Based and Statement-Based replication. This was possible before by using tools like grep, awk and sed but only…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…that would defeat the purpose of the tool. Q: When you say bail out, what does that mean? …or triggers. It is designed to be resumable, although we don’t yet have a “resume” feature implemented. Q…completely rewritten in version 2.1. Q: qw() as use of () is deprecated That sounds like you’re using an …
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…of 30 bytes in the primary table, and so a billion rows is about 30GB. Since we are inserting …10 times bigger than they were 4 years ago when the iiBench project started, today the challenge would … slightly incorrect. The correct URL for version you used is http://tokutek.com/downloads/iiBench-1.0….
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… have a better view of the whole picture. Note, in the above graph, we have “millions of rows” on the x-axis… insert rate was decreased. Conclusion As we all now there are pros and cons to using secondary indexes. While secondary indexes cause… indexes. Other important things to consider when you are concerned with write performance is using partitioning to reduce the size of the…
