From 2e95564029e21323a58f80589aebd7c16448c507 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 29 Mar 2018 16:09:53 +0200
Subject: make mysql_files_table_partitions dynamically determined in
 lib/mysql-functions instead of statically configured in conf/default.conf

---
 conf/default.conf   |  2 --
 lib/mysql-functions | 10 ++++++++++
 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
+    '
+)
-- 
cgit v1.2.3-54-g00ecf