#!/bin/sh

for dbname in `mysqlshow | awk '{print $2}'`
do
mysqlcheck $dbname ticket -Fq
done

# call this shell script and find the errors
time sh check.sh | grep error

When there is an issue, We should gather some preliminary data to analyze first.

tee 'output.txt';
SHOW GLOBAL STATUS;
SHOW ENGINE INNODB STATUS;
SHOW FULL PROCESSLIST;
SELECT SLEEP(60);
SHOW GLOBAL STATUS;
SHOW ENGINE INNODB STATUS;
SHOW FULL PROCESSLIST;

SHOW GLOBAL VARIABLES;
notee;

Study the 'output.txt' file. Also the my.cnf and slow query log
From the OS;

free -m
ps aux
df -h

iostat -x 1 5
vmstat 1 5
top -b -n 3
mysql> show global status;

You can get information about the make, model and serial number of the equipment as shown below:
# dmidecode -t system

What is the maximum RAM supported by the system?
# dmidecode -t 16

Currently installed RAM
# cat /proc/meminfo | grep -i memtotal

Memory slots occupied
# /usr/sbin/dmidecode -t 17 | grep -i size

// know more about running processes
# dstat

Consider setting up a simple Git alias for common but complex Git command that you type frequently.

git config --global alias.show-graph 'log --graph --abbrev-commit --pretty=oneline'

It is incredibly easy to migrate from MySQL to PostgreSQL. Just migrate your schema first (leaving foreign keys out until after restore) and then the mysqldump files are almost perfectly compatible with PostgreSQL when using:

mysqldump --compatible=postgresql --no-create-db --no-create-info --add-locks=false --quote-names=false --complete-insert=true

I just had to convert \' to two single quotes and fix MySQL's infamous null dates (0000-00-00 00:00:00) to be true nulls and was able to pipe the backup right into psql.

sed -e "s/\\\'/\'\'/g" -e "s/\'0000-00-00 00:00:00\'/null/g" backup.sql > output.sql

Following my.cnf parameter is highly recommended on high configuration machine. This will make importing myisam only data much faster.

#datadir=/var/lib/mysql
datadir=/mnt/data/mysql/
user=root
skip-innodb
default-storage-engine=myisam
key-buffer=1G
bulk_insert_buffer_size=1G
myisam_max_sort_file_size=20G

tmpdir=/mnt/data/mysql

Add the following to the .gitconfig file in your $HOME directory.

[alias]
co = checkout
ci = commit
st = status
br = branch
hist = log --pretty=format:\"%h %ad | %s%d [%an]\" --graph --date=short
type = cat-file -t
dump = cat-file -p

Here is a quick way to send files from any server where mutt is installed.

echo "Attaching a file " | mutt -s "file attachment" -a /root/somefile.txt -- your.name@gmail.com

If you are using Ubuntu and can not change the data directory, you need to edit the file

/etc/apparmor.d/usr.sbin.mysqld

Disable firewall (ufw disable) and check the ownership and directory permissions.

ufw disable

A few packages are dependent upon the server time. If the date is incorretly set, it will throw an exception as shown below.

# s3cmd ls
ERROR: S3 error: 403 (RequestTimeTooSkewed): The difference between the request time and the current time is too large.

/sbin/ntpdate ntp.ubuntu.com

Afer updating the date using ntpdate command, the s3cmd command started working as expected.

# date command can also be used
date +%Y%m%d -s "20130514"