MySQL Forums
Forum List  »  General

Re: How to Find the Least Accessed Tables?
Posted by: Authorized User
Date: March 10, 2022 09:48AM

In WB, go to Server -> Performance Reports -> Database Schema Statistics -> Schema Table Statistics.

It shows you a detailed breakdown of IO reads/writes for all tables. By exporting that to Excel. it's easy to see which tables are getting touched the most and which are barely getting touched at all. However, I have 500 databases to manage and I want to figure out a way to script the relevant queries. If I have to, I'll just use WireShark to capture whatever WB is doing, but I thought it might be easier to ask.

Also, it shows high cost SQL statements and a variety of other details related to queries that the database is receiving from everywhere, not just from WB itself.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to Find the Least Accessed Tables?
March 10, 2022 09:48AM


Sorry, only registered users may post in this forum.

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.