-->-----Original Message----- -->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] -->Sent: Monday, August 18, 2003 10:42 AM -->To: [EMAIL PROTECTED] -->Subject: Table locking... --> -->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? And, if -->so, -->what does this mean for concurrent selects?
Yes the table is locked. The table is locked on reads / writes. It's not a bad thing necessarily since there are 2 types of locks. Immediate locks and wait locks. Immediate locks are very fast locks, most of the traffic is probably immediate locks and applications rarely see the affect. Wait locks are the killer and can bring down the system from a highly used application point of view. Disk configuration, indexes, queries, traffic, etc. all influence these 2 types of locks. --> -->-James --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]