It would appear that MySql does table locking. Then I would like to ask
the
following:
> From what I've read,
> it would seem that SELECTS get a lower priority than INSERTS and UPDATES,
> meaning that if all 30 users
> insert into that table at the same time (given the way the stress test is
> structured and the environment
> the server will go into, this usage pattern will occur), any other select
> queries simply get sent to the
> back of the queue??
The LOW_PRIORITY modifier puts INSERTS and UPDATES behind SELECTS.
There are caveats about usew with MyISAM tables: it disables concurrent
inserts,
which can occur on non-fragmented tables. However, it sounds as if your
table is
going to be fragmented.
Alec
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php