List:General Discussion« Previous MessageNext Message »
From:Steve Lihn Date:May 19 1999 2:22pm
Subject:Re: Large Tables
View as plain text  
Is it possible that you hit the 2GB file system limit of some sort. But that is on UNIX
though?!
Steve

Brandon Shuey wrote:

> Is there a limit to the size of a table?  I currently have a 1.8Gig, 9.8Million
> records, table and it seems to have trouble uploading more stats.  The entire database is
> 5.4Gig large.I"m runningmysqld  Ver 3.22.21-debug for Win95/Win98 on i586 There are my
> options:back_log              current value: 5
> connect_timeout       current value: 5
> delayed_insert_timeout  current value: 300
> delayed_insert_limit  current value: 100
> flush_time            current value: 1800
> join_buffer           current value: 131072
> key_buffer            current value: 8388572
> long_query_time       current value: 10
> max_allowed_packet    current value: 1048576
> max_connections       current value: 100
> max_connect_errors    current value: 10
> max_delayed_insert_threads  current value: 20
> delayed_queue_size    current value: 1000
> max_join_size         current value: 4294967295
> max_sort_length       current value: 1024
> net_buffer_length     current value: 16384
> record_buffer         current value: 131072
> sort_buffer           current value: 2097116
> table_cache           current value: 64
> tmp_table_size        current value: 1048576
> thread_stack          current value: 65536
> wait_timeout          current value: 28800Brandon Shuey
> WebCentric Inc.
> (316) 612-8030
> brandon@stripped

Attachment: [text/html]
Attachment: [application/x-unknown-content-type]
Attachment: [application/x-unknown-content-type]
Attachment: [application/x-unknown-content-type]
Thread
Large Tables(Brandon Shuey)19 May
  • Re: Large TablesSteve Lihn19 May
  • Re: Large TablesPaul DuBois19 May