Recommended Today

[MySQL] enable slow query log and SQL log without index

1. Enable slow query log mode: You can change the database configuration file, such as the location of the configuration file under Ubuntu /etc/mysql/mysql.conf.d/mysqld.cnf Add these three items #Log slow queriesslow_query_log = ONslow_query_log_file = /var/log/mysql/slow.loglong_query_time = 0.1   You can also configure other items under MySQL terminal: set global slow_query_log =’on’; set globle long_query_time=0.1; set globle slow_query_log_file=‘ /var/log/mysql/slow.log’;   Whether […]