View Single Post

  #4 (permalink)  
Old 05-16-2008
Geoff Cox
 
Posts: n/a
Default Re: need to lock table?

On Fri, 16 May 2008 02:23:12 -0700 (PDT), Captain Paralytic
<paul_lautman@yahoo.com> wrote:

>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.


Paul,

Thanks for the info. One less problem!

Cheers

Geoff
Reply With Quote