… installed new drivers and firmware, and in fact, the result improved. Information about driver and firmware: Firmware v6.0.0, rev….3) Random writes: For random writes there is not much improvements, the throughput is about the same. Random reads: But there… random reads per threads, throughput: Response time: Again, there is improvement in throughput, in both in quality and absolute value. For…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… Cluster 5.5.23, which comes with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support…, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… using secondary indexes. While secondary indexes cause read performance to improve, but they have an impact on the write performance. Well…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… variant of the MySQL server. We have a history of improving the MySQL server and finding and solving bugs in it…
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…
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.
Comment: MySQL on Amazon RDS part 1: insert performance
April 25, 2012 By 37 Comments
I see no improvement from RDS with innodb_flush_log_at_trx_commit set to 2 or 0. My benchmarks have the same results, regardless of the setting. Does RDS fools the flush in some way or has the setting disabled somehow?
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… lot of nice features like less lock contention, better diagnostics, improvements to partitioning, and the addition of multiple InnoDB buffer pools… needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as a…
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… much of a difference in the query times. Conclusion BKA improves the query time by a huge margin for IO bound… BKA performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5 or from…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… a wrong choice. It looks like that there is still improvement and changes needed in the optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance of secondary key lookups as well. But this… tuples fit in the buffer. But there is no performance improvement when the workload is in-memory, in fact MRR adds…
