MySQL Forums
Forum List  »  MyISAM

MyISAM concurrent table access
Posted by: Hiromichi Watari
Date: January 05, 2012 11:19AM

Hi,
Is it possible for a client connection thread to access 2 tables (reads) concurrently with MyISAM, say using a slave thread (with shared THD object) ? Or is one access blocked because some resource tied to THD is locked by the other access ?
I ran an experiment which seems to indicate that it is possible with InnoDB but not with MyISAM.
Thanks,
Hiromichi

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM concurrent table access
2810
January 05, 2012 11:19AM
2027
January 07, 2012 01:33AM
2048
January 11, 2012 10:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.