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

This is an automated cherry-pick of #1744
/assign mnaser
diff --git a/roles/nova/vars/main.yml b/roles/nova/vars/main.yml
index 42ffe9f..ca4d3e0 100644
--- a/roles/nova/vars/main.yml
+++ b/roles/nova/vars/main.yml
@@ -73,8 +73,10 @@
         allowed_origin: "*"
         allow_headers: "X-Auth-Token,X-OpenStack-Nova-API-Version"
       database:
-        connection_recycle_time: 10
-        max_pool_size: 1
+        connection_recycle_time: 600
+        max_overflow: 50
+        max_pool_size: 5
+        pool_timeout: 30
       filter_scheduler:
         available_filters:
           type: multistring