diff options
| author | Jerome Charaoui <jcharaoui@cmaisonneuve.qc.ca> | 2014-03-11 17:57:03 -0400 |
|---|---|---|
| committer | Jerome Charaoui <jcharaoui@cmaisonneuve.qc.ca> | 2014-03-11 17:57:03 -0400 |
| commit | 8fbc1b33eea6d45d9b6ff4de0faf937394c415ca (patch) | |
| tree | 987a71623c0fa6abf290152b1b28568f7d0cb39c | |
| parent | f34882cadda75e0a464e8d3a494a84d0bf230761 (diff) | |
Fix command output capturing in optimize_tables.rb for Ruby 1.9
| -rw-r--r-- | files/scripts/optimize_tables.rb | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/files/scripts/optimize_tables.rb b/files/scripts/optimize_tables.rb index 46e223e..3eb7425 100644 --- a/files/scripts/optimize_tables.rb +++ b/files/scripts/optimize_tables.rb @@ -2,7 +2,8 @@ # 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 = %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 = tables.split(/\n/) tables.each { |table| tableitems = table.chomp.split(/\t/) system "mysql #{tableitems[0]} -Bse \"OPTIMIZE TABLE \\`#{tableitems[0]}\\`.\\`#{tableitems[1]}\\`\" | grep -q OK" |