<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style><style type="text/css"></style><style type="text/css"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;"><span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">>Because the mysql client connection is C-based, calls to it will be</span><br style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">
<span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">>blocking operations on greenthreads within a single process, meaning</span><br style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">
<span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">>even if multiple greenthreads are spawned for those 200 incoming</span><br style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">
<span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">>requests, they will be processed synchronously.</span><br style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">
<div><span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;"><br>
</span></div>
<div><span style="font-family: 'Segoe UI', Helvetica, Arial, sans-serif;">Hi Jay, can you please specify what methods in the sqlalchemy library are blocking the greenthreads in a single process?</span></div>
<div><font face="Segoe UI, Helvetica, Arial, sans-serif">If i call get_session multiple times during an http api request (say create_user), does it block all greenthreads on each get_session[1]? Or does the session.commit, session.begin, or session.rollback
methods block all greenthreads?</font></div>
<div><font face="Segoe UI, Helvetica, Arial, sans-serif"><br>
</font></div>
<div><font face="Segoe UI, Helvetica, Arial, sans-serif">[1] https://github.com/openstack/keystone/blob/master/keystone/common/sql/core.py#L217</font></div>
</div>
<br clear="both">
______________________________________________________________________<BR>
Disclaimer:This email and any attachments are sent in strictest confidence for the sole use of the addressee and may contain legally privileged, confidential, and proprietary data. If you are not the intended recipient, please advise the sender by replying promptly to this email and then delete and destroy this email and any attachments without any further use, copying or forwarding<BR>
</body>
</html>