> 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?
Hmmmm I seem to have answered my own question...
I ran the script with the -r option and now my db won't replicate...
What have I boogered up now?
--snip--
mysql> show slave status \G;
*************************** 1. row ***************************
Master_Host: 10.32.1.12
Master_User: test
Master_Port: 3306
Connect_retry: 60
Log_File:
Pos: 4
Slave_Running: Yes
Replicate_do_db:
Replicate_ignore_db:
Last_errno: 1030
Last_error: error 'Got error 127 from table handler' on query
'UPDATE RemoteStation SET PendingIn='0' WHERE ID=980070408'
Skip_counter: 0
1 row in set (0.00 sec)
ERROR:
No query specified
--snip--
Jeff McKeon
> -----Original Message-----
> From: Jeff McKeon
> Sent: Thursday, July 24, 2003 10:02 AM
> To: gerald_clark
> Cc: MySQL LIST
> Subject: RE: Myisachk
>
>
> 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/mysql?> [EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
