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
