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]
