DMCDMC Bilgi Teknolojileri
MySQL

For MySQL InnoDB-deep monitoring

From Performance Schema to InnoDB buffer pool and redo log, group replication members to binlog consumption, SSL connections to events scheduler — every angle of your MySQL environment is visible.

Beta status: Provider is live and operates in production PoC scope. The 160+ async DBA action depth shipped for SQL Server is being progressively brought to PostgreSQL/MySQL/MongoDB. GA milestone: 2026-Q3.
Request Demo See capability matrix
MySQL 5.7 MySQL 8.0+ MariaDB 10.x Amazon Aurora MySQL Cloud SQL Azure DB for MySQL
30+Monitoring Method
P_SPerformance Schema
InnoDBBuffer pool + redo log
8.0Group Replication
Performance & Query

Performance Schema and slow query log

Top Sorgular

events_statements_summary

TOP-N ranking by DIGEST_TEXT via Performance Schema events_statements_summary_by_digest; total and average latency, rows_examined, rows_sent.

  • get_top_queries
  • events_statements_summary_*
  • DIGEST-based normalization
  • rows_examined / rows_sent ratio
Slow Log

Slow query log analysis

Longest queries from slow query log, query_time, lock_time, rows_examined and detection of unindexed scans.

  • get_diag_slow_queries
  • long_query_time analysis
  • log_queries_not_using_indexes
  • Lock time vs query time
EXPLAIN

EXPLAIN FORMAT=JSON

Execution plan (FORMAT=JSON), per-node cost, used index, table access type (ALL, ref, range), filtered percentage.

  • get_execution_plan
  • FORMAT=JSON parse
  • Type: ALL warning
  • Filtered percentage
Wait Events

Wait events

Wait categories from Performance Schema events_waits_summary, IO/lock/synch, top wait types.

  • get_wait_stats
  • get_diag_wait_events
  • get_active_waits
  • get_query_wait_stats
Live Monitor

Process list & live

SHOW PROCESSLIST + Performance Schema threads. Active queries, state (Sending data, Locked, Waiting for table metadata lock).

  • get_diag_processlist
  • get_active_queries
  • get_live_query_monitor
  • State: Locked detection
Index

Index usage

Real index usage via table_io_waits_summary_by_index_usage, never-used indexes, missing index suggestions.

  • get_diag_index_usage
  • get_missing_index_recommendations
  • Unused index detection
  • table_io_waits_summary
InnoDB

Buffer pool, redo log, encryption

Buffer Pool

InnoDB buffer pool

Innodb_buffer_pool_pages_data, free, dirty ratio, hit ratio (Innodb_buffer_pool_read_requests / Innodb_buffer_pool_reads). Pool dump/load status.

  • get_buffer_pool_detail
  • Hit ratio >= 99% target
  • Dirty page percentage
  • Pool dump/load
Redo Log

Redo log status

innodb_log_file_size, log buffer usage, log waits, checkpoint age. Redo log file count + per-file distribution.

  • get_redo_log_status
  • Checkpoint age
  • Log waits count
  • Log file utilization
Encryption

InnoDB encryption

Encryption-at-rest enabled tablespaces, master key ID, key rotation history, encrypted vs unencrypted tablespace distribution.

  • get_innodb_encryption
  • Encrypted tablespaces
  • Master key ID
  • Rotation history
InnoDB Status

SHOW ENGINE INNODB STATUS

Latest deadlock info, semaphore waits, transaction history list, log sequence number, pending I/O, OS-level latches.

  • get_diag_innodb_status
  • Latest deadlock
  • Semaphore waits
  • Pending I/O
Locks

InnoDB locks & blocking

Active locks and waiters via data_locks, data_lock_waits. Blocking session chain.

  • get_diag_locks
  • get_blocking_sessions
  • data_locks (8.0+)
  • data_lock_waits
Table Sizes

Table sizes

data_length + index_length from information_schema.tables, largest tables, fragmentation hints.

  • get_diag_table_sizes
  • data_length + index_length
  • Top tables
  • Avg row length
Replication

Group replication, channels & binlog

Group Replication

MySQL Group Replication

Group members from replication_group_members, role (PRIMARY/SECONDARY), member_state (ONLINE/RECOVERING/OFFLINE), conflict detection.

  • get_group_replication
  • Member state
  • Primary election
  • Conflict detection
Channels

Replication channels

Multi-source replication channels, IO_THREAD and SQL_THREAD status, applier worker count, last_error.

  • get_replication_channels
  • replication_connection_status
  • replication_applier_status
  • Channel error
Replica Lag

Replica lag & status

Seconds_Behind_Source / Master, GTID set diff, position lag, Read_Master_Log_Pos vs Exec_Master_Log_Pos.

  • get_replication_status
  • Seconds behind master
  • GTID set diff
  • Position lag
Binlog

Binary log status

File list via SHOW BINARY LOGS, total size, expire_logs_days check, format (ROW/STATEMENT/MIXED), checksum.

  • get_diag_binlog_status
  • Binlog file count + size
  • Expire policy
  • binlog_format
Security

SSL, user privileges, audit log

Security Checks

Security audits

Anonymous user checks, root remote login, default schemas (test), mysql_native_password vs caching_sha2_password usage.

  • get_security_checks
  • Anonymous user
  • Root remote login
  • Auth plugin
SSL

SSL connection status

Is SSL/TLS connection enabled, cipher suite, certificate expiry, REQUIRE SSL setting, how many sessions are SSL-connected.

  • get_ssl_connection_status
  • have_ssl
  • ssl_cipher
  • SSL session count
User Privileges

User permissions

GRANT map via mysql.user + information_schema.user_privileges, SUPER / GRANT OPTION holders, root-like accounts.

  • get_diag_user_privileges
  • get_logins_security
  • SUPER privilege
  • GRANT OPTION
Audit

Audit log

audit_log plugin (Enterprise) or Community alternative MariaDB Audit Plugin records, last N events review.

  • get_audit_logs(limit)
  • Plugin: audit_log
  • Connection events
  • Statement events
Diagnostic & Configuration

Global vars, status, events scheduler

Global variables

Full SHOW GLOBAL VARIABLES output, performance settings, replication configuration.

  • get_diag_global_variables
  • InnoDB settings
  • Replication settings

Global status

SHOW GLOBAL STATUS counters: Threads_*, Innodb_*, Com_*, Handler_*, Slow_queries.

  • get_diag_global_status
  • Counters trend
  • Threads_connected

Events scheduler

Scheduled events from information_schema.events, last run time, next run, status.

  • get_diag_events_scheduler
  • Last executed
  • Next execution

Health check

Health score: uptime, connection limit, slow query ratio, replication lag, InnoDB log waits.

  • get_health_check
  • Uptime
  • Composite score
Full Capability Matrix

MySQL provider monitoring methods

Capability Description Source
Performance & Query
Top queriesDigest-based TOP-Nevents_statements_summary_by_digest
Slow query logQueries exceeding long_query_timeslow_log table / file
EXPLAIN JSONPlan node + costEXPLAIN FORMAT=JSON
Wait eventsevents_waits_summaryperformance_schema
Process listActive threadsSHOW PROCESSLIST + threads
Index usagetable_io_waits_summaryperformance_schema
InnoDB
Buffer poolHit ratio + dirty pagesinformation_schema.innodb_buffer_pool_stats
Redo logCheckpoint age + log waitsSHOW ENGINE INNODB STATUS
EncryptionEncrypted tablespacesinformation_schema.innodb_tablespaces
InnoDB statusDeadlocks, semaphoresSHOW ENGINE INNODB STATUS
Data locksActive locks (8.0+)performance_schema.data_locks
Table sizesdata_length + index_lengthinformation_schema.tables
Replication
Group replicationGroup members + stateperformance_schema.replication_group_members
Replication channelsMulti-source channel statereplication_connection_status
Replica lagSeconds_Behind + GTID diffSHOW REPLICA STATUS
BinlogFile list + formatSHOW BINARY LOGS
Security
SSL statushave_ssl + SSL session countSHOW GLOBAL VARIABLES / STATUS
User privilegesSUPER + GRANT OPTIONmysql.user
Anonymous userEmpty username warningmysql.user
Audit logaudit_log pluginmysql.audit_log
Diagnostic & Config
Global variablesAll GUC parametersSHOW GLOBAL VARIABLES
Global statusCountersSHOW GLOBAL STATUS
Events schedulerScheduled eventsinformation_schema.events
Health checkComposite score—

Monitor MySQL with InnoDB depth

From 5.7 to 8.0, MariaDB to Aurora — full coverage in one license.

Request Demo Full Platform