If I run the script: -snip- datadir="/var/lib/mysql/telaurus/" find $datadir -name "*.MYI" -print | xargs myisamchk -r --silent --fast -snip-
With the -r option on a live running db while connections are being made, could there be any consequences? Our production db is a bear to bring down because we need to stop all the different systems that us it first and this interups our customer's services. Also we'll be upgrading shortly (I hope) to ver 4.x, does the new version have any better way's of accomplishing checks/repairs on db that is up 24/7/365? Thanks, Jeff McKeon > -----Original Message----- > From: gerald_clark [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 24, 2003 9:32 AM > To: Jeff McKeon > Cc: MySQL LIST > Subject: Re: Myisachk > > > Shutdown mysqld before running myisamcheck, > or use check/repair table. > > > Jeff McKeon wrote: > > >Hello, > > > >When I run a script to issue myismchk against the tables in my > >database, I get the following.. > > > >[EMAIL PROTECTED] scripts]# ./check_mysql_tables > >myisamchk: MyISAM file /var/lib/mysql/telaurus/Admin.MYI > >myisamchk: warning: 1 clients is using or hasn't closed the table > >properly MyISAM-table '/var/lib/mysql/telaurus/Admin.MYI' is > usable but > >should be fixed > >myisamchk: MyISAM file /var/lib/mysql/telaurus/Customer.MYI > >myisamchk: warning: 1 clients is using or hasn't closed the table > >properly > >MyISAM-table '/var/lib/mysql/telaurus/Customer.MYI' is > usable but should > >be fixed > > > >This db is ver 3.23 and replicates from another db. > > > >What causes the tables to be "1 clients is using or hasn't > closed the > >table properly" > > > >I do have PHP web sites that pull data from this db, am I > perhaps not > >closing the tables after I access them from the PHP with select > >queries? If that's the case, why are tables I never touch with the > >website getting this error, does replication have something > to do with > >it? > > > >How can I tell what clients are currently using the tables? > > > >Thanks, > > > >Jeff McKeon > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
