Comments on: Identify Active Databases and Users in MySQL https://www.percona.com/blog/identify-active-databases-and-users-in-mysql/ Fri, 10 Feb 2023 12:34:52 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Federico Razzoli https://www.percona.com/blog/identify-active-databases-and-users-in-mysql/#comment-10973902 Thu, 26 Jan 2023 15:29:22 +0000 https://www.percona.com/blog/?p=84261#comment-10973902 Very nice and useful summary. But it’s important to note some things:

  • What is inactive on the master might be used on the replicas, or just one replica.
  • An inactive user might still be used as a DEFINER for stored procedures, triggers, or events.
  • User Statistics (and probably tables in the sys schema) won’t track the usage of special storage engines that don’t store local rows, such as SPIDER or BLACKHOLE.
]]>