… traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache to… cause read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
Benoit, Thank you for sharing. What software do you use to show benchmark results? XFS may have fixed bugs and have performance improvements, but again, I need to have it my kernel to able to test it.
Post: Testing Fusion-io ioDrive - now with driver 3.1
May 7, 2012 By 2 Comments
… installed new drivers and firmware, and in fact, the result improved. Information about driver and firmware: Firmware v6.0.0, rev… was not flawless, after a firmware upgrade I had to perform low-level formatting, which erase all data. So if you… random reads per threads, throughput: Response time: Again, there is improvement in throughput, in both in quality and absolute value. For…
Comment: Multi Column indexes vs Index Merge
May 8, 2012 By 30 Comments
…, i know that index or many index on a table improve high perfomance in select queries, but worsen perfomance in Insert… could i balance the choice??? too many indexes and high performance select or high perfomance update with few indexes??? how balance…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… this optimization the idea of MRR is further extended to improve join performance. As I told you above, when table t1 would… these buffers should be increased appropriately for the best possible performance gain. This is not entirely visible in the manual either… MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance improvement…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… calls made to the storage engine to perform the index record read and then to perform the MRR range scan on the… improvement and changes needed in the optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance… index tuples fit in the buffer. But there is no performance improvement when the workload is in-memory, in fact MRR adds…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places, so you… different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as a…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to… EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search… better handling joins of many tables as optimizer heuristics are improved so much higher search depths are feasible now.
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn’t… the lead author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny…
