To ask, how to check the mysql operation records in the Linux system-CodePudding

, for example, look at the table to increase or modify which fields,,,, those table has added a new record, the record of this manual or server operating,

CodePudding user response:

Need to open the general_log function, it will take these things recorded in log
But do not open, because the data quantity is very large

CodePudding user response:

reference 1/f, CKC response:

need to open the general_log function, will take these things recorded in log
But do not open, because the data volume is very big

I can look at the mysql directory mysqlbinlog,, don't know the right, but I see mysqlbinlog seems a directory, there are a lot of files,,, but I only have one mysqlbinlog file,

CodePudding user response:

Not
Open in a configuration file, as the command can also open the
The Internet search mysql general_log

CodePudding user response:

refer to the second floor weixin_39823377 response:

Quote: refer to 1st floor CKC response:

Need to open the general_log function, it will take these things recorded in log
But do not open, because the data volume is very big

I can look at the mysql directory mysqlbinlog,, don't know the right, but I see mysqlbinlog seems a directory, there are a lot of documents,,, but I only have one mysqlbinlog file,

Binlog there are operation records, but can only find the timing of the operation and the operating (specific operating statements or data, related to the format of the record set)
General_log can also check the operation of the statement and time, the host information
Both are open to check in advance, if there is no open is not easy, is off by default, the binlog generally consider open, general_log usually don't recommend normally open (performance impact)

CodePudding user response:

Query whether general_log open and its output position, can perform the following query in MySQL
Select @ @ general_log @ @ log_output, @ @ log_error;
See if binlog open and output position, can perform the following query in MySQL
Select @ @ log_bin @ @ log_bin_basename;