Check (health) status of MySQL schema table I have a large MySQL database which has around 1,500 tables and the file of the database is around 30GB. I would like to suggest me some ways to monitor the health of my database in overall and how i can check the health status of mysql schema table. 

How can I monitor the health of my database in overall? I use mysql workbence, but since i am new to this, i don't know what to check!
To monitor your database's health in overall you could simply use:

mysqlcheck --all-databases --auto-repair


or on weekly basis (if you prefer, due to optimize option resource usage)

mysqlcheck --all-databases --auto-repair --optimize 


To verify tables:

mysql
\u mydb
CHECK TABLE mytable FAST QUICK;


The first command will check the integrity for all tables of all databases, if there's any corruption your table will be repaired automatically.
And the second will additionally optimize the table on disk.

Check the explanation about it here:
What is the difference between optimize table and analyze table in mysql