CODE EXAMPLE FOR SQL

mysql check if table need repair

#check the whole database for tables that need repair
mysqlcheck -c mydatabase -u root -p

#check just one table to see if it needs repair
mysqlcheck -c mydatabase mytable -u root -p

#NOTE:careful running this on production its costly command