I'm trying to automate a way to troubleshoot basic connectivity to mysql databases. Does anyone have a recommended way of doing this that has low impact to the performance of mysql?
I think the existence of mysqld is a good indicator that things are ok. How do I tell the databases are up?
I've run across this query: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'DBName';
But that doesn't necessarily mean the database is available.
I'm teaching myself MySQL as fast as I can but need to jump ahead a few chapters.