Perhaps this has something to do with it:
"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)."
http://www.mysql.com/doc/en/CREATE_TABLE.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
----- Original Message -----
From: "Martin Waite" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, 09 June, 2003 04:45
Subject: is it possible to get around 4 billion row limit
Hi,
I want to create a table with a lot (8 billion)
small fixed-length records.
I thought setting MAX_ROWS in the create table
would do this for me, but it looks like it quietly
ignores values over 4.2 billion.
Is this a hard-limit in MySQL ?
Does MySQL 4.0.x have the same limitation ?
(MySQL v3.23.51)
regards,
Martin
eg.
CREATE TABLE `txn_tag` (
txn_id int unsigned not null,
`tag_id` smallint unsigned NOT NULL default '0',
`value_id` int(11) NOT NULL default '0',
unique KEY (txn_id, tag_id, value_id),
KEY `tag_id` (`tag_id`,`value_id`),
KEY `value_id` (`value_id`,`tag_id`)
) max_rows=8000000000;
show table status like 'txn_tag'\G
*************************** 1. row ***************************
Name: txn_tag
Type: MyISAM
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 47244640255
Index_length: 1024
Data_free: 0
Auto_increment: NULL
Create_time: 2003-06-09 09:40:57
Update_time: 2003-06-09 09:40:57
Check_time: NULL
Create_options: max_rows=4294967295
Comment:
1 row in set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
