table it locks all other select and update statements
> of other tables too which I don't use in procedure.
>
> Saravanan
>
>
> --- On Sat, 3/29/08, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
>
> > From: B. Keith Murphy <[EMAIL PROTECTED]>
> >
Hi
Last days frequently I see an error message :
"Can't create a new thread (errno 12) if you are not out of available
memory, you can consult the manual for a possible OS-dependent bug."
mysql is 5.0.41
server RAm: 2Gb and 100 Gb free spaces hard disk
users around 64
Into my.ini the max_con
It doesn't lock single table it locks all other select and update statements of
other tables too which I don't use in procedure.
Saravanan
--- On Sat, 3/29/08, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> From: B. Keith Murphy <[EMAIL PROTECTED]>
> Subject: Re: p
When it selects values from the myisam table it is locking the entire
table.
Saravanan wrote:
Hi Lists,
i have created a procedure. It selects values from a myisam table and updates
an innodb table one by one ( not as huge update it clearly use where clause).
but whenever I run the procedure
