diff options
| -rw-r--r-- | files/optimize/optimize_tables.rb | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/files/optimize/optimize_tables.rb b/files/optimize/optimize_tables.rb index da4515b..52e726e 100644 --- a/files/optimize/optimize_tables.rb +++ b/files/optimize/optimize_tables.rb @@ -1,5 +1,7 @@ #!/usr/bin/env ruby +# set home as we runit as weekly cron, where HOME is / +ENV['HOME'] = '/root' tables = %x{mysql -Bse "SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND ENGINE IN ('MyISAM','InnoDB','ARCHIVE')"} tables.each { |table| tableitems = table.chomp.split(/\t/) |