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 add
> 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.
--
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
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
