0

Our MySQL configs are as below:

@@version - 5.7.23
@@log_warnings - 2
@@log_error_verbosity - 3

However, the notes getting logged are not verbose enough and like below

2024-09-26T08:56:39.519313Z 6624396 [Note] 
2024-09-26T08:56:39.519423Z 6622841 [Note] 
2024-09-26T08:56:39.519471Z 6624696 [Note] 
2024-09-26T08:56:39.519532Z 6623360 [Note] 
2024-09-26T08:56:39.552200Z 6624397 [Note]

The mysql user has required write permissions on the log file and the system has enough space available.

Improve this question
4
  • @@log_error_verbosity effects on the logginig events types and not on their format/verbosity.
    – Akina
    Commented Oct 8 at 8:52
  • Some settings (perhaps these) do not take effect until mysqld is restarted.
    – Rick James
    Commented Oct 8 at 15:51
  • @Akina so what configuration is needed for getting more verbose messages?
    – NKP
    Commented Oct 9 at 7:19
  • @RickJames mysqld was restarted after updating these configs
    – NKP
    Commented Oct 9 at 7:20

1 Answer 1

Reset to default
0

What is the output of

show global variables like '%verbosity%';

3 means -

3 ERROR, WARNING, INFORMATION

It seems that you are getting Note, which is correct in error logs.

Improve this answer
1
  • Its 3 like I've mentioned in my question. But still the log only has entries like [Note] with no further information
    – NKP
    Commented Oct 8 at 6:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.