View Single Post

   
  #3 (permalink)  
Old 05-16-2008, 02:40 PM
Captain Paralytic
 
Posts: n/a
Default Re: need to lock table?

On 16 May, 07:51, Geoff Cox <g...@freeuk.notcom> wrote:
> Hello,
>
> I have a site which is to be mentioned on a radio programme and just
> might have lots of users accessing the site following this broadcast.
>
> There is javascript/php which adds data to MySQL - is there any need
> to lock/unlock the table each time or does MySQL itself take care of
> large numbers of concurrent users?


If all you are doing is adding data to a table then that is fine.
Locking tables is only required for transactional type processing,
when the InnoDB engine is not available.

Reply With Quote