…, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus… unnoticed by most (not all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not have… is a waste of resources that could potentially impact our performance, and should be avoided. By the way, a good practice…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…_blocks_time had an effect on performance of the benchmark. There was some discussion in the comments and I promised to follow… investigate further), but I believe the adaptive hash index is improving performance of InnoDB significantly during the hot run, as hash indexes… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… runs Percona Performance Conference as a free event going concurrently with the conference and announced Percona XtraDB as improved and extended Innodb… you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! Thank you. Additionally, I’d like…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… better performance with Percona Server 5.1, probably due to improvements such as our I/O algorithms and reduced mutex contention. The performance improvements I got with Percona Server were similar to the performance improvements… plug into this post’s comments. I haven’t evaluated their technology, so I can’t comment on it. I’m sure…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your concerns are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? We also want… server optimization. Schema and query optimization can give much greater improvements, for example. If you’re familiar with Malcolm Gladwell’s… Percona performance audit, although as you’ve seen there really isn’t any such thing. Post your questions in the comments, and…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… revenue, c_acctbal, n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_custkey = o_custkey… 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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… gives up to 23% improvement when WB cache is used. With WT cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads…. If you have some numbers to share, please leave a comment. Next, I plan to look at IO alignment on Flash…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…something significant please let me know through the comment and I’ll update the page Scalability – …INNODB_METRICS – - Meta Data Information Tables – - Buffer Pool Information Tables – Improved PERFORMANCE_SCHEMA – - Reduced Overhead – - Simplified Configuration – - Table Access instrumentation – -…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…UPDATE (5-Oct-2009): James Birchall recommended to use hint COMMENT ‘lookup’ for fields in InfoBright that have less 10….to edit query or check history), the documentation also needs improvements. The fact it does not use the compression also …if you want to compare or get info about air performance.
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) So we have… over 20x performance improvement to the speed of ALTER TABLE, as this is not only step which ALTER TABLE does the improvement to the index creation speed itself has to be even larger. It is also offers better performance for in…
