Why don't you add all the indecies in one alter table command?
Brent Baisley wrote:
You can probably monitor the database directory to see when the
temporary file disappears or the index file size stops changing. Then
it won't matter if the script dies again or not, you just need to keep
track of which indexes have already been built.
On Friday, January 17, 2003, at 08:30 AM, Lunde, Gunnar wrote:
Hi,
I need some guidance to the following problem.
We have a really big table that crashed. We decided to rebuild the
indexes so we stripped all the indexes and started a perl script that
issued commands to build one index at a time. No the problem is that
the
shell where we started the script died during the night. The script
has
started building the first index, and has about 25 hours to go
before it's
finished. So my question is if it is ok to start a new script to
take over
from where the old one died. Does the indexing job lock the table so
that
the new script will wait until the first index is finished?
Hope you can enlighten me!
Best Regards
Gunnar Lunde
sql
---------------------------------------------------------------------
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 <mysql-unsubscribe-
[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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