Enable slow query

query.sql

SET GLOBAL log_output=file;
SET GLOBAL slow_query_log=ON;
SET GLOBAL long_query_time=0;
SET GLOBAL log_slow_rate_limit=100;
SET GLOBAL log_slow_rate_type=query;
SET GLOBAL log_slow_verbosity=full;
SET GLOBAL log_slow_admin_statements = ON;
SET GLOBAL log_slow_slave_statements = ON;
SET GLOBAL slow_query_log_always_write_time=1;
SET GLOBAL slow_query_log_use_global_control=all;
SET GLOBAL innodb_monitor_enable=all;
SET GLOBAL userstat=1;

INSTALL PLUGIN QUERY_RESPONSE_TIME_AUDIT SONAME 'query_response_time.so';
INSTALL PLUGIN QUERY_RESPONSE_TIME SONAME 'query_response_time.so';
INSTALL PLUGIN QUERY_RESPONSE_TIME_READ SONAME 'query_response_time.so';
INSTALL PLUGIN QUERY_RESPONSE_TIME_WRITE SONAME 'query_response_time.so';

SET GLOBAL query_response_time_stats=ON;