MySQL Forums
Forum List  »  Newbie

MySQL 5.6 not logging excess of user limits
Posted by: Konstantin Pavlov
Date: May 26, 2015 05:32AM

Hello,

After we moved from MySQL 5.1 to 5.6 it stopped writing excess of user limits to warning log. Is there a way to return old behavior?

On both servers we create user test with max_queries_per_hour 10, then we run 10+ queries from that user.
1)
# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for debian-linux-gnu (x86_64) using readline 6.1
# cat mysql.log:
150526 14:10:26 [Warning] User 'test' has exceeded the 'max_questions' resource (current value: 10)
2)
# mysql -V
mysql Ver 14.14 Distrib 5.6.24, for Linux (x86_64) using EditLine wrapper
When user excess queries limit user get error, but mysql.log remains empty.

In my.cnf we have:
...
log-error = /var/log/mysql/mysql.log
log-warnings = 2
...

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.6 not logging excess of user limits
May 26, 2015 05:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.