Mysqltuner
MySQLTuner is a read-only diagnostic tool that analyzes a running MySQL or MariaDB server and suggests configuration and schema-related improvements based on observed workload statistics. It inspects server variables, status counters, and InnoDB metrics to highlight common bottlenecks such as insufficient buffer sizing, poor query cache assumptions, excessive connection usage, missing indexes, and slow query patterns. On WordPress VPS servers, it is commonly used after the site has real traffic to validate database sizing and stability.
Percona Toolkit
Overview