Securefiles LOB and Database File System (DBFS) hands-on Posted on September 30, 2013, updated on May 29, 2019 by Yannick JaquierTable of contents Preamble Basicfiles LOBs Securefiles LOBs Migration from basicfiles LOBs to securefiles LOBs DBFS References Continue reading
Can Recycle Bin impact performance ? Posted on August 30, 2013, updated on August 7, 2015 by Yannick JaquierTable of contents Preamble How recycle bin comes in loop References Continue reading
MySQL Utilities versus Master High Availability Manager and tools for MySQL (MHA) Posted on July 29, 2013, updated on November 26, 2015 by Yannick JaquierTable of contents Preamble MySQL Utilities Installation Usage Master High Availability Manager and tools for MySQL (MHA) Installation Usage How to move MySQL Replication from GTID to standard mode Conclusion References Continue reading
MySQL Replication with Global Transaction Identifiers (GTID) hands-on Posted on June 28, 2013, updated on June 20, 2023 by Yannick JaquierTable of contents Preamble Replication with GTID prerequisites Using XtraBackup Using mysqldump Semi-synchronous replication How to remove replication References Continue reading
Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013, updated on March 26, 2021 by Yannick JaquierTable of contents Initial problem First solution and second problem Second solution References Continue reading
AWR baselines and performance comparison Posted on May 8, 2013, updated on March 14, 2019 by Yannick JaquierTable of contents Preamble Good performance Bad performance Performance improved Conclusion References Continue reading