Re: 16GB index file limit

[Andon Zlatev]

Hi,

The show create is:

parameters_back | CREATE TABLE `parameters_back` (
`p_id` bigint(20) NOT NULL auto_increment,
`p_iparam_type_id` bigint(20) NOT NULL default '0',
`p_idevice_id` bigint(20) NOT NULL default '0',
`p_iunixtime` bigint(20) NOT NULL default '0',
`p_fvalue` double default NULL,
`p_ivalid` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`p_id`),
KEY `in_unixtime` (`p_iunixtime`),
KEY `in_full` (`p_iparam_type_id`,`p_idevice_id`,`p_iunixtime`,`p_ivalid`),
KEY `in_p_idevice_id` (`p_idevice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=4294967295 |

the autoicrement is 253643508.

The
set insert_id=253643510;
insert into parameters_back values (null,1465,256,1139221621,474431067,0);

works OK, and after that the next insert again gives error duplicate key .. 253643508.


Now we have created a new table (with large MAX_ROWS) and we're trying to move the data with "insert .... select *" from the broken, without altering the original one.

It will take awhile