MySQL provides many utilities for verifying and taking corrective actions in case of failures.
One such tool is mysqlcheck
[[email protected]]# mysqlcheck -h -u -p --analyze --databases ;
The above command with option
--analyze will analyze and share the details.
Output: (Considering the table names to be Employee, LeaveDetails) DatabaseName.Employee OK DatabaseName.LeaveDetails OK