make mysql_files_table_partitions dynamically determined in lib/mysql-functions instead of statically configured in conf/default.conf

2 files changed, 10 insertions, 2 deletions

diff --git a/conf/default.conf b/conf/default.conf
index ec57a7c..efbb5b4 100755
--- a/conf/default.conf
+++ b/conf/default.conf
@@ -34,8 +34,6 @@ master_build_server_identity="${work_dir}/.ssh/id_rsa"
 repo_key='0xdeadbeef'
 package_key='0x15eebadc0de'
 
-mysql_files_table_partitions=16
-
 # what can be done via the email interface
 possible_email_actions='stabilize block unblock schedule copy-to-build-support'
 
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 0625616..7619c10 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1232,3 +1232,13 @@ mysql_insert_package_files_query() {
   done
 
 }
+
+mysql_files_table_partitions=$(
+  printf 'SHOW CREATE TABLE `files`;\n' | \
+    mysql_run_query | \
+    sed -n '
+      s/^.*PARTITIONS \([0-9]\+\) .*$/\1/
+      T
+      p
+    '
+)