SYS schema hands-on Posted on December 10, 2024, updated 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 Continue reading
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
Prometheus and Grafana for MariaDB performance monitoring Posted on June 18, 2024, updated on June 18, 2024 by Yannick JaquierTable of contents Preamble Prometheus installation Prometheus node exporter installation Prometheus MySQL/MariaDB exporter installation Grafana installation Grafana configuration Conclusion References Continue reading
Exadata Simulation Workflow hands-on Posted on November 10, 2023, updated on November 10, 2023 by Yannick JaquierTable of contents Preamble Exadata Simulation Workflow execution Exadata Simulation Workflow reporting References Continue reading
SQL Server on Linux – installation – part 1 Posted on October 1, 2022, updated on April 26, 2023 by Yannick JaquierTable of contents Preamble SQL Server on Linux installation SQL Server on Linux command-line tools installation Final cleaning to have all database files in good directories AdventureWorks example database installation Conclusion and next steps References Continue reading
MariaDB PAM LDAP authentication with newest SSSD daemon Posted on February 28, 2022, updated on February 23, 2022 by Yannick JaquierTable of contents Preamble MariaDB PAM LDAP Linux and database configuration Ldapsearch configuration MariaDB PAM LDAP authentication with legacy nslcd configuration MariaDB PAM LDAP authentication with System Security Services Daemon (SSSD) References Continue reading