# ProxySQL 2 always killing runnign queries after about 5min

**URL:** <https://forums.percona.com/t/proxysql-2-always-killing-runnign-queries-after-about-5min/7199>\
**Category:** Other Tools\
**Created:** [September 13, 2019, 2:04pm UTC](https://forums.percona.com/t/proxysql-2-always-killing-runnign-queries-after-about-5min/7199 "2019-09-13T14:04:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hvardan71](https://avatars.discourse-cdn.com/v4/letter/h/7ba0ec/32.png) [@hvardan71](https://forums.percona.com/u/hvardan71)\
**Post date:** [September 13, 2019, 2:04pm UTC](https://forums.percona.com/t/proxysql-2-always-killing-runnign-queries-after-about-5min/7199/1 "2019-09-13T14:04:40Z")

</div>

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:

```auto
set mysql-default_query_timeou=1728000000;
set mysql-max_transaction_time=14400000;
set mysql-multiplexing='false';

```

Overall all variables with timeout:

```auto

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”

```auto
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 |
+---------------------------------------------------+------------+

```

---

<div class="post-metadata">

**Author:** ![hvardan71](https://avatars.discourse-cdn.com/v4/letter/h/7ba0ec/32.png) [@hvardan71](https://forums.percona.com/u/hvardan71)\
**Post date:** [September 29, 2019, 5:03pm UTC](https://forums.percona.com/t/proxysql-2-always-killing-runnign-queries-after-about-5min/7199/2 "2019-09-29T17:03:33Z")

</div>

Please, any one can help me?