I'm running MySQL 4.1 under Linux. I need to have a MyISAM table with
more than 4G rows of data.
I've read the manual regarding the MAX_ROWS option on tables. This
table has a fixed row length, with 17 bytes per row.
MySQL simply won't set the ROW_LENGTH greater than 4G. When I use an
ALTER TABLE to set it higher, it acts as though it worked fine, but a SHOW
TABLE STATUS indicates that it is still limited to 4294967295.
I've been searching high and low on this, and the only things I'm
finding (for example in the '1.2.4. How Big MySQL Tables Can Be' section)
keep talking about file size limits of the OS. This isn't the issue. I
have a table that is at the 4G (rows) limit, and it's physical size on
disk is already 74GB. It appears that the addressing is being limited to
4 bytes.
Any ideas on what's imposing this limit? Thanks in advance.
Tom