Search code examples
mysqldatabasedatabase-performancedatabase-metadata

MySQL metadata (usage and performance statistics)


I am working on a web application that is based on a MySQL database. I need to collect and analyse usage and performance statistics. The statistics will be aimed at non-technical personnel.

How can I implement this feature? You should treat my question as a programming question but in case you know of a tool or extension that would be suitable please mention it.


Solution

  • The official MySQL client, MySQL Workbench includes the feature to visualize Performance Schema since version 6.1. It's in Performance section in the software.

    Read more at: http://mysqlworkbench.org/