From: Vyacheslav Akhmechet Date: May 16 2009 7:28am Subject: rnd_init()/index_init() interleaving behavior List-Archive: http://lists.mysql.com/internals/36720 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Are calls to rnd_init and index_init ever interleaved? That is, could there be a situation in which index_init is called after rnd_init but prior to rnd_end? Similarly, could rnd_init be called between the calls to index_init and index_end? The reason I'm asking is that I always access the data through an index (rnd_next just walks the index), and the act of walking the index requires a cursor/iterator-type object. I want to know if I can get away with a single cursor object per handler instance, or if I'll have to maintain multiple simultaneous cursors (one for rnd_init/rnd_next/rnd_end series, one for index_init/index_next/index_end, etc.) Regards, - Slava