Information schema hands-on Posted on November 20, 2024, updated on November 20, 2024 by Yannick JaquierTable of contents Preamble Information Schema configuration Information Schema global status queries Aborted clients All clients traffic Comparison of on-disk and memory temporary tables Com_xxx and Handler_xxx variables InnoDB free and dirty space and data read and written InnoDB log buffer write rate Query cache statistics Tables joins performance Information Schema InnoDB queries InnoDB buffer pool statistics InnoDB locks InnoDB metrics Information Schema remaining tables Processlist Routines Users and Schemas privileges System variables References Continue reading
Performance schema hands-on – part 2 Posted on October 30, 2024, updated on October 30, 2024 by Yannick JaquierTable of contents Preamble Performance Schema with global and digest instrumentation Performance Schema with global, thread and current event instrumentation Performance Schema with global, thread and event history instrumentation Performance Schema impact References Continue reading
Performance schema hands-on – part 1 Posted on October 10, 2024, updated on October 9, 2024 by Yannick JaquierTable of contents Preamble Performance schema activation and configuration Performance Schema with global instrumentation Only Performance Schema with global and thread instrumentation References Continue reading
innodb_io_capacity and innodb_io_capacity_max tuning Posted on September 20, 2024, updated on September 20, 2024 by Yannick JaquierTable of contents Preamble Fio Buffered I/O Non buffered I/O Iostat Sysbench innodb_io_capacity and innodb_io_capacity_max Huge Pages References Continue reading
Automatic SQL Tuning Sets (ASTS) hidden feature hands-on Posted on August 30, 2024, updated on September 4, 2024 by Yannick JaquierTable of contents Preamble ASTS activation ASTS test case ASTS testing SPM and ASTS testing References Continue reading
In-Memory OLTP for rapid data ingestion Posted on April 20, 2024, updated on April 22, 2024 by Yannick JaquierTable of contents Preamble In-Memory OLTP preparation In-Memory OLTP testing In-Memory OLTP to durable tables INSERT INTO disk_based_table SELECT FROM memory_optimized_table Temporal memory-optimized table Issues encountered References Continue reading