Win2003 32bit AWE 8GB Ram

2008-08-09 Thread Johnny Withers
Hi, I posted this to the Win32 List as well, I have noticed that is seems to be very low volume, sorry for any duplicates. I'm currently having a problem on one of my MySQL servers. The server has 8GB of ram avail. and has /3GB and /PAE added to the boot.ini file. I have read that you must comp

Re: Locking certain rows in a transaction

2008-08-09 Thread Perrin Harkins
On Sat, Aug 9, 2008 at 8:10 AM, John Smith <[EMAIL PROTECTED]> wrote: > Now here's the question: I need to lock certain rows, so that no other > client can read or write that rows (I want those clients to wait until the > transaction is commited or rolled back). I don't want to lock the entire > ta

Locking certain rows in a transaction

2008-08-09 Thread John Smith
Hi, i'm currently experimenting with nested sets. To insert a new node,, I need 1 SELECT, 2 UPDATE and 1 INSERT statement. Of course all of this wii be packed into a transaction, because the table could get corrupted if not all of the mentioned queries are executed. Now here's the question: I nee