Bug #1551 File Size limit warnings on FreeBSD?
Submitted: 14 Oct 2003 21:52 Modified: 21 Oct 2003 13:22
Reporter: Jason de Cordoba Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.0.15a MAX BINARY OS:FreeBSD (FreeBSD 4.8)
Assigned to: CPU Architecture:Any

[14 Oct 2003 21:52] Jason de Cordoba
I am getting a warning that the datafile is almost full when my OS has no Max File size limit?

myisamchk: warning: Datafile is almost full, 3986538616 of 4294967294 used

# ulimit -a
cpu time               (seconds, -t)  unlimited
file size           (512-blocks, -f)  unlimited
data seg size           (kbytes, -d)  524288
stack size              (kbytes, -s)  65536
core file size      (512-blocks, -c)  unlimited
max memory size         (kbytes, -m)  unlimited
locked memory           (kbytes, -l)  unlimited
max user processes              (-u)  7390
open files                      (-n)  32768
sbsize                   (bytes, -b)  unlimited

MySQL Version 3.22 had a 4 GB (4 gigabyte) limit on table size. With the MyISAM table type in MySQL Version 3.23, the maximum table size was pushed up to 8 million terabytes (2 ^ 63 bytes). 

How to repeat:
Create a Table of 3.2 GB on FreeBSD...

check the table with myisamchk

get an warning 

Suggested fix:
Update Error msgs, and other possible errors... 
the docs on http://www.mysql.com/doc/en/Table_size.html

Kindest Regards,
Jason de Cordoba
[15 Oct 2003 5:20] Alexander Keremidarski
What error do you get?

Make sure that table is created with big enough MAX_ROWS= option. 
Maximum file ize depends on Datafile pointer which can be 2, 3 or 4 bytes so limit can vary.
[17 Oct 2003 4:51] Jason de Cordoba
Hi, I hope this was the information you requested.

Thank You,

helga# myisamchk -dvv /usr/local/mysql/data/news/cache.MYI

MyISAM file:         /usr/local/mysql/data/news/cache.MYI
Record format:       Packed
Character set:       german1 (5)
File-version:        1
Creation time:       2002-08-22  9:46:14
Recover time:        2003-10-15 18:43:08
Status:              open,changed
Data records:               739384  Deleted blocks:                 0
Datafile parts:             739384  Deleted data:                   0
Datafile pointer (bytes):        4  Keyfile pointer (bytes):        3
Datafile length:        4011980820  Keyfile length:           5240832
Max datafile length:    4294967294  Max keyfile length:   17179868159
Recordlength:                   22

table description:
Key Start Len Index   Type                     Rec/key         Root  Blocksize
1   2     3   unique  uint24                         0      5237760       1024

Field Start Length Nullpos Nullbit Type
1     1     1                                                         
2     2     3                      no zeros                           
3     5     11     1       1       blob                               
4     16    4                                                         
5     20    2                      no zeros                           
6     22    1                      no zeros
[21 Oct 2003 12:03] Dean Ellis
What are your settings in the table definition for AVG_ROW_LENGTH and MAX_ROWS?

As described at http://www.mysql.com/doc/en/Table_size.html and http://www.mysql.com/doc/en/CREATE_TABLE.html you will need to set AVG_ROW_LENGTH for very large tables with variable-length rows.

You can view these with "SHOW CREATE TABLE cache".  If you have not provided values, you can set them with an ALTER TABLE statement.
[21 Oct 2003 13:22] Sergei Golubchik
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

See http://www.mysql.com/doc/en/Full_table.html
[11 Sep 2012 9:47] Bugs System
<a href=http://www.jordanspizikenewyorkknicks.com>www.jordanspizikenewyorkknicks.com</a>
 Even when nurses work in similar positions, BSNs earn more money than their non-degreed counterparts. A more compelling detail however, is that the degree opens the door to higher paying career opportunities in nearly every field. A nurse working in medical management can earn above $70,000, nearly $20,000 more than the mean salary for registered nurses.
 <a href=http://www.jordanspizikenewyorkknicks.com/315371-805-new-color-air-jordan-spizike-knicks-o...><b>Jordan Spizike Knicks For Sale</b></a>
 Air Jordan XI - Though the original model also heralded the comeback of Michael Jordan in 1995, the model by itself in the original version did not do that well. However, the story was different with the retro version, which was released in 2000-2001 and became the most popular and fastest selling Retro Jordans of all.
 <a href=http://www.jordanspizikenewyorkknicks.com><b>Jordan Spizike For Sale</b></a>
 Cheap Prada shoes online for sale for babies protect your baby's little feet from the environmental changes. Gucci shoes have offered cheap, casual and fashion shoes for both boys and girls. Nike Air MAx 95 blows each other out of the running shoes water in my opinion. They spoil you for any other exercise footwear.
 <a href=http://www.jordanspizikenewyorkknicks.com><b>Jordan Spizike</b></a>