Not the answer you need?
Register and ask your own question!

ProxySQL 2 always killing runnign queries after about 5min

hvardan71hvardan71 EntrantCurrent User Role Participant
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:
set mysql-default_query_timeou=1728000000;
set mysql-max_transaction_time=14400000;
set mysql-multiplexing='false';
Overall all variables with timeout:
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"
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       |
+---------------------------------------------------+------------+

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.