Re: Mass Import Innodb

[Rick James]

CREATE TABLE `oldDB`.`documentlist` (
`id_document` int(10) unsigned NOT NULL,
`name` varchar(255) DEFAULT NULL,
`longHTMLdescr` blob,
`fileData` mediumblob,
`lastupdated` datetime DEFAULT NULL,
`status` tinyint(3) unsigned DEFAULT NULL,
`code` smallint(5) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

There is no `id` in that table??
Ditto for the next table.

CREATE TABLE `newDB`.`temp_docids` (
`id_document` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_document_old` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_document`) USING BTREE,
KEY `Index_id_document_old` (`id_document_old`,`id_document`),
KEY `Index_id_document_old2` (`id_document`,`id_document_old`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

Get rid of Index_id_document_old2, it adds nothing other than wasted disk space.

What is the average size of the blobs?
How many rows?