Unable to find this in the manual ... Yesterday morning we rebooted the server by accident, which crashed and restarted MySQL 4.1. Late last night a scheduled job ran mysqlcheck and found 4 open tables. When I next ran mysqlcheck it found nothing wrong.
mysqlcheck command: CHECK TABLE $DBTABLES $TYPE1 $TYPE2" | mysql --host=$DBHOST -t -u$USER -p$PASSWORD $i where $TYPE1 and $TYPE2 are empty. warning message from the mysqlcheck command: expressionengine_dof_public.exp_stats check warning 2 clients are using or haven't closed the table properly