List:General Discussion« Previous MessageNext Message »
From:Brandon Shuey Date:May 19 1999 2:10pm
Subject:Large Tables
View as plain text  
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 running  mysqld  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: 28800
Brandon Shuey
WebCentric Inc.
(316) 612-8030
brandon@stripped


Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
Thread
Large Tables(Brandon Shuey)19 May
  • Re: Large TablesSteve Lihn19 May
  • Re: Large TablesPaul DuBois19 May