On Mon, Dec 15, 2003 at 02:12:01PM +1100, Chris Nolan wrote: > It seems slightly ambiguous - updates are redirected and stalled. The > fact that the two statements are in different sentences threw me off > slightly.
Oh, okay. If you can suggest a more clear version, perhaps Paul will update the manual with it? Jeremy > On Mon, 2003-12-15 at 03:55, Jeremy Zawodny wrote: > > On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote: > > > Hi all, while reading through some of the MySQL docs, I noticed the > > > following paragraph: > > > > > > |ALTER TABLE| works by making a temporary copy of the original table. > > > The alteration is performed on the copy, then the original table is > > > deleted and the new one is renamed. This is done in such a way that all > > > updates are automatically redirected to the new table without any failed > > > updates. While |ALTER TABLE| is executing, the original table is > > > readable by other clients. Updates and writes to the table are stalled > > > until the new table is ready. > > > > > > This seems a bit confusing. On one hand, it says that updates don't > > > fail, but on the other hand it says they are stalled until ALTER TABLE > > > is done executing. Am I going blind/loosing my mind (a possibility I am > > > open to) or do others agree with me? > > > > What exactly is the discrepancy you see? Can you be explicit? > > > > The manual describes the way ALTER TABLE works accurately. > > > > Jeremy > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
