I could fix this if I changed the table type to InnoDB, correct? -James
Quoting Jeremy Zawodny <[EMAIL PROTECTED]>: > On Mon, Aug 18, 2003 at 10:41:55AM -0700, [EMAIL PROTECTED] wrote: > > Hello, > > > > I just have a question about the table locking in 3.23.56. If I am > inserting a > > row into a table that is MyISAM type, is the entire table locked? > > Yes. > > > And, if so, what does this mean for concurrent selects? > > An INSERT obtains a WRITE lock on the table, so no concurrent reads > can happen until the write lock is released and someone obtains a READ > lock. > > There's a special case: a MyISAM table with fixed-length rows and no > deleted records allows for INSERTs to happen with SELECTs running. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 17 days, processed 869,429,243 queries (591/sec. avg) > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
