List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:September 24 1999 3:09pm
Subject:Re: ISD file size
View as plain text  
>>>>> "TS" == Thimble Smith <tim@stripped> writes:

TS> At 23:38, 19990923, Cliff Addy wrote:
>> No joy, just "ERROR: parse error near 'optimize table history' at line 1"

TS> Sounds like you're using an older version of MySQL.  You can do something
TS> like this:

mysql> LOCK TABLES history READ;
mysql> FLUSH TABLES;

TS> Now, keep that client open so that you don't lose the lock, and in another
TS> shell (as root), do:

This only works if you have skip-locking turned on in mysqld (which is
apparently required on toy operating systems).  Otherwise, isamchk
waits for a lock to be released.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
ISD file sizeCliff Addy22 Sep
Re: ISD file sizePaul DuBois22 Sep
  • Re: ISD file sizeCliff Addy24 Sep
    • Re: ISD file sizePaul DuBois24 Sep
      • Re: ISD file sizeCliff Addy24 Sep
        • Re: ISD file sizeThimble Smith24 Sep
          • Re: ISD file sizeVivek Khera24 Sep
        • Re: ISD file sizeBob Kline24 Sep
    • Re: ISD file sizeMartin Ramsch24 Sep
    • Re: ISD file sizeBob Kline24 Sep