MySQL records all executed SQL statements

Time:2021-9-26

method

  1. Check whether the log is openshow variables where Variable_name="general_log";
  2. If the result isOFF, then runset global general_log=on;
  3. View log locationshow variables where Variable_name="general_log_file";

matters needing attention

  1. All SQL will be recorded. It is recommended to open it only during debugging and close it after debuggingset global general_log=off;

This work adoptsCC agreement, reprint must indicate the author and the link to this article

Recommended Today

Supervisor

Supervisor [note] Supervisor – H view supervisor command help Supervisorctl – H view supervisorctl command help Supervisorctl help view the action command of supervisorctl Supervisorctl help any action to view the use of this action 1. Introduction Supervisor is a process control system. Generally speaking, it can monitor your process. If the process exits abnormally, […]