Re: Lock Tables Question

[Paul McCullagh]

Hi David,

On Jun 5, 2007, at 3:55 PM, David T. Ashley wrote:

> My only concern with GET_LOCK() is that lock is server-global  
> rather than
> database-global.  This makes attacks possible in a shared setting  
> (some bad
> person could disable your database code by going after your lock).
>
> My solution is just to lock all tables in one statement.
>
> The only question I have (and nobody has answered this) is how many  
> tables I
> can include in a single LOCK TABLE statement.  I thinking anything  
> up to a
> few thousand shouldn't be a problem.  What is the limit?

The size of a query is limited by the value of the  
"max_allowed_packet" system parameter. So if you want to add more  
tables to your LOCK TABLE statement, you should just be able to  
increase max_allowed_packet until it works.

Regards,

Paul