diff options
Diffstat (limited to 'files/scripts')
| -rw-r--r-- | files/scripts/Debian/setmysqlpass.sh | 2 | ||||
| -rw-r--r-- | files/scripts/optimize_tables.rb | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/files/scripts/Debian/setmysqlpass.sh b/files/scripts/Debian/setmysqlpass.sh index 5f345fb..f7d5357 100644 --- a/files/scripts/Debian/setmysqlpass.sh +++ b/files/scripts/Debian/setmysqlpass.sh @@ -13,7 +13,7 @@ UPDATE mysql.user SET Password=PASSWORD('$rootpw') WHERE User='root' AND Host='l FLUSH PRIVILEGES; EOF killall mysqld -sleep 5 +sleep 15 # chown to be on the safe side ls -al /var/lib/mysql/mysql-bin.* &> /dev/null [ $? == 0 ] && chown mysql.mysql /var/lib/mysql/mysql-bin.* 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 } |