import time
import pymysql.cursors

def main():
    conn = pymysql.connect(user='monitor',
                           unix_socket='/var/run/mysqld/mysqld.sock',
                           charset='utf8mb4',
                           cursorclass=pymysql.cursors.DictCursor)
    sql = '''SELECT blocking_lock_id, wait_age_secs, blocking_query, waiting_query
    FROM sys.innodb_lock_waits'''
    while True:
        with conn.cursor() as cur:
            cur.execute(sql)
            for r in cur:
                for k, v in r.items():
                    print('{} : {}'.format(k, v))
                print()
        time.sleep(1.0)

if __name__ == '__main__':
    main()