List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:September 15 1999 11:57pm
Subject:Re: newbie question
View as plain text  
At 07:55, 19990916, Isfarazi wrote:
>Is it OK if there are 100+ users accessing the same table at once and
>doing inserting, updating at the same time?

It's okay.  But they won't be doing it "at the same time" - MySQL will
lock the tables implicitly for reading/writing when a client is
selecting/inserting,updating,deleting.  So you don't program for it,
it's handled automatically.

If you need multiple actions on a table to be atomic, you can use LOCK
TABLES to explicitly do those locks.  You can avoid that need often by
doing incremental updates (e.g., SET foo=foo+1) and using auto_increment
keys w/ the LAST_ID() function.

Tim
Thread
indexing problemArun Bhalla12 Sep
  • indexing problemJani Tolonen13 Sep
    • Re: indexing problemArun Bhalla13 Sep
      • Re: indexing problemJani Tolonen13 Sep
        • Re: indexing problemArun Bhalla14 Sep
        • Re: indexing problem (another)Arun Bhalla14 Sep
  • indexing problemMichael Widenius16 Sep
    • newbie questionIsfarazi16 Sep
      • Re: newbie questionThimble Smith16 Sep
      • Re: newbie questionJoshua Chamas16 Sep