NAME

DBIx::Fast::Profile::mysql - MySQL profiling and diagnostics

SYNOPSIS

my $db = DBIx::Fast->new( dsn => 'mysql://user:pass@host/db' );

my $plan  = $db->profiler->explain_query('SELECT * FROM t WHERE id = ?', 1);
my $slow  = $db->profiler->get_slow_queries;
my $stats = $db->profiler->get_stats;
my $conns = $db->profiler->get_current_connections;

DESCRIPTION

MySQL implementation of the driver diagnostics interface. MySQL 8.x still ships everything the MariaDB profile uses (SET profiling, information_schema.profiling, information_schema.processlist, SHOW GLOBAL STATUS) - deprecated in favour of performance_schema, but functional - so this class inherits DBIx::Fast::Profile::MariaDB unchanged. See that module for the full method reference; events emitted through DBIx::Fast::Output carry driver: "mysql".

If a future MySQL release drops the deprecated surface, the affected methods will be overridden here with performance_schema equivalents.

AUTHOR

SeHarrys

LICENSE

This is free software under the Artistic License 2.0.