Buy Percona ServicesBuy Now!

ProxySQL 2 always killing runnign queries after about 5min

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ProxySQL 2 always killing runnign queries after about 5min

    Hello, please help

    I have issue when runing a long executing queries using ProxySQL

    2019-09-13 19:23:58 MySQL_Session.cpp:108:kill_query_thread(): [WARNING] KILL CONNECTION 63244 on 10.240.26.2:3306
    This is only I change different from default values:
    Code:
    set mysql-default_query_timeou=1728000000;
    set mysql-max_transaction_time=14400000;
    set mysql-multiplexing='false';
    Overall all variables with timeout:
    Code:
    ProxySQLAdmin>show variables like "%time%";                                                  +----------------------------------------------------+------------+
    | Variable_name                                      | Value      |
    +----------------------------------------------------+------------+
    | mysql-shun_recovery_time_sec                       | 10         |
    | mysql-connect_timeout_server                       | 1000       |
    | mysql-connect_timeout_server_max                   | 10000      |
    | mysql-monitor_connect_timeout                      | 600        |
    | mysql-monitor_ping_timeout                         | 1000       |
    | mysql-monitor_read_only_timeout                    | 800        |
    | mysql-monitor_read_only_max_timeout_count          | 3          |
    | mysql-monitor_replication_lag_timeout              | 1000       |
    | mysql-monitor_groupreplication_healthcheck_timeout | 800        |
    | mysql-monitor_galera_healthcheck_timeout           | 800        |
    | mysql-monitor_galera_healthcheck_max_timeout_count | 3          |
    | mysql-monitor_query_timeout                        | 100        |
    | mysql-monitor_wait_timeout                         | true       |
    | mysql-max_transaction_time                         | 14400000   |
    | mysql-wait_timeout                                 | 28800000   |
    | mysql-default_query_timeout                        | 1728000000 |
    | mysql-long_query_time                              | 1000       |
    | mysql-ping_timeout_server                          | 200        |
    | mysql-poll_timeout                                 | 2000       |
    | mysql-poll_timeout_on_failure                      | 100        |
    | mysql-default_time_zone                            | SYSTEM     |
    | mysql-stats_time_backend_query                     | false      |
    | mysql-stats_time_query_processor                   | false      |
    +----------------------------------------------------+------------+
    And variables with "query"

    Code:
    ProxySQLAdmin>show variables like "%query%";
    +---------------------------------------------------+------------+
    | Variable_name                                     | Value      |
    +---------------------------------------------------+------------+
    | admin-stats_mysql_query_cache                     | 60         |
    | admin-cluster_mysql_query_rules_diffs_before_sync | 3          |
    | admin-cluster_mysql_query_rules_save_to_disk      | true       |
    | admin-checksum_mysql_query_rules                  | true       |
    | mysql-query_retries_on_failure                    | 1          |
    | mysql-monitor_query_interval                      | 60000      |
    | mysql-monitor_query_timeout                       | 100        |
    | mysql-verbose_query_error                         | false      |
    | mysql-threshold_query_length                      | 524288     |
    | mysql-query_digests_max_digest_length             | 2048       |
    | mysql-query_digests_max_query_length              | 65000      |
    | mysql-default_query_delay                         | 0          |
    | mysql-default_query_timeout                       | 1728000000 |
    | mysql-query_processor_iterations                  | 0          |
    | mysql-query_processor_regex                       | 1          |
    | mysql-set_query_lock_on_hostgroup                 | 1          |
    | mysql-long_query_time                             | 1000       |
    | mysql-query_cache_size_MB                         | 256        |
    | mysql-query_digests                               | true       |
    | mysql-query_digests_lowercase                     | false      |
    | mysql-query_digests_replace_null                  | false      |
    | mysql-query_digests_normalize_digest_text         | false      |
    | mysql-query_digests_track_hostname                | false      |
    | mysql-stats_time_backend_query                    | false      |
    | mysql-stats_time_query_processor                  | false      |
    | mysql-query_cache_stores_empty_result             | true       |
    +---------------------------------------------------+------------+
Working...
X