Download the mysqltuner script from github:

wget http://github.com/major/MySQLTuner-perl/archive/master.zip

Unzip the file and then run the perl script:

perl mysqltuner.pl

This will give an out put similar to the below which includes recommendations at the end:

Use of implicit split to @_ is deprecated at mysqltuner.pl line 3243 (#1)
    (D deprecated) It makes a lot of work for the compiler when you clobber
    a subroutine's argument list, so it's better if you assign the results
    of a split() explicitly to an array (or list).

 >>  MySQLTuner 1.6.12 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials.

[--] Skipped version check for MySQLTuner script
Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
[!!] Your MySQL version 5.0.32-Debian_7etch6-log is EOL software!  Upgrade soon!
[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 163M (Tables: 105)
[!!] InnoDB is enabled but isn't being used
[!!] Total fragmented tables: 1

-------- Security Recommendations ------------------------------------------------------------------
[OK] There are no anonymous accounts for any database users
[!!] No more password checks for MySQL version <=5.1
[!!] MySQL version <=5.1 are deprecated and end of support.

-------- CVE Security Recommendations --------------------------------------------------------------
[!!] CVE-2007-2691 : Candidate
[!!] CVE-2007-2691 : Candidate
[!!] CVE-2007-2692 : Candidate
[!!] CVE-2007-2692 : Candidate
[!!] CVE-2007-3780 : Candidate
[!!] CVE-2007-3781 : Candidate
[!!] CVE-2007-3782 : Candidate
[!!] CVE-2007-5969 : Candidate
[!!] CVE-2007-5969 : Candidate
[!!] CVE-2007-6303 : Candidate
[!!] CVE-2007-6304 : Candidate
[!!] CVE-2008-3963 : Candidate
[!!] CVE-2009-4028 : Candidate
[!!] CVE-2009-4484 : Candidate
[!!] CVE-2009-4484 : Candidate
[!!] CVE-2009-5026 : Candidate
[!!] CVE-2010-3833 : Candidate
[!!] CVE-2010-3834 : Candidate
[!!] CVE-2010-3836 : Candidate
[!!] CVE-2010-3837 : Candidate
[!!] CVE-2010-3838 : Candidate
[!!] 21 CVE(s) found for your MySQL release.

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 124d 23h 19m 23s (51M q [4.761 qps], 91K conn, TX: 478M, RX: 2G)
[--] Reads / Writes: 98% / 2%
[--] Binary logging is enabled (GTID MODE: OFF)
[--] Physical Memory     : 2.0G
[--] Max MySQL memory    : 320.5M
Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
[--] Other process memory: 68.1M
[--] Total buffers: 58.0M global + 2.6M per thread (100 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 207.6M (10.26% of installed RAM)
[OK] Maximum possible memory usage: 320.5M (15.84% of installed RAM)
Warning: bad ps syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (8/51M)
[OK] Highest usage of available connections: 56% (57/100)
[OK] Aborted connections: 0.00%  (1/91441)
[OK] Query cache efficiency: 66.0% (33M cached / 51M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 8M sorts)
[OK] No joins without indexes
[OK] Temporary tables created on disk: 17% (10K on disk / 60K total)
[!!] Table cache hit rate: 0% (64 open / 6K opened)
[OK] Open file limit used: 12% (130/1K)
[OK] Table locks acquired immediately: 99% (17M immediate / 17M locks)
[OK] Binlog cache memory access: 100.00% ( 1 Memory / 1 Total)

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is disabled.

-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 11.8% (1M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/29.7M
[OK] Read Key buffer hit rate: 100.0% (114M cached / 24K reads)
[!!] Write Key buffer hit rate: 92.6% (2M cached / 164K writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is disabled.

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is disabled.

-------- TokuDB Metrics ----------------------------------------------------------------------------
[--] TokuDB is disabled.

-------- Galera Metrics ----------------------------------------------------------------------------
[--] Galera is disabled.

-------- Replication Metrics -----------------------------------------------------------------------
[--] Galera Synchronous replication: NO
[--] No replication slave(s) for this server.
[--] This is a standalone server.

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Add skip-innodb to MySQL configuration to disable InnoDB
    Run OPTIMIZE TABLE to defragment tables for better performance
    21 CVE(s) found for your MySQL release. Consider upgrading your version !
    Enable the slow query log to troubleshoot bad queries
    Increase table_cache gradually to avoid file descriptor limits
    Read this before increasing table_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (1024) variable
    should be greater than table_cache ( 64)
    Upgrade to MySQL 5.5+ to use asynchronous write
Variables to adjust:
    table_cache (> 64)

*This was run on a very old development server for testing purposes.

Below are instructions on how to install configure a Percona DB Cluster on Ubuntu (14.04 at time of writing this).

*Carry out on all nodes (servers)

Remove apparmor as it prevents cluster nodes talking to each other:

sudo /etc/init.d/apparmor stop
sudo update-rc.d -f apparmor remove
sudo apt-get remove apparmor apparmor-utils -y

Disable SELinux by editing /etc/selinux/config and add/alter line to disable it:

SELINUX=disabled

Add the following keys to the repository:

apt-key adv –keyserver keys.gnupg.net –recv-keys 1C4CBDCDCD2EFD2A

Add Percona sources:

vim /etc/apt/sources.list
deb http://repo.percona.com/apt trusty main
deb-src http://repo.percona.com/apt trusty main

Place the following script in a directory of your choice:

#<?bash
#!/bin/bash
#
# #automysqlcheck.sh
#
# This is a small bash script that checks all mysql databases for errors
# and mails a log file to a specified email address. All variables are
# hardcoded for ease of use with cron. Any databases you wish not to check
# should be added to the DBEXCLUDE list, with a space in between each name.
#
# Note that DBEXCLUDE will only work with GNU sed, as BSD regular expressions
# on Darwin seem to have some trouble with word boundary anchors.
#
# original version by sbray@csc.uvic.ca, UVic Fine Arts 2004
#
# modified by eyechart AT gmail.com (see Change Log for details)
#
# Some of this code was inspired from automysqlbackup.sh.2.0
# http://sourceforge.net/projects/automysqlbackup/
#
#=====================================================================
# Change Log
#=====================================================================
#
# VER 1.1 - (2005-02-22)
# Named script automysqlcheck.sh
# Added PATH variable to make this script more CRON friendly
# Removed the $DBTABLES loop and replaced it with single command
# that executes the CHECK TABLE command on all tables in a given DB
# Changed code to only check MyISAM and InnoDB tables
# Cleaned up output to make the email prettier
# Modified script to skip databases that have no tables
# VER 1 - (2004-09-24)
# Initial release by sbray@csc.uvic.ca
# system variables (change these according to your system)
PATH=/usr/local/bin:/usr/bin:/bin:$PATH
USER=username
PASSWORD=password
DBHOST=localhost
LOGFILE=/var/log/automysqlcheck.log
MAILTO=email@domain.com
TYPE1= # extra params to CHECK_TABLE e.g. FAST
TYPE2=
CORRUPT=no # start by assuming no corruption
DBNAMES="all" # or a list delimited by space
DBEXCLUDE="" # or a list delimited by space

# I/O redirection...
touch $LOGFILE
exec 6>&1
exec > $LOGFILE # stdout redirected to $LOGFILE

echo -n "AutoMySQLCheck: "
date
echo "---------------------------------------------------------"; echo; echo

# Get our list of databases to check...
# NOTE: the DBEXCLUDE feature seemed to only work with Linux regex, GNU sed
if test $DBNAMES = "all" ; then
DBNAMES="`mysql --user=$USER --password=$PASSWORD --batch -N -e "show databases"`"
for i in $DBEXCLUDE
do
DBNAMES=`echo $DBNAMES | sed "s/\b$i\b//g"`
done
fi

# Run through each database and execute our CHECK TABLE command for all tables
# in a single pass - eyechart
for i in $DBNAMES
do
# echo the database we are working on
echo "Database being checked:"
echo -n "SHOW DATABASES LIKE '$i'" | mysql -t -u$USER -p$PASSWORD $i; echo

# Check all tables in one pass, instead of a loop
# Use GAWK to put in comma separators, use SED to remove trailing comma
# Modified to only check MyISAM or InnoDB tables - eyechart
DBTABLES="`mysql --user=$USER --password=$PASSWORD $i --batch -N -e "show table status;" \
| gawk 'BEGIN {ORS=", " } $2 == "MyISAM" || $2 == "InnoDB"{print $1}' | sed 's/, $//'`"

# Output in table form using -t option
if [ ! "$DBTABLES" ]
then
echo "NOTE: There are no tables to check in the $i database - skipping..."; echo; echo
else
echo "CHECK TABLE $DBTABLES $TYPE1 $TYPE2" | mysql -t -u$USER -p$PASSWORD $i; echo; echo
fi
done

exec 1>&6 6>&- # Restore stdout and close file descriptor #6

# test our logfile for corruption in the database...
for i in `cat $LOGFILE`
do
if test $i = "warning" ; then
CORRUPT=yes
elif test $i = "error" ; then
CORRUPT=yes
fi
done

# Send off our results...
if test $CORRUPT = "yes" ; then
cat $LOGFILE | mail -s "MySQL CHECK Log [ERROR FOUND] for $DBHOST-`date`" $MAILTO
else
cat $LOGFILE | mail -s "MySQL CHECK Log [PASSED OK] for $HOST-`date`" $MAILTO
fi
#?>

*Make sure to update user, password, dbhost, log file location and DBNAMES/DBEXCLUE with your own details.

Now make the script executable (chmod +x scriptname.sh) and add a cronjob to run when required e.g.

01 20 * * * /home/user/bin/mysqlcheckscript.sh

*cron will run at 1.20am everyday.

Simple commands to insert a new Admin user into your WordPress database:

INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('3', 'username', MD5('password'), 'Nice Name', 'test@yourdomain.com', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name');

INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '3', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');

INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '3', 'wp_user_level', '10');

Notes:

3 – next free user id in wp_users table
username – username logging in with
password – password logging in with
Nice Name – name
test@yourdomain.com – email address
http://www.test.com/ – URL
2011-06-07 00:00:00 – sign-up date
Your name – display name

Last 2 INSERT commands give the user admin privileges. Remember to update ‘3’ to the user id you set in the first INSERT command.

Shutdown mysql:

/etc/init.d/mysql stop

Change into database directory:

cd /var/lib/mysql/dbname

Check and repair MYI tables:

myisamchk -o -r *.MYI

-o – safe recover

-r – recover