summaryrefslogtreecommitdiff
path: root/manifests/server/cron/optimize.pp
diff options
context:
space:
mode:
authorGabriel Filion <gabster@lelutin.ca>2014-03-06 18:38:20 -0500
committerGabriel Filion <gabster@lelutin.ca>2014-03-06 18:46:06 -0500
commitae2fbce7ac58d2f6bb33b350aee6482fd5a94df7 (patch)
tree13c887709125907641ced4f3fc4f761cbe843f49 /manifests/server/cron/optimize.pp
parent6d9a84686734e598249410bf60eedf2d7fd2e521 (diff)
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.
Diffstat (limited to 'manifests/server/cron/optimize.pp')
-rw-r--r--manifests/server/cron/optimize.pp12
1 files changed, 8 insertions, 4 deletions
diff --git a/manifests/server/cron/optimize.pp b/manifests/server/cron/optimize.pp
index d1d0257..5d4fa98 100644
--- a/manifests/server/cron/optimize.pp
+++ b/manifests/server/cron/optimize.pp
@@ -1,5 +1,9 @@
# optimize mysql databases regurarely
-class mysql::server::cron::optimize {
+class mysql::server::cron::optimize (
+ $optimize_hour,
+ $optimize_minute,
+ $optimize_day
+) {
file { 'mysql_optimize_script':
path => '/usr/local/sbin/optimize_mysql_tables.rb',
@@ -12,9 +16,9 @@ class mysql::server::cron::optimize {
cron { 'mysql_optimize_cron':
command => '/usr/local/sbin/optimize_mysql_tables.rb',
user => 'root',
- minute => 40,
- hour => 6,
- weekday => 7,
+ minute => $optimize_minute,
+ hour => $optimize_hour,
+ weekday => $optimize_day,
require => [ Exec['mysql_set_rootpw'],
File['mysql_root_cnf'],
File['mysql_optimize_script'] ],