首先连接数据库执行show variables like “%log%”; ，这里以命令行操作为例：
mysql> show variables like "%log%"; +------------------------------------------------+----------------------------------------------------------------------------+ | Variable_name | Value | +------------------------------------------------+----------------------------------------------------------------------------+ | activate_all_roles_on_login | OFF | | back_log | 80 | | binlog_cache_size | 32768 | | binlog_checksum | CRC32 | | binlog_direct_non_transactional_updates | OFF | | binlog_encryption | OFF | | binlog_error_action | ABORT_SERVER | | binlog_expire_logs_seconds | 2592000 | | binlog_format | ROW | | binlog_group_commit_sync_delay | 0 | | binlog_group_commit_sync_no_delay_count | 0 | | binlog_gtid_simple_recovery | ON | | binlog_max_flush_queue_time | 0 | | binlog_order_commits | ON | | binlog_rotate_encryption_master_key_at_startup | OFF | | binlog_row_event_max_size | 8192 | | binlog_row_image | FULL | | binlog_row_metadata | MINIMAL | | binlog_row_value_options | | | binlog_rows_query_log_events | OFF | | binlog_stmt_cache_size | 32768 | | binlog_transaction_compression | OFF | | binlog_transaction_compression_level_zstd | 3 | | binlog_transaction_dependency_history_size | 25000 | | binlog_transaction_dependency_tracking | COMMIT_ORDER | | expire_logs_days | 0 | | general_log | OFF | | general_log_file | WIN-OVS9ROJR6V9.log | | innodb_api_enable_binlog | OFF | | innodb_flush_log_at_timeout | 1 | | innodb_flush_log_at_trx_commit | 1 | | innodb_log_buffer_size | 1048576 | | innodb_log_checksums | ON | | innodb_log_compressed_pages | ON | | innodb_log_file_size | 50331648 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | .\ | | innodb_log_spin_cpu_abs_lwm | 80 | | innodb_log_spin_cpu_pct_hwm | 50 | | innodb_log_wait_for_flush_spin_hwm | 400 | | innodb_log_write_ahead_size | 8192 | | innodb_log_writer_threads | ON | | innodb_max_undo_log_size | 1073741824 | | innodb_online_alter_log_max_size | 134217728 | | innodb_print_ddl_logs | OFF | | innodb_redo_log_archive_dirs | | | innodb_redo_log_encrypt | OFF | | innodb_undo_log_encrypt | OFF | | innodb_undo_log_truncate | ON | | log_bin | ON | | log_bin_basename | C:\ProgramData\MySQL\MySQL Server 8.0\Data\WIN-OVS9ROJR6V9-bin | | log_bin_index | C:\ProgramData\MySQL\MySQL Server 8.0\Data\WIN-OVS9ROJR6V9-bin.index | | log_bin_trust_function_creators | OFF | | log_bin_use_v1_row_events | OFF | | log_error | .\WIN-OVS9ROJR6V9.err | | log_error_services | log_filter_internal; log_sink_internal | | log_error_suppression_list | | | log_error_verbosity | 2 | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_raw | OFF | | log_replica_updates | ON | | log_slave_updates | ON | | log_slow_admin_statements | OFF | | log_slow_extra | OFF | | log_slow_replica_statements | OFF | | log_slow_slave_statements | OFF | | log_statements_unsafe_for_binlog | ON | | log_throttle_queries_not_using_indexes | 0 | | log_timestamps | UTC | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 1073741824 | | max_binlog_stmt_cache_size | 18446744073709547520 | | max_relay_log_size | 0 | | relay_log | WIN-OVS9ROJR6V9-relay-bin | | relay_log_basename | C:\ProgramData\MySQL\MySQL Server 8.0\Data\WIN-OVS9ROJR6V9-relay-bin | | relay_log_index | C:\ProgramData\MySQL\MySQL Server 8.0\Data\WIN-OVS9ROJR6V9-relay-bin.index | | relay_log_info_file | relay-log.info | | relay_log_info_repository | TABLE | | relay_log_purge | ON | | relay_log_recovery | OFF | | relay_log_space_limit | 0 | | slow_query_log | ON | | slow_query_log_file | WIN-OVS9ROJR6V9-slow.log | | sql_log_bin | ON | | sql_log_off | OFF | | sync_binlog | 1 | | sync_relay_log | 10000 | | sync_relay_log_info | 10000 | | terminology_use_previous | NONE | +------------------------------------------------+----------------------------------------------------------------------------+ 90 rows in set, 1 warning (0.01 sec)
查询结果中显示了很与log有关的数据，其中：
- log_error ：错误日志信息，显示路径为相对路径.\WIN-OVS9ROJR6V9.err，可以使用前面推荐过的everything工具快速搜索到所在文件夹，一般在C:\ProgramData\MySQL\MySQL Server 8.0\Data下。
- general_log：操作日志文件是否开启，MySQL8.0默认OFF，可以执行开启命令：SET GLOBAL general_log = ‘ON’;
mysql> show variables like "general_log%"; +------------------+---------------------+ | Variable_name | Value | +------------------+---------------------+ | general_log | OFF | | general_log_file | WIN-OVS9ROJR6V9.log | +------------------+---------------------+ 2 rows in set, 1 warning (0.01 sec) mysql> SET GLOBAL general_log = 'ON'; Query OK, 0 rows affected (0.01 sec) mysql> show variables like "general_log%"; +------------------+---------------------+ | Variable_name | Value | +------------------+---------------------+ | general_log | ON | | general_log_file | WIN-OVS9ROJR6V9.log | +------------------+---------------------+ 2 rows in set, 1 warning (0.01 sec) mysql>
- general_log_file：操作日志文件名，同样可使用搜索工具查看所在文件夹，一般在C:\ProgramData\MySQL\MySQL Server 8.0\Data下。
Thanks for your blog, nice to read. Do not stop.
Thanks ^_^