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

(limited to 'issues')

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