MySQL Log

SHOW VARIABLES like '%log%';

SELECT @@log_warnings;
SET GLOBAL log_warnings=2;

log_warnings        = 2
log_error_verbosity = 3 

SET GLOBAL log_error_verbosity=2; -- set it
SELECT @@log_error_verbosity=2;

log_error_verbosity 
1 ERROR
2 ERROR, WARNING
3 ERROR, WARNING, INFORMATION

Comments are closed.