#!/usr/bin/python3
import mysql.connector
import uuid
import time

mysql_config = {
  'user': 'msandbox',
  'password': 'msandbox',
  'host': '127.0.0.1',
  'port': 5715,
}

con = mysql.connector.connect(**mysql_config)
c = con.cursor()

for i in range(10000):
    runtimes = []
    for j in range(1000):
        gtid_next = str(uuid.uuid1()) + ':1'
        start = time.time()
        c.execute("SET gtid_next = '%s'" % gtid_next)
        con.commit()
        runtimes.append(time.time() - start)
    print("Runtimes: Count: %d, Min: %.8f, Max: %.8f, Avg: %.8f" % (
           len(runtimes), min(runtimes), max(runtimes), sum(runtimes) / len(runtimes)))

c.close()
con.close()