MySQL Forums
Forum List  »  Quality Assurance

why caused LOCK by select query in mysql cluster?
Posted by: Lee Wonseok
Date: March 06, 2008 10:51PM

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???

Options: ReplyQuote


Subject
Views
Written By
Posted
why caused LOCK by select query in mysql cluster?
3137
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.