MySQL provides many utilities for verifying and taking corrective actions in case of failures.
One such tool is mysqlcheck
Usage:
[[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 OKDatabaseName.LeaveDetails OK