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: procedure locks all statemens
To: [EMAIL PROTECTED], mysq 'mysql list
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
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 other statements waits for longtime until my
procedure completes updates. any idea why it
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: procedure locks all statemens
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