I wonder why you have 19 fields in a single table. I don't think there is really any way to predict it, since it depends on so many different factors.
On Fri, 3 Oct 2003 11:19:56 +0200, Peer Reiser <[EMAIL PROTECTED]> wrote: | Fortunately the database is not in production :-) but it should go as | soon as possible :-( | | | On viernes, octu 3, 2003, at 11:03 Europe/Madrid, Wang Feng wrote: | | > 18hrs??? So, the database has been LOCKED for 18hrs???? | > | > | > ----- Original Message ----- | > From: "Peer Reiser" <[EMAIL PROTECTED]> | > To: <[EMAIL PROTECTED]> | > Sent: Friday, October 03, 2003 6:57 PM | > Subject: Newbye speed question | > | > | >> HI | >> | >> I am having a MYISAM database with 27 million rows and 19 fields all | >> char between 15 and 1 characters long. | >> | >> yesterday i did a | >> alter table mytablename add column (version char(2)); | >> By now (18 hours later) it has not finished yet? | >> Is there a way to somehow predict the time needed for this? Or to see | >> the status? | >> Or anyone has some experiense? | >> | >> thanx | >> | >> | >> -- | >> MySQL General Mailing List | >> For list archives: http://lists.mysql.com/mysql | >> To unsubscribe: | >> http://lists.mysql.com/[EMAIL PROTECTED] | > | > | > -- | > MySQL General Mailing List | > For list archives: http://lists.mysql.com/mysql | > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] | > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]