MySQL / MariaDB operations

Install

emisar pack install validates the pack and verifies its content hash before copying it into /etc/emisar/packs. The --hash below pins the install to the exact bytes on this page — a tampered copy is rejected. After install, reload the runner; it re-reads the catalog and advertises every action.

content hash: sha256:8f542b9d4cd9f2059cbf64e856a6b63a2db75e1f7eb1148bd5da4d5cf3da57ca

sudo emisar pack install mysql \
  --hash sha256:8f542b9d4cd9f2059cbf64e856a6b63a2db75e1f7eb1148bd5da4d5cf3da57ca \
  --dest /etc/emisar/packs

# Reload so the runner re-reads the catalog:
sudo systemctl reload emisar

• mysql.analyze_table exec medium

  ANALYZE TABLE

• mysql.binlog_positions exec low

  Binary log files

• mysql.connections_summary exec low

  Connection counts + cap

• mysql.db_sizes exec low

  Database sizes

• mysql.engines exec low

  SHOW ENGINES

• mysql.flush_logs exec medium

  FLUSH LOGS

• mysql.flush_status exec medium

  FLUSH STATUS

• mysql.gtid_executed exec low

  GTID executed set

• mysql.index_unused exec low

  Unused indexes

• mysql.innodb_status exec low

  SHOW ENGINE INNODB STATUS

• mysql.kill_connection exec high

  KILL (terminate connection)

• mysql.kill_query exec high

  KILL QUERY (cancel statement)

• mysql.lock_waits exec low

  Lock-wait graph

• mysql.master_status exec low

  SHOW MASTER STATUS

• mysql.open_tables exec low

  SHOW OPEN TABLES

• mysql.optimize_table exec high

  OPTIMIZE TABLE

• mysql.processlist exec low

  SHOW FULL PROCESSLIST

• mysql.replica_status exec low

  SHOW REPLICA STATUS

• mysql.slow_queries exec low

  Top slow query digests

• mysql.status exec low

  SHOW GLOBAL STATUS (filtered)

• mysql.table_io_summary exec low

  Top tables by IO wait

• mysql.table_sizes exec low

  Top tables by total size

• mysql.uptime exec low

  Uptime + version

• mysql.users_grants exec low

  List users + grants summary

• mysql.variables exec low

  SHOW GLOBAL VARIABLES (filtered)