MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Martin MOKREJŠ Date:January 25 2002 8:06pm
Subject:Re: mysql warnings when write locking compressed table
View as plain text  
On Fri, 25 Jan 2002, Sinisa Milivojevic wrote:

Hi,
  sorry, I didn't get it. As far as I know there's no way yet how to
uncompress table my using SQL command. I have to uncompress using
`myisamchk --unpack *.MYI`, right?


> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > Hi,
> >   when I'm trying to lock multiple tables and some of the are Compressed,
> > mysql warn's me only about the first-one being Compressed. It either
> > reports the first Compressed table only from the list, or it checks
> > only the first-one in the list of tables to be locked:
> > 
> > mysql> use Escherichia_coli_O157_H7_EDL933
> > Database changed
> > mysql> lock table blast_data write; write, blimps_data write, cogs_data
> write, coils_data write, contig_data write, funcat_data write, intragenome_data write,
> known3d_data write, nonglob_data write, orf_data write, pfam_data write, prd_data write,
> pros_data write, prot_data write, scop1_data write, scop2_data write, seg_data write,
> tmhmm_data write;
> > ERROR 1036: Table 'blast_data' is read only
> > mysql> 
> > 
> >   `myisamchk -f -d ' reports on those tables their status, and most of them were
> Compressed.
> > I don't think it make's sense to paste the output here.
> > 
> >   I don't know if it's really `ERROR', because I'm locking the tables
> > to FLUSH TABLES and then in the backgroung run `myisamchk --unpack *.MYI'.
> > ;)[B
> > 
> > Linux 2.4.17,
> > /usr/local/mysql/bin/mysqld  Ver 3.23.42 for pc-linux-gnu on i686
> > -- 
> > Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> > MIPS / Institute for Bioinformatics <http://mips.gsf.de>
> > GSF - National Research Center for Environment and Health
> > Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> > tel.: +49-89-3187 3616 , fax: +49-89-3187 3585
> > 
> 
> Please do not run myisamchk while the server is running.
> 
> Use CHECK TABLE to check tables ... 
> 
> -- 
> Regards,
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@stripped>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
> /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
>        <___/   www.mysql.com
> 

-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics <http://mips.gsf.de>
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3616 , fax: +49-89-3187 3585

Thread
mysql warnings when write locking compressed tableMartin MOKREJŠ25 Jan
  • Re: mysql warnings when write locking compressed tableSinisa Milivojevic25 Jan
    • Re: mysql warnings when write locking compressed tableMartin MOKREJŠ25 Jan
      • Re: mysql warnings when write locking compressed tableSinisa Milivojevic25 Jan