Re: innodb locks

2001-11-20 Thread Beno Attila
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 20 Nov 2001, Heikki Tuuri wrote: When someone buys a particular type of good, I would like to lock those rows from the table, but since the quantity will change, I don't even want other users to see these rows until I'm finished.

php + innodb deadlocks

2001-11-20 Thread Beno Attila
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 hi, another question on innodb. right now I'm using table locks. They work, but of course they are slow as hell. low-level locking would be great. but. my application could cause an innodb deadlock just about anywhere. (2 users attacking each

innodb locks

2001-11-19 Thread Beno Attila
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm a regular mysql user, and a very newbie to innodb. :) I would like to use innodb because of its row-level locking feature. Presently I have to use table locks, and they're causing lots of speed problems. (I've tried Gemini tables, but mysql