diff options
| author | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2018-02-22 16:59:14 -0700 |
|---|---|---|
| committer | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2018-02-22 16:59:14 -0700 |
| commit | d9aca2e98d55dd3afe96f25c1f7ca919297dcfab (patch) | |
| tree | 69462b1632e37403726eaf3e7c2948cb050d86b8 | |
| parent | e00e8747ac0ba74cc949d89e20fd1bfed7ecaaf2 (diff) | |
Removing calls to p_preallocate_partitions in create_database_schemas.sql script
| -rw-r--r-- | salt/openbook/database/files/update-openbook-schema.sh | 11 |
1 files changed, 0 insertions, 11 deletions
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 <<EOF >>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 |