Skip to content
ITNotes ITNotes

From Terminal to Cloud

  • AI
  • DevOps
  • HomeLab
  • Linux
  • Networking
  • Programming
  • English
    • English
    • Tiếng Việt
    • 日本語
  • AI
  • DevOps
  • HomeLab
  • Linux
  • Networking
  • Programming
  • English
    • English
    • Tiếng Việt
    • 日本語
Home » slow query
Database tutorial - IT technology blog
Posted inDatabase

MySQL Performance Schema: Diagnose Slow Queries with Internal Statistics Tables

July 13, 2026
MySQL Performance Schema exposes 80+ internal statistics tables that reveal slow queries, lock waits, and I/O bottlenecks — no external tools required. This guide covers the key tables, practical SQL queries, and a Python script to build a baseline monitoring system from six months of production experience.
Read More
Database tutorial - IT technology blog
Posted inDatabase

PostgreSQL Performance Analysis with pg_stat_statements: Find and Fix Slow Queries

May 25, 2026
pg_stat_statements is a built-in PostgreSQL extension that tracks aggregated execution statistics for every query — total time, call count, cache hit rate, and more. This guide walks through enabling it, querying the data to find your worst bottlenecks, and turning those stats into concrete index and query optimizations for production.
Read More
Copyright 2026 — ITNotes. All rights reserved.
Privacy Policy | Terms of Service | Contact: [email protected] DMCA.com Protection Status
Scroll to Top