In the last episode (Dec 21), Jason J. W. Williams said:
If someone could suggest some advice/guidance I would be very
grateful. I'm trying to determine why the following SELECT query
table locks the bad_behavior table referenced the query.
'bad_behavior' is MyISAM
'c' is InnoDB
'a' is
Hi Dan,
I guess I'm curious why this query acquires a read lock. Is it because
its in a transaction? Thank you very much in advance!
-J
On 12/22/06, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Dec 21), Jason J. W. Williams said:
If someone could suggest some advice/guidance I
In the last episode (Dec 22), Jason J. W. Williams said:
I guess I'm curious why this query acquires a read lock. Is it
because its in a transaction? Thank you very much in advance!
You mean as opposed to a write lock? Only inserts and updates need
write locks.
Or do you mean why is it
Hi All,
If someone could suggest some advice/guidance I would be very
grateful. I'm trying to determine why the following SELECT query table
locks the bad_behavior table referenced the query.
'bad_behavior' is MyISAM
'c' is InnoDB
'a' is InnoDB
Query:
select item_p from (select inet_ntoa(ip)