wsm12138 commented on issue #11167:
URL:
https://github.com/apache/shardingsphere/issues/11167#issuecomment-927223981
| mysqld_exporter收集项 | DB执行sql语句
| | |
| ------------------------------------------------ |
------------------------------------------------------------ | ---- | ---- |
| binlog | logbinQuery = `SELECT
@@log_bin` binlogQuery = `SHOW BINARY LOGS` | | |
| collector | userstatCheckQuery =
`SHOW GLOBAL VARIABLES WHERE Variable_Name='userstat' OR
Variable_Name='userstat_running'` | | |
| engine_innodb | engineInnodbStatusQuery
= `SHOW ENGINE INNODB STATUS` | | |
| engine_tokudb | engineTokudbStatusQuery
= `SHOW ENGINE TOKUDB STATUS` | | |
| exporter | sessionSettingsParam =
`log_slow_filter=%27tmp_table_on_disk,filesort_on_disk%27` timeoutParam =
`lock_wait_timeout=%d` | | |
| global_status | globalStatusQuery =
`SHOW GLOBAL STATUS` | | |
| global_variables | globalVariablesQuery =
`SHOW GLOBAL VARIABLES` | | |
| heartbeat | heartbeatQuery =
"SELECT UNIX_TIMESTAMP(ts), UNIX_TIMESTAMP(%s), server_id from `%s`.`%s`" |
| |
| info_schema |
| | |
| info_schema_auto_increment |
infoSchemaAutoIncrementQuery = ` SELECT table_schema, table_name, column_name,
auto_increment, pow(2, case data_type when 'tinyint' then 7 when
'smallint' then 15 when 'mediumint' then 23 when 'int' then 31 when
'bigint' then 63 end+(column_type like '% unsigned'))-1 as max_int FROM
information_schema.tables t JOIN information_schema.columns c USING
(table_schema,table_name) WHERE c.extra = 'auto_increment' AND
t.auto_increment IS NOT NULL ` | | |
| info_schema_clientstats | clientStatQuery =
`SELECT * FROM information_schema.client_statistics` | | |
| info_schema_innodb_cmp | innodbCmpQuery = `
SELECT page_size, compress_ops, compress_ops_ok, compress_time,
uncompress_ops, uncompress_time FROM information_schema.innodb_cmp ` |
| |
| info_schema_innodb_cmpmem | innodbCmpMemQuery = `
SELECT page_size, buffer_pool_instance, pages_used, pages_free,
relocation_ops, relocation_time FROM information_schema.innodb_cmpmem
` | | |
| info_schema_innodb_metrics |
infoSchemaInnodbMetricsEnabledColumnQuery = ` SELECT column_name FROM
information_schema.columns WHERE table_name = 'INNODB_METRICS' AND
column_name IN ('status', 'enabled') ` | | |
| info_schema_innodb_sys_tablespaces |
innodbTablespacesTablenameQuery = ` SELECT table_name FROM
information_schema.tables WHERE table_name = 'INNODB_SYS_TABLESPACES' OR
table_name = 'INNODB_TABLESPACES' ` | | |
| info_schema_processlist |
infoSchemaProcesslistQuery = ` SELECT user, SUBSTRING_INDEX(host, ':',
1) AS host, COALESCE(command,'') AS command, COALESCE(state,'') AS state,
count(*) AS processes, sum(time) AS seconds FROM
information_schema.processlist WHERE ID != connection_id() AND TIME >= %d
GROUP BY user,SUBSTRING_INDEX(host, ':', 1),command,state ORDER BY null ` |
| |
| info_schema_query_response_time | queryResponseCheckQuery
= `SELECT @@query_response_time_stats` | | |
| info_schema_replica_host | replicaHostQuery = `
SELECT SERVER_ID , if(SESSION_ID='MASTER_SESSION_ID','writer','reader') AS
ROLE , CPU , MASTER_SLAVE_LATENCY_IN_MICROSECONDS ,
REPLICA_LAG_IN_MILLISECONDS , LOG_STREAM_SPEED_IN_KiB_PER_SECOND ,
CURRENT_REPLAY_LATENCY_IN_MICROSECONDS FROM
information_schema.replica_host_status ` | | |
| info_schema_schemastats | schemaStatQuery = `
SELECT TABLE_SCHEMA, SUM(ROWS_READ) AS ROWS_READ, SUM(ROWS_CHANGED) AS
ROWS_CHANGED, SUM(ROWS_CHANGED_X_INDEXES) AS ROWS_CHANGED_X_INDEXES FROM
information_schema.TABLE_STATISTICS GROUP BY TABLE_SCHEMA; ` | | |
| info_schema_tables | tableSchemaQuery = `
SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE, ifnull(ENGINE, 'NONE')
as ENGINE, ifnull(VERSION, '0') as VERSION, ifnull(ROW_FORMAT, 'NONE') as
ROW_FORMAT, ifnull(TABLE_ROWS, '0') as TABLE_ROWS, ifnull(DATA_LENGTH,
'0') as DATA_LENGTH, ifnull(INDEX_LENGTH, '0') as INDEX_LENGTH,
ifnull(DATA_FREE, '0') as DATA_FREE, ifnull(CREATE_OPTIONS, 'NONE') as
CREATE_OPTIONS FROM information_schema.tables WHERE TABLE_SCHEMA = '%s' `
dbListQuery = ` SELECT SCHEMA_NAME FROM information_schema.schemata
WHERE SCHEMA_NAME NOT IN ('mysql', 'performance_schema', 'information_schema')
` | | |
| info_schema_tablestats | tableStatQuery = `
SELECT TABLE_SCHEMA, TABLE_NAME, ROWS_READ, ROWS_CHANGED,
ROWS_CHANGED_X_INDEXES FROM information_schema.table_statistics ` | |
|
| info_schema_userstats | userStatQuery = `SELECT
* FROM information_schema.user_statistics` | | |
| mysql |
| | |
| mysql_user | mysqlUserQuery = `
SELECT user, host, Select_priv, Insert_priv, Update_priv,
Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv,
Process_priv, File_priv, Grant_priv, References_priv, Index_priv,
Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv,
Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv,
Create_view_priv, Show_view_priv, Create_routine_priv,
Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv,
Create_tablespace_priv, max_questions, max_updates, max_connections,
max_user_connections FROM mysql.user ` | | |
| perf_schema |
| | |
| perf_schema_events_statements |
perfEventsStatementsQuery = ` SELECT ifnull(SCHEMA_NAME, 'NONE') as
SCHEMA_NAME, DIGEST, LEFT(DIGEST_TEXT, %d) as DIGEST_TEXT, COUNT_STAR,
SUM_TIMER_WAIT, SUM_ERRORS, SUM_WARNINGS, SUM_ROWS_AFFECTED,
SUM_ROWS_SENT, SUM_ROWS_EXAMINED, SUM_CREATED_TMP_DISK_TABLES,
SUM_CREATED_TMP_TABLES, SUM_SORT_MERGE_PASSES, SUM_SORT_ROWS,
SUM_NO_INDEX_USED FROM ( SELECT * FROM
performance_schema.events_statements_summary_by_digest WHERE SCHEMA_NAME NOT
IN ('mysql', 'performance_schema', 'information_schema') AND LAST_SEEN >
DATE_SUB(NOW(), INTERVAL %d SECOND) ORDER BY LAST_SEEN DESC )Q GROUP BY
Q.SCHEMA_NAME, Q.DIGEST, Q.DIGEST_TEXT, Q.COUNT_STAR,
Q.SUM_TIMER_WAIT, Q.SUM_ERRORS, Q.SUM_WARNINGS, Q.SUM_ROWS_AFFECTED,
Q.SUM_ROWS_SENT, Q.SUM_ROWS_EXAMINED, Q.SUM_CREATED_TMP_DISK_TABLES,
Q.SUM_CREATED_TMP_TABLES, Q.SUM_SORT_MERGE_PASSES, Q.S
UM_SORT_ROWS, Q.SUM_NO_INDEX_USED ORDER BY SUM_TIMER_WAIT DESC LIMIT %d
` | | |
| perf_schema_events_statements_sum |
perfEventsStatementsSumQuery = ` SELECT SUM(COUNT_STAR) AS SUM_COUNT_STAR,
SUM(SUM_CREATED_TMP_DISK_TABLES) AS SUM_SUM_CREATED_TMP_DISK_TABLES,
SUM(SUM_CREATED_TMP_TABLES) AS SUM_SUM_CREATED_TMP_TABLES, SUM(SUM_ERRORS) AS
SUM_SUM_ERRORS, SUM(SUM_LOCK_TIME) AS SUM_SUM_LOCK_TIME,
SUM(SUM_NO_GOOD_INDEX_USED) AS SUM_SUM_NO_GOOD_INDEX_USED,
SUM(SUM_NO_INDEX_USED) AS SUM_SUM_NO_INDEX_USED, SUM(SUM_ROWS_AFFECTED) AS
SUM_SUM_ROWS_AFFECTED, SUM(SUM_ROWS_EXAMINED) AS SUM_SUM_ROWS_EXAMINED,
SUM(SUM_ROWS_SENT) AS SUM_SUM_ROWS_SENT, SUM(SUM_SELECT_FULL_JOIN) AS
SUM_SUM_SELECT_FULL_JOIN, SUM(SUM_SELECT_FULL_RANGE_JOIN) AS
SUM_SUM_SELECT_FULL_RANGE_JOIN, SUM(SUM_SELECT_RANGE) AS SUM_SUM_SELECT_RANGE,
SUM(SUM_SELECT_RANGE_CHECK) AS SUM_SUM_SELECT_RANGE_CHECK,
SUM(SUM_SELECT_SCAN) AS SUM_SUM_SELECT_SCAN, SUM(SUM_SORT_MERGE_PASSES) AS
SUM_SUM_SORT_MERGE_PASSES, SUM(SUM_SORT_RANGE) AS SUM_SUM_SORT_RANGE,
SUM(SUM_SORT_ROWS) AS SU
M_SUM_SORT_ROWS, SUM(SUM_SORT_SCAN) AS SUM_SUM_SORT_SCAN,
SUM(SUM_TIMER_WAIT) AS SUM_SUM_TIMER_WAIT, SUM(SUM_WARNINGS) AS
SUM_SUM_WARNINGS FROM performance_schema.events_statements_summary_by_digest;
` | | |
| perf_schema_events_waits | perfEventsWaitsQuery =
` SELECT EVENT_NAME, COUNT_STAR, SUM_TIMER_WAIT FROM
performance_schema.events_waits_summary_global_by_event_name ` | | |
| perf_schema_file_events | perfFileEventsQuery = `
SELECT EVENT_NAME, COUNT_READ, SUM_TIMER_READ, SUM_NUMBER_OF_BYTES_READ,
COUNT_WRITE, SUM_TIMER_WRITE, SUM_NUMBER_OF_BYTES_WRITE, COUNT_MISC,
SUM_TIMER_MISC FROM performance_schema.file_summary_by_event_name ` | |
|
| perf_schema_file_instances | perfFileInstancesQuery
= ` SELECT FILE_NAME, EVENT_NAME, COUNT_READ, COUNT_WRITE,
SUM_NUMBER_OF_BYTES_READ, SUM_NUMBER_OF_BYTES_WRITE FROM
performance_schema.file_summary_by_instance where FILE_NAME REGEXP ? ` |
| |
| perf_schema_index_io_waits | perfIndexIOWaitsQuery =
` SELECT OBJECT_SCHEMA, OBJECT_NAME, ifnull(INDEX_NAME, 'NONE') as INDEX_NAME,
COUNT_FETCH, COUNT_INSERT, COUNT_UPDATE, COUNT_DELETE, SUM_TIMER_FETCH,
SUM_TIMER_INSERT, SUM_TIMER_UPDATE, SUM_TIMER_DELETE FROM
performance_schema.table_io_waits_summary_by_index_usage WHERE OBJECT_SCHEMA
NOT IN ('mysql', 'performance_schema') ` | | |
| perf_schema_memory_events | perfMemoryEventsQuery =
` SELECT EVENT_NAME, SUM_NUMBER_OF_BYTES_ALLOC, SUM_NUMBER_OF_BYTES_FREE,
CURRENT_NUMBER_OF_BYTES_USED FROM
performance_schema.memory_summary_global_by_event_name where COUNT_ALLOC > 0;
` | | |
| perf_schema_replication_applier_status_by_worker |
perfReplicationApplierStatsByWorkerQuery = ` SELECT CHANNEL_NAME,
WORKER_ID, LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP,
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP,
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP,
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP,
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP,
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP,
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP FROM
performance_schema.replication_applier_status_by_worker ` | | |
| perf_schema_replication_group_member_stats |
perfReplicationGroupMemberStatsQuery = ` SELECT * FROM
performance_schema.replication_group_member_stats WHERE MEMBER_ID=@@server_uuid
` | | |
| perf_schema_replication_group_members |
perfReplicationGroupMembersQuery = ` SELECT * FROM
performance_schema.replication_group_members ` | | |
| perf_schema_table_io_waits | perfTableIOWaitsQuery =
` SELECT OBJECT_SCHEMA, OBJECT_NAME, COUNT_FETCH, COUNT_INSERT,
COUNT_UPDATE, COUNT_DELETE, SUM_TIMER_FETCH, SUM_TIMER_INSERT,
SUM_TIMER_UPDATE, SUM_TIMER_DELETE FROM
performance_schema.table_io_waits_summary_by_table WHERE OBJECT_SCHEMA NOT IN
('mysql', 'performance_schema') ` | | |
| perf_schema_table_lock_waits | perfTableLockWaitsQuery
= ` SELECT OBJECT_SCHEMA, OBJECT_NAME, COUNT_READ_NORMAL,
COUNT_READ_WITH_SHARED_LOCKS, COUNT_READ_HIGH_PRIORITY,
COUNT_READ_NO_INSERT, COUNT_READ_EXTERNAL, COUNT_WRITE_ALLOW_WRITE,
COUNT_WRITE_CONCURRENT_INSERT, COUNT_WRITE_LOW_PRIORITY,
COUNT_WRITE_NORMAL, COUNT_WRITE_EXTERNAL, SUM_TIMER_READ_NORMAL,
SUM_TIMER_READ_WITH_SHARED_LOCKS, SUM_TIMER_READ_HIGH_PRIORITY,
SUM_TIMER_READ_NO_INSERT, SUM_TIMER_READ_EXTERNAL,
SUM_TIMER_WRITE_ALLOW_WRITE, SUM_TIMER_WRITE_CONCURRENT_INSERT,
SUM_TIMER_WRITE_LOW_PRIORITY, SUM_TIMER_WRITE_NORMAL,
SUM_TIMER_WRITE_EXTERNAL FROM
performance_schema.table_lock_waits_summary_by_table WHERE OBJECT_SCHEMA NOT
IN ('mysql', 'performance_schema', 'information_schema') ` | | |
| scraper |
| | |
| slave_hosts | slaveHostsQuery = "SHOW
SLAVE HOSTS" | | |
| slave_status |
slaveStatusQueries="SHOW ALL SLAVES STATUS" | | |
The data
source：https://github.com/prometheus/mysqld_exporter/tree/master/collector
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
