If you've read my last email, you know what the problem is, but I have now
pinpointed it a bit further using the processlist feature.
[EMAIL PROTECTED] MBPlatforms]# mysqladmin -v processlist -p
Enter password:
+-----+----------+-----------+-------------+---------+------+--------+-----------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info
|
+-----+----------+-----------+-------------+---------+------+--------+-----------------------------------------------------------------------+
| 75 | pcpadmin | localhost | MBPlatforms | Query | 357 | update | INSERT
INTO MemorySlots VALUES ('6', '8 slots', 'There are 8 slots.') |
| 86 | pcpadmin | localhost | MBPlatforms | Query | 311 | Locked | SELECT *
FROM MemorySlots ORDER BY Name ASC |
| 154 | root | localhost | | Query | 0 | | show full
processlist |
+-----+----------+-----------+-------------+---------+------+--------+-----------------------------------------------------------------------+
This also happens with the REPLACE command seen here. The state is "locked" but
it doesn't come out of it until I manually kill the thread.
What could be causing this? Here is the table design, just FWIW:
Field Type Attributes Null Default Extra Action
ID int(11) No auto_increment
Name varchar(50) No
Desc text No
Thanks for your help!
Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]