Ad Widget

Collapse

Monitor size of a bank in mysql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • brenoacp
    Junior Member
    • Jun 2016
    • 26

    #1

    Monitor size of a bank in mysql

    Hello everyone!
    It is possible to monitor the size of a specific bank mysql?
    For example, we would like to monitor database growth "zabbix".
    Currently we see the code below.

    SELECT table_schema "Database Name", SUM(data_length+index_length)/1024/1024
    "Database Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;

    Can you help me?

    Best regards,
    Breno Padovan
  • LenR
    Senior Member
    • Sep 2009
    • 1005

    #2
    look at the database monitor item type

    Comment

    Working...