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

This is an automated cherry-pick of #1744
/assign mnaser
diff --git a/roles/cinder/vars/main.yml b/roles/cinder/vars/main.yml
index dc9aa4d..4917bd9 100644
--- a/roles/cinder/vars/main.yml
+++ b/roles/cinder/vars/main.yml
@@ -46,8 +46,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
       oslo_messaging_notifications:
         driver: noop
   manifests: