Mysql 4.0 Adding fields to large tables

Hello all,

I am trying to add a field to a very large table.  The problem is that mysql
locks up when trying to do so.  I even tried deleting the foreign keys on
the table and it wont even let me do that, again locking up.

It works for around 5 minutes or so then just either locks or the database
dies and I have to restart it.

Any ideas how to do this?

Thanks,
James


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@...