We use InnoDB on all Tables but see the lock problems on 2 independent installations.
Am 25.07.2011 um 19:22 schrieb Eric Pierce: > MySQL uses table-level locking if you're using the MyISAM storage engine and > row-level with InnoDB. MyISAM was the default for years and is faster than > InnoDB in certain use cases, but tables with many updates/deletes should use > InnoDB > > On Mon, Jul 25, 2011 at 11:10 AM, Marvin Addison <[email protected]> > wrote: > > > > > What's your experience with MySQL? > > > > Not much other than using it for development testing and the reports > > of deadlocks by other users. My sense is that it falls somewhere in > > the middle of the two I mentioned. > > > > M > > > > -- > > You are currently subscribed to [email protected] as: [email protected] > > To unsubscribe, change settings or access archives, see > > http://www.ja-sig.org/wiki/display/JSG/cas-user > > > > -- > Eric Pierce > Identity Management Architect > Information Technology > University of South Florida > (813) 974-8868 <tel:%28813%29%20974-8868> -- [email protected] > > > -- > Eric Pierce > Identity Management Architect > Information Technology > University of South Florida > (813) 974-8868 -- [email protected] > -- > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
