List:General Discussion« Previous MessageNext Message »
From:Van Date:June 29 1999 12:14am
Subject:Re: Mysql bails out at 24 million records
View as plain text  
vdrifter@stripped wrote:
> 
> >Description:
>         Hi there. We are using mysql to log tcp/ip connections on our LAN.
>         It inserts 500,000+ records per day and over 1 million queries per day.
>         Works great, but from day 1 the server dies at approx 22 million entries.
>         The error we get is non-unique key is being inserted. The table has 6 keys
>         and none of them are set as unique. After running isamchk the error we get
> is
>         "error#27 from table handler". The fix has been to delete some of the
> records
>         and it works fine (up until it reaches that 22 million mark). There is
> plenty
>         of hard drive space left (50% used). This month we've upgraded to mysql 2.22
>         from 2.20 hoping that it would fix the problem but it hasn't ... Regardless
>         Mysql is a great sql server ...
> 
> >How-To-Repeat:
>         as described above ...
> 
> >Fix:
>         as described above. Remove a couple million entries and start up the
> program.
>         Works fine until it his that 22 million or so mark. It is worth mentioning
> that
>         this problem occurs within your own mysql program. ie: I try to manually
> insert a
>         record using an insert query and it gives the error#27 output.
> 
> 
> >Submitter-Id:  <submitter ID>
> >Originator:    John Cuzzola
> >Organization:  On-Call Internet
> 
> >MySQL support: [none | licence | email support | extended email support ]
> >Synopsis:      dies at 24 million records and 6 keys
> >Severity:      non-critical
> >Priority:      low
> >Category:      mysql
> >Class:         sw-bug
> >Release:       mysql-3.22.22 (Source distribution)
> >Server: mysqladmin  Ver 7.11 Distrib 3.22.22, for pc-linux-gnu on i686
> TCX Datakonsult AB, by Monty
> 
> Server version          3.22.22
> Protocol version        10
> Connection              Localhost via UNIX socket
> UNIX socket             /tmp/mysql.sock
> Uptime:                 11 min 28 sec
> 
> Threads: 3  Questions: 601279  Slow queries: 0  Opens: 12  Flush tables: 1  Open
> tables: 8
> >Environment:
> 
> System: Linux ip-acc.ocis.net 2.0.36 #2 Wed Nov 25 17:49:18 PST 1998 i686 unknown
> Architecture: i686
> 
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
> gcc version 2.7.2.3
> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
> Configure command: ./configure
> Perl: This is perl, version 5.004_04 built for i386-linux
> 
VDrifter,
do an du /usr/local/var/
You may have reached the 2 Gig Filesize limit on 32-bit Linux.
Regards,
Van
-- 
=========================================================================
Linux rocks!!!   www.dedserius.com
=========================================================================
Thread
Mysql bails out at 24 million recordsvdrifter28 Jun
  • Re: Mysql bails out at 24 million recordsVan29 Jun