Need help with mysql restore speed
Table crashed, had to restore from backup, I started the restore 2 weeks ago, the last change date on the files is the 8th, so mysql has not wrote data into the files sense then, but it's still running! (or is it?)
the data restore is pretty quick, the index restore is VERY slow, if it even functions
how does everyone deal with this issue, or is this not an issue for anyone else?
Here's what I use to backup
mysqldump --opt finlog 321st_stat > /intranet/backup/321st_stat.sql
using this to restore
mysql -f < 321st_stat.sql
Server is a dual 2.8 xeon with 1gig of ram, the only job running is the restore
windows 2000, mysql 4.1.7, no options set in the ini file
table has aproximatly 80 million records
CREATE TABLE `321st_stat` ( `dic` char(3) NOT NULL default '', `fr_ric` char(3) NOT NULL default '', `niin` char(11) NOT NULL default '', `ui` char(2) NOT NULL default '', `qty` char(5) NOT NULL default '', `don` char(14) NOT NULL default '', `suf` char(1) NOT NULL default '', `dte_txn` char(5) NOT NULL default '', `ship_to` char(3) NOT NULL default '', `sta` char(2) NOT NULL default '', `lst_sos` char(3) NOT NULL default '', `esd` char(4) NOT NULL default '', `stor` char(3) NOT NULL default '', `d_t` char(4) NOT NULL default '', `ctasc` char(10) NOT NULL default '', PRIMARY KEY (`dic`,`niin`,`fr_ric`,`don`,`suf`,`dte_txn`,`sta`), KEY `don` (`don`), KEY `niin` (`niin`), KEY `stor` (`stor`), KEY `dic` (`dic`), KEY `ctasc` (`ctasc`) ) ENGINE=MyISAM PACK_KEYS=1
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]