Flink CDC for database replication to big data Posted on September 30, 2026 , Modified on October 23, 2026 , by Yannick JaquierTable of contents Preamble Iceberg installation in Spark Flink installation Flink CDC installation PostgreSQL source database configuration Iceberg sink configuration MariaDB source database configuration Oracle source database configuration Issues encountered Connection refused /tmp in noexec REST/Web UI upload handler still in /tmp References Read more Hadoop, MariaDB, MySQL, Oracle, PostgreSQL Development Leave a comment
Sqlglot as a backup for your database migration Posted on April 20, 2026 , Modified on March 27, 2026 , by Yannick JaquierTable of contents Preamble Sqlglot installation Sqlglot testing References Read more MariaDB, MySQL, Oracle, PostgreSQL, Python, SQL Server Development Leave a comment
SYS schema hands-on Posted on December 10, 2024 , Modified on December 10, 2024 , by Yannick JaquierTable of contents Preamble SYS schema configuration Instances global waits SYS schema schema view SYS schema side procedures sys.diagnostics() sys.statement_performance_analyzer() sys.format_time() and sys.format_bytes() References Read more MariaDB, MySQL Administration, Tuning Leave a comment
Information schema hands-on Posted on November 20, 2024 , Modified 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 Read more MariaDB, MySQL Administration, Tuning Leave a comment
Performance schema hands-on – part 2 Posted on October 30, 2024 , Modified on December 6, 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 Read more MariaDB, MySQL SQL, Tuning 1 comment
Performance schema hands-on – part 1 Posted on October 10, 2024 , Modified on December 6, 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 Read more MariaDB, MySQL SQL, Tuning 2 comments