enable the Slow Query Log in MySQL
✅ IMMEDIATE ACTIONS (DO THESE NOW)
1️⃣ Enable MySQL slow query log (VERY IMPORTANT)
SET GLOBAL slow_query_log = ON;
SET GLOBAL long_query_time = 1;
Then watch:
tail -f /var/lib/mysql/*-slow.log
tail -f /var/log/mysql/mysql-slow.log
This will show exact queries + which site causes them.
2️⃣ See live MySQL queries
SHOW FULL PROCESSLIST;
Comments
Post a Comment