python mysql cursor not refresh

You just need to set

database.autocommit(True)

ejabberd external auth auth_mysql CPU 100%

I don't know exact reason. But the perl script is time out. So I changed to python to resolve it.