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

Popular posts from this blog

how to install internet download manger in linux

ImportError: DLL load failed while importing onnx_cpp2py_export

awstats with www