Open Stack

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

On 07/07/14 22:28, Jay Pipes wrote:
> 
> 
> On 07/07/2014 04:17 PM, Mike Bayer wrote:
>> 
>> On 7/7/14, 3:57 PM, Matt Riedemann wrote:
>>> 
>>> 
>>> 
>>> Regarding the eventlet + mysql sadness, I remembered this [1]
>>> in the nova.db.api code.
>>> 
>>> I'm not sure if that's just nova-specific right now, I'm a bit
>>> too lazy at the moment to check if it's in other projects, but
>>> I'm not seeing it in neutron, for example, and makes me wonder
>>> if it could help with the neutron db lock timeouts we see in
>>> the gate [2].  Don't let the bug status fool you, that thing is
>>> still showing up, or a variant of it is.
>>> 
>>> There are at least 6 lock-related neutron bugs hitting the gate
>>> [3].
>>> 
>>> [1] https://review.openstack.org/59760 [2]
>>> https://bugs.launchpad.net/neutron/+bug/1283522 [3]
>>> http://status.openstack.org/elastic-recheck/
>> 
>> 
>> yeah, tpool, correct me if I'm misunderstanding, we take some API
>> code that is 90% fetching from the database, we have it all under
>> eventlet, the purpose of which is, IO can be shoveled out to an
>> arbitrary degree, e.g. 500 concurrent connections type of thing,
>> but then we take all the IO (MySQL access) and put it into a
>> thread pool anyway.
> 
> Yep. It makes no sense to do that, IMO.
> 
> The solution is to use a non-blocking MySQLdb library which will
> yield appropriately for evented solutions like gevent and
> eventlet.
> 

FYI I've posted a neutron proposal to switch to MySQL Connector at:
https://review.openstack.org/104905

/Ihar
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.22 (Darwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBCgAGBQJTu67+AAoJEC5aWaUY1u57sPQIAKGOyJRohkemZLno7QF20OId
zM7tIuy7J96qzEj7FIEeDJCv3BPl21BsJS/XLcQKDCXCVbZVDTo1Pp8W3a2EoY1L
w3EPl5OVMsZT6h44Ln63KKsn+cjyFg1oJ377cfU+E8MOZ62gxPgGt6q/E0n89/hq
zRTk5lh4jkAIuM5NSJ15Gmyfkps+/m3YvrutzH6hE3mYuLMWozS5RIP2mEH+DDLS
s3aRtDCdizEYU+/wrBgoeH5NeYfR6rB4akGLL7yfqF86lFvHSO40tTWZRdpdPlMU
8zfySY0U3x1AMbX7HToglq6mTevjDjD3kv7e4BrRS6zUgIW3VOSe1uge0cORYZI=
=dTxT
-----END PGP SIGNATURE-----