On Wed, 25 Jul 2001, David Miller wrote:
I know it's bad form to followup ones own message, but enough digging
turned up an answer that someone else may find useful.
> Hi All:)
>
> I'm running mysql-3.23.30-gamma on FreeBSD 4.3-stable and running into a
> problem with max file sizes.
>
> I've got a table, names, which is taking 4294967288 bytes. I notice this
> is 8 bytes less than 2^32, so I assume there's a 32 bit pointer issue
> within mysql somewhere.
>
> large_files_support is ON, but trying to write more records gives me this
> error:
>
> Err 1114 (The table 'names' is full) writing record
>
> Please, someone, tell me that mysql isn't limited to 4 GB tables:) How do
> I create much larger tables?
MySQL isn't limited to 4 GB, although individual files may be. "show
table status" will show what their limits are.
In manual_Reference.html one finds:
When you use a MyISAM table, MySQL uses the product of
max_rows * avg_row_length to decide how big the resulting
table will be. If you don't specify any of the above options, the
maximum size for a table will be 4G (or 2G if your operating
systems only supports 2G tables). The reason for this is just to
keep down the pointer sizes to make the index smaller and faster
if you don't really need big files.
If you want larger file support, create the table with some table
options. For example:
create table test (some_field INT UNSIGNED NOT NULL,
some_other_field varchar(64) NOT NULL, ttl int,
UNIQUE KEY (some_other_field))
AVG_ROW_LENGTH = 64 MAX_ROWS = 256000000;
Hope this helps,
--- David
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
