[stable/2023.1] Tune database values (#1773)

This is an automated cherry-pick of #1744
/assign mnaser
diff --git a/roles/keystone/vars/main.yml b/roles/keystone/vars/main.yml
index f40d858..df86c62 100644
--- a/roles/keystone/vars/main.yml
+++ b/roles/keystone/vars/main.yml
@@ -39,8 +39,10 @@
       cors:
         allowed_origins: "*"
       database:
-        connection_recycle_time: 10
-        max_pool_size: 1
+        connection_recycle_time: 600
+        max_overflow: 50
+        max_pool_size: 5
+        pool_timeout: 30
       openid:
         remote_id_attribute: HTTP_OIDC_ISS
       federation: