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?). Cheers, Rhys
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
