MySQL database running, access records and logs

The following articles mainly show you how to view MySQL database operations, access records, and logs. We all know that MySQL database operations, access records, and logs are widely used, the following is a detailed introduction to these contents. 1. Check whether MySQLshowvariableslikelog_bi is enabled in your log.

The following articles mainly show you how to view MySQL database operations, access records, and logs. We all know that MySQL database operations, access records, and logs are widely used, the following is a detailed introduction to these contents. 1. Check whether MySQLshowvariableslike 'Log _ bi is enabled in your log.

The following articles mainly show you how to view MySQL database operations, access records, and logs. We all know that MySQL database operations, access records, and logs are widely used, the following is a detailed introduction to these contents.

1. First confirm whether your log is enabled

MySQL>showvariableslike'log_bin';

2. If ON is enabled, the log file is in the data directory of the MySQL installation directory.

3. How to know the current log

MySQL>showmasterstatus;

4. Use MySQLbinlog to view binary log files

shell>MySQLbinlogmail-bin.000001

Or

shell>MySQLbinlogmail-bin.000001|tail

Use a similar command in Windows.

498) this. width = 498; 'onmousewheel = 'javascript: return big (this) 'style = "width: 500px; height: 358px "height =" 358 "alt =" MySQL Database "width =" 500 "srcwidth =" 500 "srcheight =" 358 "zoomrate =" 1 "src =" regular/">

The above content is an introduction to how to view MySQL database running logs, access records, and other logs. I hope you will gain some benefits.

Original article address: MySQL database running, access records and logs. Thank you for sharing them with me.