From 59f470f942d6bab9bc357d8c7fda73b580e4054f Mon Sep 17 00:00:00 2001 From: Frederick Muriuki Muriithi Date: Wed, 23 Mar 2022 09:57:05 +0300 Subject: Add `global search connection` Issue from GitHub --- issues/global-search-connection-slow.gmi | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 issues/global-search-connection-slow.gmi diff --git a/issues/global-search-connection-slow.gmi b/issues/global-search-connection-slow.gmi new file mode 100644 index 0000000..80a56ee --- /dev/null +++ b/issues/global-search-connection-slow.gmi @@ -0,0 +1,24 @@ +# Global search does not close connections properly (and is slow) + +## Tags + +* type: bug +* priority: medium +* status: stalled +* assigned: Uditgulati +* keywords: global search, db connections, medium priority, from github + +## Description + +=> https://github.com/genenetwork/genenetwork2/issues/418 From GitHub + +Global search '*' causes loads of aborted connections... I mean + +``` + 2020-08-15 2:53:58 140273206434560 [Warning] Aborted connection 45219 to db: 'db_webqtl' user: 'webqtlout' host: '127.0.0.1' (CLOSE_CONNECTION) +``` + +generating 6Mb of log file info. + + +In fact, every row in the table has a SQL query that does not close the connection properly. -- cgit v1.2.3