Source types for the Splunk Add-on for MySQL

The Splunk Add-on for MySQL collects different events from different sources in MySQL Server. The add-on assigns different source types for each different log or event source.

There are two major groups of source types for the Splunk Add-on for MySQL. Each group depends on how events are collected:

• Collected through Splunk DB Connect (based on database queries)
• Collected through file monitoring (based on log files)

Log file source types

Data source	Source type	CIM Data Models
MySQL general log (file with general log content)	mysql:generalQueryLog	n/a
MySQL error log (file with error log content)	mysql:errorLog	n/a
MySQL Innodb status (regex matching Innodb status content from mysql:errorLog and redirecting to this source type)	mysql:innodbStatus	n/a
MySQL Slow Query Log (file with slow query log content)	mysql:slowQueryLog	Databases

Database entry source types

Data source	Collection method	Source type	CIM or ITSI data models
Logs from innodb_buffer_page database table	DB Connect	mysql:innodb_buffer_page	n/a
MySQL Innodb status	DB Connect	mysql:innodbStatus	n/a
MySQL role/account permission grant	DB Connect	mysql:grants	n/a
MySQL database threads/processes information	DB Connect	mysql:databaseProcess	Databases
MySQL process information	DB Connect	mysql:processInfo	Databases
MySQL system variables global settings	DB Connect	mysql:variables	ITSI Database
MySQL users	DB Connect	mysql:user	ITSI Database
Overall MySQL status	DB Connect	mysql:status	n/a
MySQL schema objects	DB Connect	mysql:schemaObjectOverview	n/a
Logs from database table	DB Connect	mysql:database	Databases
MySQL logs from general_log database table	DB Connect	mysql:generalQueryLogDb	ITSI Database
MySQL logs from slow_query database table	DB Connect	mysql:slowQueryLogDb	Databases
MySQL table status	DB Connect	mysql:tableStatus	ITSI Database
MySQL schema objects	DB Connect	mysql:instance:stats	ITSI Database
MySQL transactions	DB Connect	mysql:transaction:stats	ITSI Database
MySQL connections	DB Connect	mysql:connection:stats	ITSI Database
MySQL error log	DB Connect	mysql:errorLogDb	n/a
MySQL disk usage for all kinds of logs	DB Connect	mysql:diskUsageDb	n/a
MySQL summaries by stages	DB Connect	mysql:userSummaryByStages	n/a
Snapshot of which InnoDB locks transactions are waiting for	DB Connect	mysql:innodbLockWaits	n/a
MySQL global grants	DB Connect	mysql:globalGrants	n/a
MySQL events	DB Connect	mysql:events	n/a
MySQL loaded components	DB Connect	mysql:components	n/a
MySQL storage engines	DB Connect	mysql:engines	n/a