List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2001 3:59am
Subject:Re: Having success with 20 million rows
View as plain text  
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 <mysql-thread73402@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, paul@stripped
Thread
Removing Bad Characters from Databasejoe9 May
  • Re: Removing Bad Characters from DatabaseEric Fitzgerald9 May
    • Re: Removing Bad Characters from DatabaseA. Chris Nichols9 May
      • RE: Removing Bad Characters from Databasejoe9 May
        • Having success with 20 million rowsDavid J. Potter9 May
          • Re: Having success with 20 million rowsJoshua J. Kugler9 May
          • Re: Having success with 20 million rowsChristian Jaeger9 May
            • Re: Having success with 20 million rowsPaul DuBois10 May
        • MySQL HAcarlos ospina9 May
          • RE: MySQL HABilly Passauer9 May
            • RE: MySQL HATyrone Mills9 May
            • Re: MySQL HAJeremy Zawodny9 May
            • RE: MySQL HARavi Raman9 May
              • Re: MySQL HAcarlos ospina9 May
                • Re: MySQL HAJeremy Zawodny10 May
            • Re: MySQL HACal Evans9 May
            • Re: MySQL HAJoshua J. Kugler9 May
          • Re: MySQL HAJeremy Zawodny9 May
        • Re: Having success with 20 million rowsErnesto Vargas9 May
  • Re: Removing Bad Characters from DatabasePaul DuBois10 May
RE: Having success with 20 million rowsRobert Henkel9 May
RE: Having success with 20 million rowsRobert Henkel9 May
  • Re: Having success with 20 million rowsZak Greant9 May
RE: MySQL HARobert Henkel9 May
RE: Having success with 20 million rowsRobin Keech10 May
RE: Having success with 20 million rowsJHDrexler10 May
RE: Having success with 20 million rowsJesper Frank Nemholt10 May