Hi Edward, Thanks for the info, but I tried setting the avg_row_length with no effect - I'm pretty sure you only need that for dynamic format tables (with varchars and text). My table is fixed format, and the table does claim to get around the 2/4GB limit.
My problem is the maximum number of rows, not the final table size. Max_data_length: 47244640255 Create_options: max_rows=4294967295 I'm guessing that you can't have more than 4294967295 rows in a MyISAM table (or maybe the SQL parser can't handle numbers > 2^32 as the value for max_rows). I think I'll resubmit the question as "What is the maximum number of rows MySQL can store in a table". thanks, Martin On Tue, 2003-06-10 at 11:54, Becoming Digital wrote: > Sorry, I meant to include this link, too. > http://www.mysql.com/doc/en/Table_size.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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
