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

This article mainly introduces the docker mysql container how to open the slow query log, the article is very detailed, has a certain reference value, interested friends must read it!

1. Log in to the container and log into the account

Docker View running Container

Docker ps

Enter the container:

Docker exec-it dc8880c13fef / bin/bash

Enter the user name and password to log in to mysql

Mysql-u root-p

Then enter the password to log in.

2. View slow log related information

The default slow log is turned off.

Show variables like 'slow%'; (or use, see other bloggers say there will be a version difference, then use the double percent sign: show variables like'% slow%';)

Turn on the slow log switch

Set global slow_query_log = ON

Open successfully.

You can modify the threshold to determine whether it is a slow sql, and when the sql execution exceeds the threshold, it will be recorded in the log file of the slow log.

After the modification, test the select query.

We can see that the sql is recorded in the slow log here.

The above is all the contents of the article "how to open the slow query log in docker mysql container". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.