Shulou(Shulou.com)06/01 Report--

By default, the value of slow_query_log is OFF, which means that slow log is disabled. You can enable it by setting the value of slow_query_log.

Open mysql and first check whether it is enabled. For example, the status below is disabled.

Show variables like'% slow_query_log%'

open

Set global slow_query_log=1

After a query, as shown in the figure below, the status of on indicates that it is open, and show_query_log_file is the location of the file where slow statements are recorded.

Show variables like'% slow_query_log%'

The above are the details of how to open the mysql slow query log configuration, please pay attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.