Merge ~ines-almeida/launchpad-layers:add-storm_cache_size-config into launchpad-layers:main

[Ines Almeida]

Add storm_cache_size param to launchpad-db config.yaml

The value for this param will be overwritten in the ppa publisher charm, but its config should be within the launchpaddb layer

[Colin Watson (cjwatson)]

I think you should also add `storm_cache_size: {{ storm_cache_size }}` to the `[database]` section in `launchpad-db/templates/launchpad-db-lazr.conf`. It won't hurt since the default in the charm is the same as the default in the config schema, and it'll save a bit of work in the PPA publisher charm.

review: Approve

0796916... by Ines Almeida on 2023-08-15

Add storm_cache_size param to launchpad-db-lazr.conf

[Ines Almeida (ines-almeida)]

Agree. Updated the launchpad-db-lazr

diff --git a/launchpad-db/config.yaml b/launchpad-db/config.yaml
index cd088e2..361e060 100644
--- a/launchpad-db/config.yaml
+++ b/launchpad-db/config.yaml
@@ -10,3 +10,7 @@ options:
     type: int
     description: SQL statement timeout in milliseconds.
     default:
+  storm_cache_size:
+    type: int
+    default: 10000
+    description: The size of the Storm cache in objects.
diff --git a/launchpad-db/templates/launchpad-db-lazr.conf b/launchpad-db/templates/launchpad-db-lazr.conf
index e6f4f80..5cfa4fa 100644
--- a/launchpad-db/templates/launchpad-db-lazr.conf
+++ b/launchpad-db/templates/launchpad-db-lazr.conf
@@ -16,4 +16,5 @@ extends: launchpad-base-lazr.conf
 rw_main_primary: {{ db_primary }}
 rw_main_standby: {{ db_standby or db_primary }}
 set_role_after_connecting: True
+storm_cache_size: {{ storm_cache_size }}