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
Hi,
I have a question regard the table locking.
Let say there is a table ,mytablename type=MyISAM in my database.
And lets say there are 2 users who are currently log in.
First user locks a table write:
mysql lock tables mytablename write;
Query OK, 0 rows affected (0.00 sec)
Then,second user
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.
mysqlselect *
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