diff options
author | Micah Anderson <micah@riseup.net> | 2010-09-22 13:12:51 -0400 |
---|---|---|
committer | Micah Anderson <micah@riseup.net> | 2010-09-22 13:12:51 -0400 |
commit | a3e7b031a39d2f5a3a6cb3ff71ffe47af9fe3fc6 (patch) | |
tree | b10b0b101dd07d34fa0d17b391179f2bb87f5607 /files/scripts | |
parent | 316e75293331d0a9927f0731784c05dd0fb16374 (diff) | |
parent | 24d7c6aa2480a4ff5436e2b89800c0aab11cbe33 (diff) |
Merge remote branch 'remotes/immerda/master'
Conflicts:
manifests/server/base.pp
Diffstat (limited to 'files/scripts')
-rw-r--r-- | files/scripts/optimize_tables.rb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/files/scripts/optimize_tables.rb b/files/scripts/optimize_tables.rb index 52e726e..46e223e 100644 --- a/files/scripts/optimize_tables.rb +++ b/files/scripts/optimize_tables.rb @@ -5,8 +5,8 @@ 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/) - system "mysql #{tableitems[0]} -Bse \"OPTIMIZE TABLE #{tableitems[1]}\" | grep -q OK" + system "mysql #{tableitems[0]} -Bse \"OPTIMIZE TABLE \\`#{tableitems[0]}\\`.\\`#{tableitems[1]}\\`\" | grep -q OK" if $?.to_i > 0 then - puts "error while optimizing #{tableitems[0]}. #{tableitems[1]}" + puts "error while optimizing #{tableitems[0]}.#{tableitems[1]}" end } |