summaryrefslogtreecommitdiffstats
path: root/src/go/collectors/go.d.plugin/modules/proxysql/testdata
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-08-26 08:15:20 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-08-26 08:15:20 +0000
commit87d772a7d708fec12f48cd8adc0dedff6e1025da (patch)
tree1fee344c64cc3f43074a01981e21126c8482a522 /src/go/collectors/go.d.plugin/modules/proxysql/testdata
parentAdding upstream version 1.46.3. (diff)
downloadnetdata-87d772a7d708fec12f48cd8adc0dedff6e1025da.tar.xz
netdata-87d772a7d708fec12f48cd8adc0dedff6e1025da.zip
Adding upstream version 1.47.0.upstream/1.47.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'src/go/collectors/go.d.plugin/modules/proxysql/testdata')
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.json5
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.yaml3
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_memory_metrics.txt21
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_commands_counters.txt56
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_connection_pool .txt11
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_global.txt106
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_users.txt6
-rw-r--r--src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/version.txt5
8 files changed, 0 insertions, 213 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
deleted file mode 100644
index ed8b72dcb..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.json
+++ /dev/null
@@ -1,5 +0,0 @@
-{
- "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
deleted file mode 100644
index caff49039..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/config.yaml
+++ /dev/null
@@ -1,3 +0,0 @@
-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
deleted file mode 100644
index 99ec093e1..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_memory_metrics.txt
+++ /dev/null
@@ -1,21 +0,0 @@
-+------------------------------+----------------+
-| 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
deleted file mode 100644
index 6ab6bb830..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_commands_counters.txt
+++ /dev/null
@@ -1,56 +0,0 @@
-+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+---------+--------+---------+----------+
-| 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
deleted file mode 100644
index 80b53e1af..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_connection_pool .txt
+++ /dev/null
@@ -1,11 +0,0 @@
-+----+-------------------+--------+--------+----------+----------+--------+---------+---------+-----------------+-----------------+------------+
-| 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
deleted file mode 100644
index 442266c45..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_global.txt
+++ /dev/null
@@ -1,106 +0,0 @@
-+---------------------------------------------+----------------+
-| 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
deleted file mode 100644
index 900776b76..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/stats_mysql_users.txt
+++ /dev/null
@@ -1,6 +0,0 @@
-+-------------------------+----------------------+--------------------------+
-| 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
deleted file mode 100644
index 429a880b7..000000000
--- a/src/go/collectors/go.d.plugin/modules/proxysql/testdata/v2.0.10/version.txt
+++ /dev/null
@@ -1,5 +0,0 @@
-+---------------------+
-| version() |
-+---------------------+
-| 2.0.10-27-g5b319972 |
-+---------------------+ \ No newline at end of file
generated by cgit v1.2.3 (git 2.39.1) at 2024-09-19 09:38:02 +0000