Hi,
reading the table-dump with MyISAM takes about 30 seconds.
With InnoDB it ran 3 hours before I killed it.
I removed the Unique-key definitions and it took 22 seconds with InnoDB.
Now I'm creating one unique key and it's running more than 20 hours already.
Perhaps someone with a support-contract may get or have the same problem and
would ask the devs for a fix :)
Table-specs (MyISAM):
Version: 3.23.49a
about 200k rows (on 100k rows localid is NULL)
about 8M data
about 8M index
dump-size: 6.5M (tar.gz: 1.5M)
CREATE TABLE `stock_reg` (
`woid` int(10) unsigned NOT NULL default '0',
`regid` tinyint(3) unsigned NOT NULL default '0',
`localid` char(10) default NULL,
`symbol` char(20) default NULL,
`kupdt` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`woid`,`regid`),
UNIQUE KEY `locregid` (`localid`,`regid`),
UNIQUE KEY `symregid` (`symbol`,`regid`)
) TYPE=MyISAM;
/* 200k rows of inserts or 7 rows with --opt dump here*/
Table-spec (InnoDB)
CREATE TABLE `stock_reg_new` (
`woid` int(10) unsigned NOT NULL default '0',
`regid` tinyint(3) unsigned NOT NULL default '0',
`localid` char(10) default NULL,
`symbol` char(20) default NULL,
`kupdt` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`woid`,`regid`)
) TYPE=Innodb;
INSERT INTO stock_reg_new SELECT * FROM stock_reg; /* 22 secs */
CREATE UNIQUE INDEX `locregid` ON stock_reg_new (`localid`,`regid`); /* is
still running after more than 20 hours */
CREATE UNIQUE INDEX `symregid` ON stock_reg_new (`symbol`,`regid`); /* dont
know yet */
Regards,
Christan Rabe
mysql,query,table,...
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
