filmov
tv
How to find location of MySQL error log file in Linux

Показать описание
How to find the location of mysql errorlog in linux
******************************************************
mysql -u root -p
mysql show variables like '%log_error%';
+----------------------------+----------------------------------------+
| Variable_name | Value |
+----------------------------+----------------------------------------+
| binlog_error_action | ABORT_SERVER |
| log_error_services | log_filter_internal; log_sink_internal |
| log_error_suppression_list | |
| log_error_verbosity | 2 |
+----------------------------+----------------------------------------+
5 rows in set (0.01 sec)
mysql
or
errorlog stores info like shutdown and startup and running info or any issues in troubleshooting these
******************************************************
mysql -u root -p
mysql show variables like '%log_error%';
+----------------------------+----------------------------------------+
| Variable_name | Value |
+----------------------------+----------------------------------------+
| binlog_error_action | ABORT_SERVER |
| log_error_services | log_filter_internal; log_sink_internal |
| log_error_suppression_list | |
| log_error_verbosity | 2 |
+----------------------------+----------------------------------------+
5 rows in set (0.01 sec)
mysql
or
errorlog stores info like shutdown and startup and running info or any issues in troubleshooting these