In production environment nothing is being logged in the error log for mysql
Difficult to troubleshooting mysql issues without warning message a error log
my.cnf:
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Gateway 11.1
The error log location is defined in the mysql variables
The error log location is defined in the mysql variables
Example:
mysql> SHOW VARIABLES LIKE '%error%';
+-------------------------------+----------------------------------------+
| Variable_name | Value |
+-------------------------------+----------------------------------------+
| binlog_error_action | ABORT_SERVER |
| error_count | 0 |
| log_error | /var/log/mysql/error.log |
| log_error_services | log_filter_internal; log_sink_internal |
| log_error_suppression_list | |
| log_error_verbosity | 2 |
| max_connect_errors | 2000000 |
| max_error_count | 1024 |
| performance_schema_error_size | 5309 |
| replica_skip_errors | 126,1053,1105,1129,1158,1159,1160,1161 |
| slave_skip_errors | 126,1053,1105,1129,1158,1159,1160,1161 |
+-------------------------------+----------------------------------------+
11 rows in set (0.01 sec)
The level is determined by log_error_verbosity
log_error_verbosity Value |
Permitted Message Priorities |
1 |
ERROR |
2 |
ERROR, WARNING |
3 |
ERROR, WARNING, INFORMATION |