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]