why caused LOCK by select query in mysql cluster?
hello.
I am using Mysql Cluster 5.1.23.rc.
I firstly runned below select query.
(of course, none transaction)
SELECT t.id, s.id FROM t, s
WHERE t.obj_id = s.obj_id AND
login = 'test@test.com';
(this query takes time 2 min.)
then, i immediately runned below update query.
update t set status=5 where obj_id=33333;
then, update query is locked.
below is show processlist result.
mysql> show processlist;
| 663 | user1 | host-10.10.internal:2841 | test | Query | 35 | Sending data | SELECT t.id, s.id FROM t, s WHERE t.obj_id = s.obj_id AND login = 'test@test.com'; |
| 664 | user2 | host-10.10.internal:2842 | test | Query | 5 | Locked | update t set status=5 where obj_id=33333; |
this is normal operation of mysql cluster???
Subject
Views
Written By
Posted
why caused LOCK by select query in mysql cluster?
3187
March 06, 2008 10:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.