Resume indexing after powerloss?

2003-10-21 Thread Peer Reiser
Someone knows if its possible to resume indexing a base where it left due to a power failure? The process was copying to tmp file when the power went away, having achieved 5GB of total 6GB in 6 days.. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: Newbye speed question - which setup to use for indexing

2003-10-03 Thread Peer Reiser
Next week I will have access to a new PomerMac G5 with Dual 2GHZ processors, and i want to do some indexing. Does anyone know if MySQL will take advantage of dual processors if the only process running is the indexing process?? Is disk I/O more important ? The bad temper of my boss seems to inc

Re: Newbye speed question

2003-10-03 Thread Peer Reiser
Fortunately the database is not in production :-) but it should go as soon as possible :-( On viernes, octu 3, 2003, at 11:03 Europe/Madrid, Wang Feng wrote: 18hrs??? So, the database has been LOCKED for 18hrs - Original Message - From: "Peer Reiser" <[EMAIL PROTECTED]

Newbye speed question

2003-10-03 Thread Peer Reiser
HI I am having a MYISAM database with 27 million rows and 19 fields all char between 15 and 1 characters long. yesterday i did a alter table mytablename add column (version char(2)); By now (18 hours later) it has not finished yet? Is there a way to somehow predict the time needed for this? Or t