From d9aca2e98d55dd3afe96f25c1f7ca919297dcfab Mon Sep 17 00:00:00 2001 From: Carlos Konstanski Date: Thu, 22 Feb 2018 16:59:14 -0700 Subject: Removing calls to p_preallocate_partitions in create_database_schemas.sql script --- salt/openbook/database/files/update-openbook-schema.sh | 11 ----------- 1 file changed, 11 deletions(-) (limited to 'salt/openbook') diff --git a/salt/openbook/database/files/update-openbook-schema.sh b/salt/openbook/database/files/update-openbook-schema.sh index 313d324..3f1a921 100644 --- a/salt/openbook/database/files/update-openbook-schema.sh +++ b/salt/openbook/database/files/update-openbook-schema.sh @@ -17,17 +17,6 @@ sed --posix -r 's|(^.*PARTITION BY RANGE.*\))|\1;|g' -i create_openbook_schemas. sed --posix -r 's|^.*PARTITION.*VALUES.*ENGINE = InnoDB.*$||g' -i create_openbook_schemas.sql sed '/^$/d' -i create_openbook_schemas.sql -cat <>create_openbook_schemas.sql -use openbook; -CALL p_preallocate_partitions('t_metric_values', 'metric_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_resource_hourly', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_tenant_hourly', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_customer_hourly', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_resource_daily', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_tenant_daily', 'aggregate_datetime', CURDATE(), 31); -CALL p_preallocate_partitions('t_metric_aggregate_customer_daily', 'aggregate_datetime', CURDATE(), 31); -EOF - git add -A git commit -a -m "update create_databases_schema.sql $(date)" git push -- cgit v1.3