I attempted to add a column to a table with a good few million rows. Here is the full query:
alter table date_tasks_mark add column noDuplicate int unsigned not null default 0
However it seems to be stuck.
| 28893 | root | localhost | database_name | Query | 10668 | Waiting for table metadata lock | alter table date_tasks_marks add column noDuplicate int unsigned not null default 0
Is it safe for me to kill the query or will it corrupt my table (it has been in this state for about a half hour)?