0.38.1 • Published 4 days ago

@opentelemetry/instrumentation-mysql2 v0.38.1

Weekly downloads
-
License
Apache-2.0
Repository
github
Last release
4 days ago

OpenTelemetry mysql Instrumentation for Node.js

NPM Published Version Apache License

This module provides automatic instrumentation for the mysql2 module, which may be loaded using the @opentelemetry/sdk-trace-node package and is included in the @opentelemetry/auto-instrumentations-node bundle.

If total installation size is not constrained, it is recommended to use the @opentelemetry/auto-instrumentations-node bundle with @opentelemetry/sdk-node for the most seamless instrumentation experience.

Compatible with OpenTelemetry JS API and SDK 1.0+.

Installation

npm install --save @opentelemetry/instrumentation-mysql2

Supported Versions

  • >= 1.4.2, < 4.0

Usage

OpenTelemetry MySQL2 Instrumentation allows the user to automatically collect trace data and export them to the backend of choice, to give observability to distributed systems when working with mysql2.

To load a specific plugin (MySQL2 in this case), specify it in the registerInstrumentations's configuration

const { NodeTracerProvider } = require('@opentelemetry/sdk-trace-node');
const { MySQL2Instrumentation } = require('@opentelemetry/instrumentation-mysql2');
const { registerInstrumentations } = require('@opentelemetry/instrumentation');

const provider = new NodeTracerProvider();
provider.register();

registerInstrumentations({
  instrumentations: [
    new MySQL2Instrumentation(),
  ],
})

MySQL2 Instrumentation Options

You can set the following instrumentation options:

OptionsTypeDescription
responseHookMySQL2InstrumentationExecutionResponseHook (function)Function for adding custom attributes from db response
addSqlCommenterCommentToQueriesbooleanIf true, adds sqlcommenter specification compliant comment to queries with tracing context (default false). NOTE: A comment will not be added to queries that already contain -- or /* ... */ in them, even if these are not actually part of comments

Semantic Conventions

This package uses @opentelemetry/semantic-conventions version 1.22+, which implements Semantic Convention Version 1.7.0

Attributes collected:

AttributeShort Description
db.connection_stringThe connection string used to connect to the database.
db.nameThis attribute is used to report the name of the database being accessed.
db.statementThe database statement being executed.
db.systemAn identifier for the database management system (DBMS) product being used.
db.userUsername for accessing the database.
net.peer.nameRemote hostname or similar.
net.peer.portRemote port number.

Useful links

License

Apache 2.0 - See LICENSE for more information.