[stable/2024.1] Tune database values (#1771)

This is an automated cherry-pick of #1744
/assign mnaser
diff --git a/roles/heat/vars/main.yml b/roles/heat/vars/main.yml
index 10202f3..b9f37b0 100644
--- a/roles/heat/vars/main.yml
+++ b/roles/heat/vars/main.yml
@@ -36,8 +36,10 @@
       clients_keystone:
         endpoint_type: publicURL
       database:
-        connection_recycle_time: 10
-        max_pool_size: 1
+        connection_recycle_time: 600
+        max_overflow: 50
+        max_pool_size: 5
+        pool_timeout: 30
       ec2authtoken:
         auth_uri: http://keystone-api.openstack.svc.cluster.local:5000
       heat_api: