How to Use mysqldumpslow for Slow Query Analysis
Turn on the MySQL or MariaDB slow query log, summarize it with mysqldumpslow, and find the queries that slow your website down. Includes sorting, filtering and reading the output, plus how to do it from OpenPanel without SSH.