At 11:00 PM +0200 5/9/01, Christian Jaeger wrote:
>Was the table inaccessible during these 4 days? Or is mysql able to
>still write to the table while it's being altered?
Those are not mutually exclusive possibilities. :-)
According to the manual, reads can be done on the original table while
the new table is being constructed. Updates are stalled and then applied
to the new table after the alteration.
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
>
>Christian.
>
>At 12:08 Uhr -0700 9.5.2001, David J. Potter wrote:
>>occur very fast. We use both Windows and Linux. Adding a column is the
>>only action that is slow (it took 4 days once to add a column)
>
>---------------------------------------------------------------------
>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
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
