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]



Reply via email to