Hi, Rhys.Campbell! On Apr 26, [email protected] wrote: > Hello All, > > I've been using the userstats plugin do debug an application issue and > I think there's a bug in the collection of statistics, or at least a > case of bad wording... > > https://mariadb.com/kb/en/mariadb/user-statistics/ > > DENIED_CONNECTIONS - The number of connections denied to this user. > ACCESS_DENIED - The number of times this user's connections issued commands > that were denied. > > A application user was displaying very high "DENIED_CONNECTION" > values. This sent us in the direction a bad password was being > supplied. Long story short it actually turns out that a series of > ALTER TABLE statements were failing, because the application does not > have permission to do so. > > During one our tests DENIED_CONNECTION was 5397 and ACCESS_DENIED was > 0. We can see the ALTER TABLE statement failing and DENIED_CONNECTION > being incremented quickly. According to the documentation shouldn't > this ACCESS_DENIED (which I think might be better named > COMMAND_DENIED?).
It's a bug. Could you please report it at jira.mariadb.org? Regards, Sergei Chief Architect MariaDB and [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
