InnoDB plugin versus built-in InnoDB Posted on February 21, 2011, updated on March 26, 2021 by Yannick JaquierTable of contents Preamble Sysbench MySQL 5.1.49sp1 with InnoDB plugin (read/write mode) MySQL 5.1.49sp1 with InnoDB plugin (read only mode) MySQL 5.1.49sp1 with built-in InnoDB (read/write mode) MySQL 5.1.49sp1 with built-in InnoDB (read only mode) MySQL 5.5.9 (read/write mode) MySQL 5.5.9 (read only mode) DBT-2 MySQL 5.1.49sp1 with InnoDB plugin MySQL 5.1.49sp1 with built-in InnoDB MySQL 5.5.9 Conclusion References Continue reading
Deferred statistics publishing Posted on February 4, 2011, updated on June 25, 2015 by Yannick JaquierTable of contents Preamble Test table Deferred statistics testing Continue reading
Server result cache to improve performance by holding result sets Posted on January 21, 2011, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Server result cache Manual mode Force mode Table annotations PL/SQL function result cache Client result cache References Continue reading
Bind variables peeking and Adaptive Cursor Sharing (ACS) Posted on January 14, 2011, updated on January 26, 2016 by Yannick JaquierTable of contents Introduction Testing Before Oracle 11g Starting with Oracle 11g References Continue reading
CURSOR_SHARING initialization parameter tips and tricks Posted on January 6, 2011, updated on March 26, 2021 by Yannick JaquierTable of contents What to do/not do Testing CURSOR_SHARING=exact (default value) CURSOR_SHARING=similar Without histograms With histograms CURSOR_SHARING=force Conclusion References Continue reading
Database Resource Manager (DBRM) to manage and prioritize resources Posted on July 14, 2010, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Database resource manager configuration Database resource manager testing References Continue reading