Bottle and Mysql blocking request

Question

I'm trying to figure out why my simple code have a blocking concurrent request:

# -*- coding: utf-8 -*-
import MySQLdb
from bottle import route, run
from gevent import monkey
monkey.patch_all()


cnx = MySQLdb.connect(host='127.0.0.1', port=3306, db='db', user='user', passwd='pass', use_unicode=True, charset="utf8mb4")
cursor = cnx.cursor()


@route('/testlong', method='GET')
def test_long():
    cursor.execute('SELECT SLEEP(5);')
    return 'finished'


@route('/testfast', method='GET')
def test_fast():
    return 'finished'


if __name__ == '__main__':
    run(host='127.0.0.1', port=46677, debug=True, server='gevent')

If I run http://localhost:46677/testlong and at the same moment http://localhost:46677/testfast on a different browser, my second request have to wait that the first is finished (so 5 seconds).

What I'm doing wrong please ? Thank you for your help.

The [docs](https://bottlepy.org/docs/dev/async.html#greenlets-to-the-rescue) seem to imply that you should be `yield`ing, not `return`ing. — snakecharmerb, Dec 12 '20 at 14:31
https://stackoverflow.com/questions/48532301/python-postgres-psycopg2-threadedconnectionpool-exhausted/49366850#49366850 — eatmeimadanish, Dec 21 '20 at 17:13
@eatmeimadanish this is what I finished to do, I modified this Package (https://github.com/hsxhr-10/PyMySQLPool) for MySQLdb — Julien, Dec 22 '20 at 19:24

score 1 · Accepted Answer · answered Dec 13 '20 at 19:15

1

The MySQLdb package is just a thin Python wrapper on top of a C extension, which means that gevent can't monkey patch it.

You should either use a pure Python MySQL client (like PyMySQL) or use a different framework that supports threading (like FastAPI/Starlette).

answered Dec 13 '20 at 19:15

ron rothman

17,348
7
41
43

Happy to help! If this answered your question, please select it as the answer by clicking on the check mark. – ron rothman Dec 14 '20 at 12:06

Bottle and Mysql blocking request

1 Answers1