Re: data deleted in MySQL but table file (.MYD) remains same size

2004-11-09 Thread Craig Cummings
That did the trick. Thanks for the advice. -Craig On Tue, 9 Nov 2004, Paul DuBois wrote: > At 13:06 -0600 11/9/04, gerald_clark wrote: > >Craig Cummings wrote: > > > >>Hi there, > >> > >>I have a table with three columns, two varchar(12) identifier

data deleted in MySQL but table file (.MYD) remains same size

2004-11-09 Thread Craig Cummings
t 2.8 GB). SHOW TABLE STATUS (in mysql) and df (at the shell prompt) both report the same value. How can I get the table size to correspond to the small amount of data that actually remains in the table? Thanks for your assistance. Best regards, Craig Cummings, Ph.D. Research Associate Relman Lab

UPDATE TABLE with > 32 MB string corrupts ISAM

2003-11-06 Thread Craig Cummings
1 root system17 Mar 13 2001 /usr/lib/libc.a -> ../ccs/lib/libc.a Configure command: ./configure '--prefix=/tools/local/mysql-4.0.10' '--localstatedir=/usr3/data3/mysql' 'CC=gcc' 'CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti' 'C

Inserting long text gives Error 139

2002-08-18 Thread Craig Cummings
cluded in the calculation of the packet size? Or is there some other parameter (limiting row size, for example) that is being violated? Thank you for your help. Regards, Craig Cummings, Ph.D. Relman Laboratory Stanford University School of Medicine Department of Microbiology and Immunology e

Re: ERROR 2002 question

2001-03-22 Thread Craig Cummings
readable, and searchable > for > the client to find and open the socket. > > Craig Cummings wrote: > > > > Hi there, > > > > I recently upgraded my Linux kernel to 2.4.2 and my perl DBI/DBD > > and now MySQL is behaving strangely. If I'm logged into

ERROR 2002 question

2001-03-21 Thread Craig Cummings
to access MySQL using a user login. I checked the documentation on this but it seems stranger than the described Error 2002 situations. The error log for the localhost does not show any record of the failed connections. Any idea what's going on here? Thanks, in advance, for yo