opentelemetry_mysqlclient_instrumentation_auto_tracing_quickstart.py

1import MySQLdb
2from opentelemetry.instrumentation.mysqlclient import MySQLClientInstrumentor
3
4# Optional: You would typically have your tracer provider configured here
5# from opentelemetry import trace
6# from opentelemetry.sdk.trace import TracerProvider
7# trace.set_tracer_provider(TracerProvider())
8
9# Instrument mysqlclient
10MySQLClientInstrumentor().instrument()
11
12# Now, any MySQLdb connections and queries will be automatically instrumented
13db = MySQLdb.connect(user="root", passwd="password", db="test")
14cursor = db.cursor()
15cursor.execute("SELECT * FROM my_table")
16
17# To uninstrument
18# MySQLClientInstrumentor().uninstrument()