Not the answer you need?
Register and ask your own question!

generate a per-datebase usage report

tollandtolland EntrantInactive User Role Beginner
For shared hosting, or systems where there are many co-installed databases I would like to identify those which have high resource requirements, and any of those that are not in use.

Presumably I could either sample the data, using something like pt-collect, or I could configure the slow.log to log to disk some query event data.

Is there a preferred solution for this task?

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.