How to enable mysql's diary

This article mainly explains "how to enable the diary of mysql". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to enable the diary of mysql".

1. First, make sure that your log is enabled.

Mysql > show variables like 'log_bin'

two。 If enabled, ON

The log file is in the data directory of mysql's installation directory.

3. How to know the current log

Mysql > show master status

4. Look at the binary log file using mysqlbinlog

Shell > mysqlbinlog mail-bin.000001

Shell > mysqlbinlog mail-bin.000001 | tail

Mysql has the following types of logs:

Error log:-log-err

Query log:-log

Slow log:-log-slow-queries

Update log:-log-update

Binary log:-log-bin

Under the installation directory of mysql, open my.ini and add the above parameters at the end

Just restart the mysql service after saving it.

# Enter a name for the binary log. Otherwise

A default name will be used.

# log-bin=

# Enter a name for the query log file.

Otherwise a default name will be used.

# log=

# Enter a name for the error log file.

Otherwise a default name will be used.

Log-error=

# Enter a name for the update log file.

Otherwise a default name will be used.

# log-update=

Thank you for your reading, the above is the content of "how to enable the diary of mysql", after the study of this article, I believe you have a deeper understanding of how to enable the diary of mysql, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!