mysql 显示sql执行时间设置

-- 启用慢查询日志
SET GLOBAL slow_query_log = 'ON';

-- 设置慢查询时间阈值（单位：秒）
SET GLOBAL long_query_time = 2;

-- 查看慢查询日志配置
SHOW VARIABLES LIKE 'slow_query_log%';
SHOW VARIABLES LIKE 'long_query_time';

-- 启用Performance Schema
UPDATE performance_schema.setup_consumers SET ENABLED = 'YES' WHERE NAME = 'events_statements_summary_by_digest';
UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME = 'statement/sql/select';

-- 使用TIMESTAMPDIFF函数获取查询执行时间（单位：毫秒）
SELECT TIMESTAMPDIFF(MILLISECOND, @start_time, @end_time) AS execution_time FROM (SELECT @start_time := NOW(), @end_time := (SELECT SLEEP(1))) AS t;