Forums

i am specifically trying to add a column to my_table. the syntax I'm using is below. Mysql doesnt give me an error. However, it simply hangs for 10+ mins on this command. When I check running processes, I see that this query is waiting for table metadata lock. What is going on here?

mysql> alter table tblAuctionResults add Paid tinyint(1) default 0;

How big is that table?

there were only 4 rows in it. I have since fixed the issue. I had to kill a sleeping connection that was locking up the database. I couldn't tell which one so I just killed all of them.