Including performance improvments. Since i don't have a deep view into MySQL or TestLink development, i can't estimate the outcome of those new database functions and features, related to the testlink-framework.
We're having a few performance problems in Testlink-Environment (Version 1.9.3 ), which could naturally be related to the testlink framework or the database. Before i update the Database in a Test-Environment and go for a maintenance-test, i would love to get a feedback.
I would like to know, if those new supported database-features should have a positive side-effect on the testlink performance as well.
Performance Improvements
Full Listing @ http://dev.mysql.com/tech-resources/art ... l-5.6.html
Optimizer Improvements
Index Condition Pushdown
Moves more of the processing for WHERE clauses to the storage engine. Instead of fetching entire rows to evaluate against a set of WHERE clauses, ICP sends those clauses to the storage engine, which can prune the result set by examining index tuples. The result is less I/O overhead for the base table, and less internal communication overhead for the server and the storage engine. This feature works with InnoDB, MyISAM, and NDBCLUSTER tables. Read more about index condition pushdown.
Multi-Range Read
Until the day when you have all the SSDs you want, it's faster to read data sequentially from disk than to do random accesses. For secondary indexes, the order for the index entries on disk is different than the order of disk blocks for the full rows. Instead of retrieving the full rows using a sequence of small out-of-order reads, MRR scans one or more index ranges used in a query, sorts the associated disk blocks for the row data, then reads those disk blocks using larger sequential I/O requests. The speedup benefits operations such as range index scans and equi-joins on indexed columns. (Think InnoDB foreign keys.) Works all storage engines. Read more about multi-range read.
File Sort Optimization
For queries that combine ORDER BY non_indexed_column and a LIMIT x clause, this feature speeds up the sort when the contents of X rows can fit into the sort buffer. Works with all storage engines.