summaryrefslogtreecommitdiff
path: root/files/scripts/optimize_tables.rb
diff options
context:
space:
mode:
Diffstat (limited to 'files/scripts/optimize_tables.rb')
-rw-r--r--files/scripts/optimize_tables.rb4
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
}