674817 - Find a nonblocking way to talk to MySQL

Status: RESOLVED WONTFIX

(support.mozilla.org Graveyard :: Chat, defect, P1)

Description

[Erik Rose [:erik][:erikrose]]

There's just no denying it--we need to grab a thing or two out of MySQL from our single-threaded chat server. It would be great if it didn't have to go through a bunch of rigmarole to do it. Sync has had a lot of luck with pymysql. It's basically the same speed, pure Python (yay, less stuff to compile), and can be monkeypatched into nonblockingness by gevent. Maybe give it a try.

https://github.com/petehunt/PyMySQL/

Comment 1

[Erik Rose [:erik][:erikrose]]

If you do try PyMySQL, make sure you get the version that uses socket.sendall() rather than send(); this was causing problems under load for Sync. Likewise, get MyConPy >= 0.3, where an identical bug was fixed.

Ref: http://tarekziade.wordpress.com/2011/07/12/firefox-sync-python/

Comment 2

[Ricky Rosario [:rrosario, :r1cky]]

Live Chat rewrite bugs -> Future

Comment 3

[James Socol [:jsocol, :james]]

Closing out a number of new chat system bugs. If we revisit in the future we'll almost certainly start over.