search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.03k stars 981 forks source link

Memory leak in 2.6.3 #4594

Open vladzu opened 3 months ago

vladzu commented 3 months ago

This is a follow up issue from https://github.com/sysown/proxysql/issues/4491

We have upgraded and running ProxySQL version ProxySQL version 2.6.3-107-gcdfcfdc, package used - proxysql_2.6.3-ubuntu20_amd64.deb. Before we used version 2.5.5 Distro we use: Ubuntu 20.04.6 LTS \n \l

We're having memory leak issues in all our proxysql instances. It was issue before with 2.5.5 and with current 2.6.3. Although we see that it is growing slower than with 2.5.5

Screenshot 2024-07-25 at 11 22 18

On the picture above you can see that after 06/11 when we performed upgrade to 2.6.3 memory usage was growing slower that with previous version

Our config: 

datadir="/mdata01/proxysql"
errorlog="/var/log/proxysql/proxysql.log"

admin_variables=
{
    admin_credentials="proxysql-admin:passwd"
    mysql_ifaces="0.0.0.0:6032;/tmp/proxysql-admin.sock"
    cluster_username="proxysql-admin"
    cluster_password="passwd"
    cluster_check_interval_ms=5000
    cluster_check_status_frequency=10
    cluster_mysql_query_rules_diffs_before_sync=3
    cluster_mysql_servers_diffs_before_sync=3
    cluster_mysql_users_diffs_before_sync=3
    cluster_proxysql_servers_diffs_before_sync=3
    restapi_enabled=true
    restapi_port=6080
}

mysql_variables=
{
    # General
    interfaces="0.0.0.0:6033"
    default_schema="information_schema"

    # Connection handling
    connect_timeout_server=3000
    connect_retries_on_failure=3
    connection_max_age_ms=10000
    default_charset="utf8mb4"
    default_collation_connection="utf8mb4_0900_ai_ci"
    max_connections=2000
    multiplexing=false
    poll_timeout=2000
    query_digests_keep_comment=false
    wait_timeout=181000

    # Internal pings and monitoring
    monitor_username="proxysql-monitor"
    monitor_password="passwd"
    monitor_connect_interval=20000
    monitor_ping_interval=10000
    monitor_read_only_interval=1000
    monitor_read_only_timeout=800
    monitor_replication_lag_interval=1000
    monitor_replication_lag_group_by_host=true
    monitor_writer_is_also_reader=false
    ping_interval_server_msec=10000
    ping_timeout_server=500

    # Queries handling
    enable_client_deprecate_eof=false
    enable_server_deprecate_eof=false
    query_retries_on_failure=0
    set_query_lock_on_hostgroup=true
    verbose_query_error=true
    hostgroup_manager_verbose=0
}

some stats:

mysql> select Variable_Name,Variable_Value/1024/1024 as Mem_usage_in_MB from stats_memory_metrics;
+-----------------------------------+-----------------+
| Variable_Name                     | Mem_usage_in_MB |
+-----------------------------------+-----------------+
| SQLite3_memory_bytes              | 780             |
| jemalloc_resident                 | 1214            |
| jemalloc_active                   | 954             |
| jemalloc_allocated                | 923             |
| jemalloc_mapped                   | 1297            |
| jemalloc_metadata                 | 37              |
| jemalloc_retained                 | 1373            |
| Auth_memory                       | 0               |
| query_digest_memory               | 0               |
| mysql_query_rules_memory          | 0               |
| prepare_statement_metadata_memory | 63              |
| prepare_statement_backend_memory  | 28              |
| mysql_firewall_users_table        | 0               |
| mysql_firewall_users_config       | 0               |
| mysql_firewall_rules_table        | 0               |
| mysql_firewall_rules_config       | 0               |
| stack_memory_mysql_threads        | 64              |
| stack_memory_admin_threads        | 24              |
| stack_memory_cluster_threads      | 16              |
+-----------------------------------+-----------------+
mysql> SELECT * FROM stats_mysql_global;
+----------------------------------------------+----------------+
| Variable_Name                                | Variable_Value |
+----------------------------------------------+----------------+
| ProxySQL_Uptime                              | 2942162        |
| Active_Transactions                          | 0              |
| Client_Connections_aborted                   | 0              |
| Client_Connections_connected                 | 59             |
| Client_Connections_created                   | 10324967       |
| Server_Connections_aborted                   | 0              |
| Server_Connections_connected                 | 79             |
| Server_Connections_created                   | 1392839        |
| Server_Connections_delayed                   | 0              |
| Client_Connections_non_idle                  | 57             |
| mysql_backend_buffers_bytes                  | 4107064        |
| mysql_frontend_buffers_bytes                 | 3866624        |
| mysql_session_internal_bytes                 | 327640         |
| Com_autocommit                               | 0              |
| Com_autocommit_filtered                      | 0              |
| Com_commit                                   | 1493284        |
| Com_commit_filtered                          | 2              |
| Com_rollback                                 | 8              |
| Com_rollback_filtered                        | 0              |
| Com_backend_change_user                      | 247760         |
| Com_backend_init_db                          | 324133         |
| Com_backend_set_names                        | 9442360        |
| Com_frontend_init_db                         | 0              |
| Com_frontend_set_names                       | 8305247        |
| Com_frontend_use_db                          | 17398479       |
| Com_backend_stmt_prepare                     | 20368423       |
| Com_backend_stmt_execute                     | 42614994       |
| Com_backend_stmt_close                       | 0              |
| Com_frontend_stmt_prepare                    | 42614995       |
| Com_frontend_stmt_execute                    | 42614995       |
| Com_frontend_stmt_close                      | 42611259       |
| Questions                                    | 248786244      |
| Slow_queries                                 | 10874          |
| GTID_consistent_queries                      | 0              |
| GTID_session_collected                       | 0              |
| Queries_backends_bytes_recv                  | 143933280524   |
| Queries_backends_bytes_sent                  | 318079824428   |
| Queries_frontends_bytes_recv                 | 336932725289   |
| Queries_frontends_bytes_sent                 | 547999272186   |
| Query_Processor_time_nsec                    | 0              |
| Backend_query_time_nsec                      | 0              |
| ConnPool_get_conn_latency_awareness          | 0              |
| ConnPool_get_conn_immediate                  | 125154         |
| ConnPool_get_conn_success                    | 10961578       |
| ConnPool_get_conn_failure                    | 0              |
| mysql_killed_backend_connections             | 0              |
| mysql_killed_backend_queries                 | 0              |
| hostgroup_locked_set_cmds                    | 0              |
| hostgroup_locked_queries                     | 0              |
| mysql_unexpected_frontend_com_quit           | 0              |
| mysql_unexpected_frontend_packets            | 0              |
| queries_with_max_lag_ms__total_wait_time_us  | 0              |
| queries_with_max_lag_ms__delayed             | 0              |
| queries_with_max_lag_ms                      | 0              |
| backend_lagging_during_query                 | 0              |
| backend_offline_during_query                 | 0              |
| get_aws_aurora_replicas_skipped_during_query | 0              |
| automatic_detected_sql_injection             | 0              |
| whitelisted_sqli_fingerprint                 | 0              |
| max_connect_timeouts                         | 0              |
| generated_error_packets                      | 0              |
| client_host_error_killed_connections         | 0              |
| Client_Connections_hostgroup_locked          | 0              |
| Mirror_concurrency                           | 0              |
| Mirror_queue_length                          | 0              |
| Selects_for_update__autocommit0              | 0              |
| Servers_table_version                        | 74372          |
| MySQL_Thread_Workers                         | 4              |
| Access_Denied_Wrong_Password                 | 0              |
| Access_Denied_Max_Connections                | 0              |
| Access_Denied_Max_User_Connections           | 0              |
| MySQL_Monitor_Workers                        | 2              |
| MySQL_Monitor_Workers_Aux                    | 0              |
| MySQL_Monitor_Workers_Started                | 2              |
| MySQL_Monitor_connect_check_OK               | 294170         |
| MySQL_Monitor_connect_check_ERR              | 0              |
| MySQL_Monitor_ping_check_OK                  | 588380         |
| MySQL_Monitor_ping_check_ERR                 | 0              |
| MySQL_Monitor_read_only_check_OK             | 5883728        |
| MySQL_Monitor_read_only_check_ERR            | 0              |
| MySQL_Monitor_replication_lag_check_OK       | 5883733        |
| MySQL_Monitor_replication_lag_check_ERR      | 1              |
| MySQL_Monitor_dns_cache_queried              | 0              |
| MySQL_Monitor_dns_cache_lookup_success       | 0              |
| MySQL_Monitor_dns_cache_record_updated       | 0              |
| MyHGM_myconnpoll_get                         | 10836424       |
| MyHGM_myconnpoll_get_ok                      | 10836424       |
| MyHGM_myconnpoll_push                        | 10935913       |
| MyHGM_myconnpoll_destroy                     | 281            |
| MyHGM_myconnpoll_reset                       | 10834215       |
| SQLite3_memory_bytes                         | 817943160      |
| ConnPool_memory_bytes                        | 1608656        |
| Stmt_Client_Active_Total                     | 0              |
| Stmt_Client_Active_Unique                    | 0              |
| Stmt_Server_Active_Total                     | 1476           |
| Stmt_Server_Active_Unique                    | 1380           |
| Stmt_Max_Stmt_id                             | 10002          |
| Stmt_Cached                                  | 4572           |
| 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              |
| new_req_conns_count                          | 0              |
| mysql_listener_paused                        | false          |
+----------------------------------------------+----------------+
mysql> SELECT * FROM global_variables WHERE variable_name NOT LIKE '%credentials%' AND variable_name NOT LIKE '%passwords%';
+----------------------------------------------------------------------+--------------------------------------------+
| variable_name                                                        | variable_value                             |
+----------------------------------------------------------------------+--------------------------------------------+
| admin-telnet_admin_ifaces                                            | (null)                                     |
| admin-telnet_stats_ifaces                                            | (null)                                     |
| admin-web_port                                                       | 6080                                       |
| admin-mysql_ifaces                                                   | 0.0.0.0:6032;/tmp/proxysql-admin.sock      |
| admin-restapi_port                                                   | 6080                                       |
| admin-checksum_admin_variables                                       | true                                       |
| admin-checksum_ldap_variables                                        | true                                       |
| admin-checksum_mysql_query_rules                                     | true                                       |
| admin-checksum_mysql_servers                                         | true                                       |
| admin-checksum_mysql_users                                           | true                                       |
| admin-checksum_mysql_variables                                       | true                                       |
| admin-cluster_admin_variables_diffs_before_sync                      | 3                                          |
| admin-cluster_admin_variables_save_to_disk                           | true                                       |
| admin-cluster_check_interval_ms                                      | 5000                                       |
| admin-cluster_check_status_frequency                                 | 10                                         |
| admin-cluster_ldap_variables_diffs_before_sync                       | 3                                          |
| admin-cluster_ldap_variables_save_to_disk                            | true                                       |
| admin-cluster_mysql_query_rules_diffs_before_sync                    | 3                                          |
| admin-cluster_mysql_query_rules_save_to_disk                         | true                                       |
| admin-cluster_mysql_servers_diffs_before_sync                        | 3                                          |
| admin-cluster_mysql_servers_save_to_disk                             | true                                       |
| admin-cluster_mysql_users_diffs_before_sync                          | 3                                          |
| admin-cluster_mysql_users_save_to_disk                               | true                                       |
| admin-cluster_mysql_variables_diffs_before_sync                      | 3                                          |
| admin-cluster_mysql_variables_save_to_disk                           | true                                       |
| admin-cluster_proxysql_servers_diffs_before_sync                     | 3                                          |
| admin-cluster_proxysql_servers_save_to_disk                          | true                                       |
| admin-cluster_username                                               | proxysql-admin                             |
| admin-coredump_generation_interval_ms                                | 30000                                      |
| admin-coredump_generation_threshold                                  | 10                                         |
| admin-prometheus_memory_metrics_interval                             | 61                                         |
| admin-read_only                                                      | false                                      |
| admin-refresh_interval                                               | 2000                                       |
| admin-restapi_enabled                                                | true                                       |
| admin-ssl_keylog_file                                                |                                            |
| admin-stats_mysql_connection_pool                                    | 60                                         |
| admin-stats_mysql_connections                                        | 60                                         |
| admin-stats_mysql_query_cache                                        | 60                                         |
| admin-stats_mysql_query_digest_to_disk                               | 0                                          |
| admin-stats_system_cpu                                               | 60                                         |
| admin-stats_system_memory                                            | 60                                         |
| admin-vacuum_stats                                                   | true                                       |
| admin-web_enabled                                                    | false                                      |
| admin-web_verbosity                                                  | 0                                          |
| admin-cluster_mysql_servers_sync_algorithm                           | 1                                          |
| admin-version                                                        | 2.6.3-107-gcdfcfdc                         |
| mysql-default_charset                                                | utf8mb4                                    |
| mysql-default_collation_connection                                   | utf8mb4_0900_ai_ci                         |
| mysql-shun_on_failures                                               | 5                                          |
| mysql-shun_recovery_time_sec                                         | 10                                         |
| mysql-unshun_algorithm                                               | 0                                          |
| mysql-query_retries_on_failure                                       | 0                                          |
| mysql-client_host_cache_size                                         | 0                                          |
| mysql-client_host_error_counts                                       | 0                                          |
| mysql-connect_retries_on_failure                                     | 3                                          |
| mysql-connect_retries_delay                                          | 1                                          |
| mysql-connection_delay_multiplex_ms                                  | 0                                          |
| mysql-connection_max_age_ms                                          | 10000                                      |
| mysql-connect_timeout_client                                         | 10000                                      |
| mysql-connect_timeout_server                                         | 3000                                       |
| mysql-connect_timeout_server_max                                     | 10000                                      |
| mysql-enable_client_deprecate_eof                                    | false                                      |
| mysql-enable_server_deprecate_eof                                    | false                                      |
| mysql-enable_load_data_local_infile                                  | false                                      |
| mysql-eventslog_filename                                             |                                            |
| mysql-eventslog_filesize                                             | 104857600                                  |
| mysql-eventslog_default_log                                          | 0                                          |
| mysql-eventslog_format                                               | 1                                          |
| mysql-auditlog_filename                                              |                                            |
| mysql-auditlog_filesize                                              | 104857600                                  |
| mysql-handle_unknown_charset                                         | 1                                          |
| mysql-free_connections_pct                                           | 10                                         |
| mysql-connection_warming                                             | false                                      |
| mysql-session_idle_ms                                                | 1                                          |
| mysql-have_ssl                                                       | false                                      |
| mysql-have_compress                                                  | true                                       |
| mysql-interfaces                                                     | 0.0.0.0:6033                               |
| mysql-log_mysql_warnings_enabled                                     | false                                      |
| mysql-monitor_enabled                                                | true                                       |
| mysql-monitor_history                                                | 600000                                     |
| mysql-monitor_connect_interval                                       | 20000                                      |
| mysql-monitor_connect_timeout                                        | 600                                        |
| mysql-monitor_ping_interval                                          | 10000                                      |
| mysql-monitor_ping_max_failures                                      | 3                                          |
| mysql-monitor_ping_timeout                                           | 1000                                       |
| mysql-monitor_aws_rds_topology_discovery_interval                    | 1000                                       |
| mysql-monitor_read_only_interval                                     | 1000                                       |
| mysql-monitor_read_only_timeout                                      | 800                                        |
| mysql-monitor_read_only_max_timeout_count                            | 3                                          |
| mysql-monitor_replication_lag_group_by_host                          | true                                       |
| mysql-monitor_replication_lag_interval                               | 1000                                       |
| mysql-monitor_replication_lag_timeout                                | 1000                                       |
| mysql-monitor_replication_lag_count                                  | 1                                          |
| mysql-monitor_groupreplication_healthcheck_interval                  | 5000                                       |
| mysql-monitor_groupreplication_healthcheck_timeout                   | 800                                        |
| mysql-monitor_groupreplication_healthcheck_max_timeout_count         | 3                                          |
| mysql-monitor_groupreplication_max_transactions_behind_count         | 3                                          |
| mysql-monitor_groupreplication_max_transactions_behind_for_read_only | 1                                          |
| mysql-monitor_galera_healthcheck_interval                            | 5000                                       |
| mysql-monitor_galera_healthcheck_timeout                             | 800                                        |
| mysql-monitor_galera_healthcheck_max_timeout_count                   | 3                                          |
| mysql-monitor_username                                               | proxysql-monitor                           |
| mysql-monitor_replication_lag_use_percona_heartbeat                  |                                            |
| mysql-monitor_query_interval                                         | 60000                                      |
| mysql-monitor_query_timeout                                          | 100                                        |
| mysql-monitor_slave_lag_when_null                                    | 60                                         |
| mysql-monitor_threads_min                                            | 8                                          |
| mysql-monitor_threads_max                                            | 128                                        |
| mysql-monitor_threads_queue_maxsize                                  | 128                                        |
| mysql-monitor_local_dns_cache_ttl                                    | 300000                                     |
| mysql-monitor_local_dns_cache_refresh_interval                       | 60000                                      |
| mysql-monitor_local_dns_resolver_queue_maxsize                       | 128                                        |
| mysql-monitor_wait_timeout                                           | true                                       |
| mysql-monitor_writer_is_also_reader                                  | false                                      |
| mysql-max_allowed_packet                                             | 67108864                                   |
| mysql-tcp_keepalive_time                                             | 0                                          |
| mysql-use_tcp_keepalive                                              | false                                      |
| mysql-automatic_detect_sqli                                          | false                                      |
| mysql-firewall_whitelist_enabled                                     | false                                      |
| mysql-firewall_whitelist_errormsg                                    | Firewall blocked this query                |
| mysql-throttle_connections_per_sec_to_hostgroup                      | 1000000                                    |
| mysql-max_transaction_idle_time                                      | 14400000                                   |
| mysql-max_transaction_time                                           | 14400000                                   |
| mysql-multiplexing                                                   | false                                      |
| mysql-log_unhealthy_connections                                      | true                                       |
| mysql-enforce_autocommit_on_reads                                    | false                                      |
| mysql-autocommit_false_not_reusable                                  | false                                      |
| mysql-autocommit_false_is_transaction                                | false                                      |
| mysql-verbose_query_error                                            | true                                       |
| mysql-hostgroup_manager_verbose                                      | 0                                          |
| mysql-binlog_reader_connect_retry_msec                               | 3000                                       |
| mysql-threshold_query_length                                         | 524288                                     |
| mysql-threshold_resultset_size                                       | 4194304                                    |
| mysql-query_digests_max_digest_length                                | 2048                                       |
| mysql-query_digests_max_query_length                                 | 65000                                      |
| mysql-query_digests_grouping_limit                                   | 3                                          |
| mysql-query_digests_groups_grouping_limit                            | 0                                          |
| mysql-query_rules_fast_routing_algorithm                             | 1                                          |
| mysql-wait_timeout                                                   | 181000                                     |
| mysql-throttle_max_bytes_per_second_to_client                        | 0                                          |
| mysql-throttle_ratio_server_to_client                                | 0                                          |
| mysql-max_connections                                                | 2000                                       |
| mysql-max_stmts_per_connection                                       | 20                                         |
| mysql-max_stmts_cache                                                | 10000                                      |
| mysql-mirror_max_concurrency                                         | 16                                         |
| mysql-mirror_max_queue_length                                        | 32000                                      |
| mysql-default_max_latency_ms                                         | 1000                                       |
| mysql-default_query_delay                                            | 0                                          |
| mysql-default_query_timeout                                          | 86400000                                   |
| mysql-query_processor_iterations                                     | 0                                          |
| mysql-query_processor_regex                                          | 1                                          |
| mysql-set_query_lock_on_hostgroup                                    | 0                                          |
| mysql-set_parser_algorithm                                           | 1                                          |
| mysql-reset_connection_algorithm                                     | 2                                          |
| mysql-auto_increment_delay_multiplex                                 | 5                                          |
| mysql-auto_increment_delay_multiplex_timeout_ms                      | 10000                                      |
| mysql-long_query_time                                                | 1000                                       |
| mysql-query_cache_size_MB                                            | 256                                        |
| mysql-query_cache_soft_ttl_pct                                       | 0                                          |
| mysql-query_cache_handle_warnings                                    | 0                                          |
| mysql-ping_interval_server_msec                                      | 10000                                      |
| mysql-ping_timeout_server                                            | 500                                        |
| mysql-default_schema                                                 | information_schema                         |
| mysql-poll_timeout                                                   | 2000                                       |
| mysql-poll_timeout_on_failure                                        | 100                                        |
| mysql-server_capabilities                                            | 569899                                     |
| mysql-server_version                                                 | 8.0.32                                     |
| mysql-keep_multiplexing_variables                                    | tx_isolation,transaction_isolation,version |
| mysql-default_authentication_plugin                                  | mysql_native_password                      |
| mysql-kill_backend_connection_when_disconnect                        | true                                       |
| mysql-client_session_track_gtid                                      | true                                       |
| mysql-sessions_sort                                                  | true                                       |
| mysql-session_idle_show_processlist                                  | true                                       |
| mysql-show_processlist_extended                                      | 0                                          |
| mysql-commands_stats                                                 | true                                       |
| mysql-query_digests                                                  | true                                       |
| mysql-query_digests_lowercase                                        | false                                      |
| mysql-query_digests_replace_null                                     | false                                      |
| mysql-query_digests_no_digits                                        | false                                      |
| mysql-query_digests_normalize_digest_text                            | false                                      |
| mysql-query_digests_track_hostname                                   | false                                      |
| mysql-query_digests_keep_comment                                     | false                                      |
| mysql-parse_failure_logs_digest                                      | false                                      |
| mysql-servers_stats                                                  | true                                       |
| mysql-default_reconnect                                              | true                                       |
| mysql-ssl_p2s_ca                                                     |                                            |
| mysql-ssl_p2s_capath                                                 |                                            |
| mysql-ssl_p2s_cert                                                   |                                            |
| mysql-ssl_p2s_key                                                    |                                            |
| mysql-ssl_p2s_cipher                                                 |                                            |
| mysql-ssl_p2s_crl                                                    |                                            |
| mysql-ssl_p2s_crlpath                                                |                                            |
| mysql-stacksize                                                      | 1048576                                    |
| mysql-threads                                                        | 4                                          |
| mysql-init_connect                                                   |                                            |
| mysql-ldap_user_variable                                             |                                            |
| mysql-add_ldap_user_comment                                          |                                            |
| mysql-default_session_track_gtids                                    | OFF                                        |
| mysql-connpoll_reset_queue_length                                    | 50                                         |
| mysql-min_num_servers_lantency_awareness                             | 1000                                       |
| mysql-aurora_max_lag_ms_only_read_from_replicas                      | 2                                          |
| mysql-stats_time_backend_query                                       | false                                      |
| mysql-stats_time_query_processor                                     | false                                      |
| mysql-query_cache_stores_empty_result                                | true                                       |
| mysql-data_packets_history_size                                      | 0                                          |
| mysql-handle_warnings                                                | 1                                          |
| mysql-evaluate_replication_lag_on_servers_load                       | 1                                          |
+----------------------------------------------------------------------+--------------------------------------------+
mysql> SELECT COUNT(*) FROM stats.stats_mysql_free_connections;
+----------+
| COUNT(*) |
+----------+
| 23       |
+----------+

mysql> SELECT COUNT(*) FROM stats_mysql_prepared_statements_info;
+----------+
| COUNT(*) |
+----------+
| 7575     |
+----------+

mysql>  SELECT COUNT(*) FROM stats_mysql_client_host_cache;
+----------+
| COUNT(*) |
+----------+
| 0        |
+----------+
2356 : stats.stats_mysql_prepared_statements_info
1200 : monitor.mysql_server_replication_lag_log
1200 : monitor.mysql_server_read_only_log
619 : stats.stats_mysql_query_digest_reset
619 : stats.stats_mysql_query_digest
375 : main.mysql_collations
211 : main.runtime_global_variables
211 : main.global_variables
174 : main.runtime_mysql_users
174 : main.mysql_users
120 : monitor.mysql_server_ping_log
108 : stats.stats_mysql_global
87 : stats.stats_mysql_users
68 : stats.stats_mysql_processlist
60 : monitor.mysql_server_connect_log
54 : stats.stats_mysql_commands_counters
32 : stats.stats_mysql_free_connections
19 : stats.stats_memory_metrics
14 : stats.stats_proxysql_servers_checksums
12 : main.runtime_mysql_query_rules_fast_routing
12 : main.mysql_query_rules_fast_routing
9 : stats.stats_mysql_connection_pool_reset
9 : stats.stats_mysql_connection_pool
9 : main.runtime_mysql_servers
9 : main.mysql_servers
7 : main.runtime_checksums_values
4 : main.runtime_mysql_replication_hostgroups
4 : main.mysql_replication_hostgroups
3 : stats.stats_mysql_errors_reset
3 : stats.stats_mysql_errors
2 : stats.stats_proxysql_servers_metrics
2 : stats.stats_proxysql_servers_clients_status
2 : main.runtime_proxysql_servers
2 : main.proxysql_servers
1 : stats.stats_mysql_query_rules
1 : stats.global_variables
1 : main.runtime_mysql_query_rules
1 : main.mysql_query_rules
renecannao commented 3 months ago

Hi @vladzu , can you please share the error log?

Thanks

vladzu commented 3 months ago

Hi, sure proxysql_log_26_07.tar.gz

Memory dump for 24h can be uploaded from here https://file.io/Ice2yZRhsXjK (link works for 2 weeks only)

vladzu commented 3 months ago

Hi, did you managed to download the memory dumps?

vladzu commented 2 months ago

Uploading again memory dump