InnoDB is not reentrant in the embedded server...
Posted by: Jean-Michel Leon
Date: January 07, 2010 01:36PM

Hi,

I'm trying to better understand a statement from the embedded server documentation. In http://dev.mysql.com/doc/refman/5.1/en/libmysqld-restrictions.html, it says:

<<
InnoDB is not reentrant in the embedded server and cannot be used for multiple connections, either successively or simultaneously.
>>

And a quick test I've written has been able to open multiple connections to different & identical databases, contradicting what I thought would happen after reading that statement. Also, in this thread (http://forums.mysql.com/read.php?58,268322,268322#msg-268322), Isabella Tran seems to indicate that she is using multiple threads as well.

I also found this bug (http://bugs.mysql.com/bug.php?id=13768), when Heikki seems to imply that "non re-entrant" means that you cannot initialize the server twice.

So I was wondering if someone could provide a more detailed clarification on that statement.
More precisely, I'm trying to figure out if a process can run multiple statements in parallel or not, or is it limited to using a single connection, thus forcing to serialize all requests to the instance?


Thanks,

jm.

Options: ReplyQuote


Subject
Written By
Posted
InnoDB is not reentrant in the embedded server...
January 07, 2010 01:36PM


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.