[PYTHON] About pgbench for MySQL

(This is a note to put pressure on yourself)

I remember writing this article in February 2013.

"Isn't there a MySQL version of pgbench?"

At that time, it was necessary to lightly load MySQL, and since it was originally attached to sysbench and had the property of generating a deadlock at the SQL level, it could not be used for what I wanted to do at that time, and it was as easy as PostgreSQL's pgbench. I wondered if there was any one ... and when I searched for it, a volunteer from the MySQL User Group discovered a transplanted one a long time ago (2004 !?), and even in 2013 it was said that it worked just by reworking one line. ..

And this is the sequel.

"Python version of mysqlbench"

This was because I was practicing python at that time and wanted to port the above MySQL version of pgbench (language is C) to Python.

In fact, in the git repository mentioned above, there are also some that have been ported (tried) using sqlalchemy.

I was throwing it out while it was in process, but let's put it together properly at this time> myself

... so I can't escape ... w

(There is no punch line (yet) (laughs))

Recommended Posts

About pgbench for MySQL
About Python for loops
About Python, for ~ (range)
About polymorphism for nesting
About Fabric's support for Python 3
About mod_wsgi's "Compiled for ~" warning
About "for _ in range ():" in python
About pyenv's support for Anaconda / Miniconda
INSERT into MySQL with Python [For beginners]
Debug for mysql connection with python mysql.connector
About Japanese fonts of matplotlib (for Mac)
About data expansion processing for deep learning