MySQL Tuner

SQL tuner

cd /root ; wget -N --no-check-certificate https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl ; perl mysqltuner.pl

Optimize database

mysqlcheck -o --all-databases

Recent Posts

#!/bin/bash rm -f ./cleanspace.sh bold=$(tput bold) normal=$(tput sgr0) TIMESTAMP=$(date +%d-%m-%Y-%H-%M) LOGFILE="/root/cleardisk-$TIME...

Create a new folder: mkdir /var/lib/mysql2 From R1: Restore from the /var/lib/mysql folder: + The folder which is called the db name...

#not wordpress site grep shop2vizag.com /var/log/messages | awk '{print $6}' | cut -d: -f1 |sort -n |uniq -c |sort -n #Domains using...