List:General Discussion« Previous MessageNext Message »
From:Nicole Garris Date:April 15 2008 8:12pm
Subject:Does version 4 mysqlcheck close MyISAM tables left open?
View as plain text  
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


Thread
Does version 4 mysqlcheck close MyISAM tables left open?Nicole Garris15 Apr
  • Re: Does version 4 mysqlcheck close MyISAM tables left open?Eric Bergen21 Apr