I had put a similar question (that unfortunately never got answered) on
this mailing list and so I have pondered about this problem also. The
way I see it, delayed_insert_timeout doesn't do any good here because it
only determines how long an idle (with no pending jobs) insert delayed
thread will
lorenzo.kh,
Monday, July 29, 2002, 11:59:49 AM, you wrote:
lk> I have a question regard the table locking.
lk> Let say there is a table ,mytablename type=MyISAM in my database.
lk> And lets say there are 2 users who are currently log in.
lk> First user locks a table write:
lk> mysql> lock tables
if you need table or datarow locking , why don't you use innodb table type
with transactions ?
bye, thomas
> First user locks a table write:
> mysql> lock tables mytablename write;
> Query OK, 0 rows affected (0.00 sec)
>
> Then,second user wishes to query something from mytablename.
> mysql>sele
