I use MySQL for my application with InnoDB as primary table.
I found a very strage behaviour of InnoDB table.... after i alter table TABLE drop a field at there ....since this field is not used anymore.
WHen i executre show processlist i found
| 2221 | root | 10.1.20.10:43071 | DB | Query | 1045 | Waiting for tables | insert into TABLE (in_sms_message_id) values ('51104e23G') |
That query was generated using PHP script hit by web client.
I think that my tables was locked, but when i try to insert manually
insert into DB.TABLE(in_sms_message_id) values ('a'); Query OK, 1 row affected (0.01 sec)
So, process id 2221 is waiting for what ?/
This is my innodb status
---TRANSACTION 0 3523706, not started, process no 5646, OS thread id 2858939200
MySQL thread id 2221, query id 6332388 10.1.20.10 root Waiting for tables
insert into DB.TABLE (in_sms_message_id) values ('51104e23G');
So, how to push this query to run ?
Thx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]