From ae2fbce7ac58d2f6bb33b350aee6482fd5a94df7 Mon Sep 17 00:00:00 2001 From: Gabriel Filion Date: Thu, 6 Mar 2014 18:38:20 -0500 Subject: Randomize time of execution for optimize script. By default, time will be between midnight and 7:00 any day of the week. The values are currently hard-coded. This can have serious I/O repercussions on a server with multiple VMs that run mysql since they will all run their optimizations simultaneously. --- manifests/server/base.pp | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'manifests/server/base.pp') diff --git a/manifests/server/base.pp b/manifests/server/base.pp index 14f3c1b..b379f5c 100644 --- a/manifests/server/base.pp +++ b/manifests/server/base.pp @@ -70,7 +70,11 @@ class mysql::server::base { } if $mysql::server::optimize_cron { - include mysql::server::cron::optimize + class { 'mysql::server::cron::optimize': + optimize_hour => $mysql::server::optimize_hour, + optimize_minute => $mysql::server::optimize_minute, + optimize_day => $mysql::server::optimize_day, + } } service { 'mysql': -- cgit v1.2.3