diff options
Diffstat (limited to 'files/optimize')
-rw-r--r-- | files/optimize/optimize_tables.rb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/files/optimize/optimize_tables.rb b/files/optimize/optimize_tables.rb index 5bd2a1f..da4515b 100644 --- a/files/optimize/optimize_tables.rb +++ b/files/optimize/optimize_tables.rb @@ -4,7 +4,7 @@ tables = %x{mysql -Bse "SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.T tables.each { |table| tableitems = table.chomp.split(/\t/) system "mysql #{tableitems[0]} -Bse \"OPTIMIZE TABLE #{tableitems[1]}\" | grep -q OK" - if $?.to_I > 0 then + if $?.to_i > 0 then puts "error while optimizing #{tableitems[0]}. #{tableitems[1]}" end } |