From: Date: November 14 2007 3:44am
Subject: Re: Alter table in 5.0.45
List-Archive: http://lists.mysql.com/cluster/5462
Message-Id: <1195008271.15115.74.camel@localhost.localdomain>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-W5V0R4xzR9ooGEgq7/2h"

--=-W5V0R4xzR9ooGEgq7/2h
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable


On Tue, 2007-11-13 at 17:51 -0800, Jonathan Haddad wrote:
> So I assume I would need enough data memory to make the temporary table -=
 so
> if I have 6GB allocated to ndbd, and 3.2 GB used, I will not be able to a=
dd
> another column, even in single user mode?

Depends on the size of your table.

If you have 3 tables, all of equal size, then yes, you could alter one
at a time.

IIRC SHOW TABLE STATUS gives you the rough size of the table.
--=20
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@stripped
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

--=-W5V0R4xzR9ooGEgq7/2h
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQIVAwUARzphD73yNwHyU3DLAQKy1xAAhVrDwFts3kGCkfkMg7yk6lYfA7JpLsGA
/Dak7Gpv+Ks7L7RijYCHjVxhQKsk2gYkf++HV6L6foWzT3WGBK7RP6COc/+sIotm
9s0spv7b4sQUvxiMA1zAuwgHaU1cO9Qdyfevb2whNOnwcgYliUGxYaXvna+pQVhz
pvPCZa9PGiZUIkLgZqycUHaAb69gaAyc2gu2p9e0aySS7A5yrILpxFpA3ZCobwl/
Xz15GBh1oKiTrjNAn7GmULTvP9OIYtZ4APnEg/2TWiqLnMAh5Wb2v64sYOe2cuqt
jmfwjGDnWO+Ap61xJ5uB5D18UEMve9vhAc2EuJTKCxcF2uuLJqoPRZgvgfuORDUC
WGT/ALX0av07sSBUXeFQ4hChj72wFDE6ZGB7iYqexQZUPyB6zF5aRKkkgkT0x5wL
GEYyVm5ZCa50O6DI1BL/Oxy5zjZYoE6HwBSFo8uWWbRxdsAn1VIIM580PLl5OpwT
GPLvW48TKmJlKiKzwHzp+Qjo6vAtFPDrVuy/qIR70Qp3degtTeOR0gVK0/eIcKck
59PDi1m0fd19DCyn1FLnuewTCrjFJoXqcctutdDCsdNh3IDMsu4+h0mYOxsoM2N4
qbcKi01Z6Gi1H43zVbi7UIJPLZq5ZeElzA+17waB8HvmthBAZAEg5lTnqay5w8Wu
mWeAJ+L8jjg=
=h5RW
-----END PGP SIGNATURE-----

--=-W5V0R4xzR9ooGEgq7/2h--