diff options
Diffstat (limited to '')
8 files changed, 213 insertions, 0 deletions
diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.json b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.json new file mode 100644 index 000000000..ed8b72dcb --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.json @@ -0,0 +1,5 @@ +{ + "update_every": 123, + "dsn": "ok", + "timeout": 123.123 +} diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.yaml b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.yaml new file mode 100644 index 000000000..caff49039 --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.yaml @@ -0,0 +1,3 @@ +update_every: 123 +dsn: "ok" +timeout: 123.123 diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_memory_metrics.txt b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_memory_metrics.txt new file mode 100644 index 000000000..99ec093e1 --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_memory_metrics.txt @@ -0,0 +1,21 @@ ++------------------------------+----------------+ +| Variable_Name | Variable_Value | ++------------------------------+----------------+ +| SQLite3_memory_bytes | 6017144 | +| jemalloc_resident | 403759104 | +| jemalloc_active | 385101824 | +| jemalloc_allocated | 379402432 | +| jemalloc_mapped | 430993408 | +| jemalloc_metadata | 17418872 | +| jemalloc_retained | 260542464 | +| Auth_memory | 1044 | +| query_digest_memory | 13688 | +| mysql_query_rules_memory | 22825 | +| mysql_firewall_users_table | 0 | +| mysql_firewall_users_config | 0 | +| mysql_firewall_rules_table | 0 | +| mysql_firewall_rules_config | 329 | +| stack_memory_mysql_threads | 33554432 | +| stack_memory_admin_threads | 16777216 | +| stack_memory_cluster_threads | 0 | ++------------------------------+----------------+
\ No newline at end of file diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_commands_counters.txt b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_commands_counters.txt new file mode 100644 index 000000000..6ab6bb830 --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_commands_counters.txt @@ -0,0 +1,56 @@ ++-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+---------+--------+---------+----------+ +| Command | Total_Time_us | Total_cnt | cnt_100us | cnt_500us | cnt_1ms | cnt_5ms | cnt_10ms | cnt_50ms | cnt_100ms | cnt_500ms | cnt_1s | cnt_5s | cnt_10s | cnt_INFs | ++-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+---------+--------+---------+----------+ +| ALTER_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| ALTER_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| ANALYZE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| BEGIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CALL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CHANGE_MASTER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| COMMIT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_DATABASE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_INDEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_TEMPORARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_TRIGGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_USER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| CREATE_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DEALLOCATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DELETE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DESCRIBE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DROP_DATABASE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DROP_INDEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DROP_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DROP_TRIGGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DROP_USER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| DROP_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| GRANT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| EXECUTE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| EXPLAIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| FLUSH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| INSERT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| KILL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| LOAD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| LOCK_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| OPTIMIZE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| PREPARE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| PURGE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| RENAME_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| RESET_MASTER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| RESET_SLAVE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| REPLACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| REVOKE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| ROLLBACK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| SAVEPOINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| SELECT | 4673958076637 | 68490650 | 32185976 | 36650 | 481335 | 4600948 | 2955830 | 10468460 | 4909816 | 11123900 | 1321917 | 403451 | 497 | 1870 | +| SELECT_FOR_UPDATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| SHOW_TABLE_STATUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| START_TRANSACTION | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| TRUNCATE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| UNLOCK_TABLES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| UPDATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| USE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| SHOW | 2158 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | +| UNKNOWN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ++-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+---------+--------+---------+----------+ diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_connection_pool .txt b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_connection_pool .txt new file mode 100644 index 000000000..80b53e1af --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_connection_pool .txt @@ -0,0 +1,11 @@ ++----+-------------------+--------+--------+----------+----------+--------+---------+---------+-----------------+-----------------+------------+ +| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | Queries | Bytes_data_sent | Bytes_data_recv | Latency_us | ++-----------+-------------------+----------+--------+----------+----------+--------+---------+---------+-----------------+-----------------+------------+ +| 10 | back001-db-master | 6001 | ONLINE | 69 | 423 | 524 | 0 | 8970367 | 9858463664 | 145193069937 | 17684 | +| 11 | back001-db-master | 6002 | ONLINE | 0 | 1 | 1 | 0 | 69 | 187675 | 2903 | 17684 | +| 11 | back001-db-reader | 6003 | ONLINE | 0 | 11 | 11 | 0 | 63488 | 163690013 | 4994101 | 113 | +| 20 | back002-db-master | 6004 | ONLINE | 9 | 188 | 197 | 2 | 849461 | 1086994186 | 266034339 | 101981 | +| 21 | back002-db-reader | 6005 | ONLINE | 0 | 1 | 1 | 0 | 8 | 6992 | 984 | 230 | +| 31 | back003-db-master | 6006 | ONLINE | 0 | 3 | 3 | 0 | 3276 | 712803 | 81438709 | 231 | +| 31 | back003-db-reader | 6007 | ONLINE | 1 | 70 | 71 | 0 | 2356904 | 411900849 | 115810708275 | 230 | ++-----------+-------------------+--------+--------+----------+----------+--------+---------+---------+-----------------+-----------------+--------------+
\ No newline at end of file diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_global.txt b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_global.txt new file mode 100644 index 000000000..442266c45 --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_global.txt @@ -0,0 +1,106 @@ ++---------------------------------------------+----------------+ +| Variable_Name | Variable_Value | ++---------------------------------------------+----------------+ +| ProxySQL_Uptime | 26748286 | +| Active_Transactions | 0 | +| Client_Connections_aborted | 2 | +| Client_Connections_connected | 3 | +| Client_Connections_created | 5458991 | +| Server_Connections_aborted | 9979 | +| Server_Connections_connected | 13 | +| Server_Connections_created | 2122254 | +| Server_Connections_delayed | 0 | +| Client_Connections_non_idle | 3 | +| Queries_backends_bytes_recv | 5896210168 | +| Queries_backends_bytes_sent | 4329581500 | +| Queries_frontends_bytes_recv | 7434816962 | +| Queries_frontends_bytes_sent | 11643634097 | +| Query_Processor_time_nsec | 0 | +| Backend_query_time_nsec | 0 | +| mysql_backend_buffers_bytes | 0 | +| mysql_frontend_buffers_bytes | 196608 | +| mysql_session_internal_bytes | 20232 | +| Com_autocommit | 0 | +| Com_autocommit_filtered | 0 | +| Com_commit | 0 | +| Com_commit_filtered | 0 | +| Com_rollback | 0 | +| Com_rollback_filtered | 0 | +| Com_backend_change_user | 188694 | +| Com_backend_init_db | 0 | +| Com_backend_set_names | 1517893 | +| Com_frontend_init_db | 2 | +| Com_frontend_set_names | 0 | +| Com_frontend_use_db | 0 | +| Com_backend_stmt_prepare | 16858208 | +| Com_backend_stmt_execute | 36303146 | +| Com_backend_stmt_close | 0 | +| Com_frontend_stmt_prepare | 32185987 | +| Com_frontend_stmt_execute | 36314138 | +| Com_frontend_stmt_close | 32137933 | +| Mirror_concurrency | 0 | +| Mirror_queue_length | 0 | +| Questions | 100638067 | +| Selects_for_update__autocommit0 | 0 | +| Slow_queries | 405818 | +| GTID_consistent_queries | 0 | +| GTID_session_collected | 0 | +| Servers_table_version | 37 | +| MySQL_Thread_Workers | 4 | +| Access_Denied_Wrong_Password | 2 | +| Access_Denied_Max_Connections | 0 | +| Access_Denied_Max_User_Connections | 0 | +| MySQL_Monitor_Workers | 10 | +| MySQL_Monitor_Workers_Aux | 0 | +| MySQL_Monitor_Workers_Started | 10 | +| MySQL_Monitor_connect_check_OK | 3548306 | +| MySQL_Monitor_connect_check_ERR | 130 | +| MySQL_Monitor_ping_check_OK | 21289849 | +| MySQL_Monitor_ping_check_ERR | 108271 | +| MySQL_Monitor_read_only_check_OK | 106246409 | +| MySQL_Monitor_read_only_check_ERR | 19610 | +| MySQL_Monitor_replication_lag_check_OK | 28702388 | +| MySQL_Monitor_replication_lag_check_ERR | 482 | +| ConnPool_get_conn_latency_awareness | 0 | +| ConnPool_get_conn_immediate | 13361 | +| ConnPool_get_conn_success | 36319474 | +| ConnPool_get_conn_failure | 212943 | +| generated_error_packets | 231 | +| max_connect_timeouts | 227 | +| backend_lagging_during_query | 8880 | +| backend_offline_during_query | 8 | +| queries_with_max_lag_ms | 0 | +| queries_with_max_lag_ms__delayed | 0 | +| queries_with_max_lag_ms__total_wait_time_us | 0 | +| mysql_unexpected_frontend_com_quit | 0 | +| Client_Connections_hostgroup_locked | 0 | +| hostgroup_locked_set_cmds | 0 | +| hostgroup_locked_queries | 0 | +| mysql_unexpected_frontend_packets | 0 | +| aws_aurora_replicas_skipped_during_query | 0 | +| automatic_detected_sql_injection | 0 | +| whitelisted_sqli_fingerprint | 0 | +| mysql_killed_backend_connections | 0 | +| mysql_killed_backend_queries | 0 | +| MyHGM_myconnpoll_get | 36519056 | +| MyHGM_myconnpoll_get_ok | 36306113 | +| MyHGM_myconnpoll_push | 37358734 | +| MyHGM_myconnpoll_destroy | 15150 | +| MyHGM_myconnpoll_reset | 2 | +| SQLite3_memory_bytes | 6021248 | +| ConnPool_memory_bytes | 932248 | +| Stmt_Client_Active_Total | 18 | +| Stmt_Client_Active_Unique | 18 | +| Stmt_Server_Active_Total | 101 | +| Stmt_Server_Active_Unique | 39 | +| Stmt_Max_Stmt_id | 66 | +| Stmt_Cached | 65 | +| Query_Cache_Memory_bytes | 0 | +| Query_Cache_count_GET | 0 | +| Query_Cache_count_GET_OK | 0 | +| Query_Cache_count_SET | 0 | +| Query_Cache_bytes_IN | 0 | +| Query_Cache_bytes_OUT | 0 | +| Query_Cache_Purged | 0 | +| Query_Cache_Entries | 0 | ++---------------------------------------------+----------------+ diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_users.txt b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_users.txt new file mode 100644 index 000000000..900776b76 --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_users.txt @@ -0,0 +1,6 @@ ++-------------------------+----------------------+--------------------------+ +| username | frontend_connections | frontend_max_connections | ++-------------------------+----------------------+--------------------------+ +| first_user | 0 | 200 | +| second_user | 3 | 15 | ++-------------------------+----------------------+--------------------------+ diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/version.txt b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/version.txt new file mode 100644 index 000000000..429a880b7 --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/version.txt @@ -0,0 +1,5 @@ ++---------------------+ +| version() | ++---------------------+ +| 2.0.10-27-g5b319972 | ++---------------------+
\ No newline at end of file |