Mysql tuning

http://bazaar.launchpad.net/~matt-day32/mysql-tuning-primer/trunk/files

MySQL

# dump
mysqldump db_name -uroot -p > ffff.sql
mysql db_name -uroot -p < ffff.sql 

# drop all tables
mysql -BNe "show tables" db_name | awk '{print "drop table " $1 ";"}' | mysql db_name

Watch what SQL queries Dango produces

from django.db import connection
print connection.queries
print connection.queries[-1]['sql']

Or in Django >= 1.3

import logging
l = logging.getLogger('django.db.backends')
l.setLevel(logging.DEBUG)
l.addHandler(logging.StreamHandler())

Using tshark

sudo tshark -Tfields -e mysql.query -i any -R 'mysql.query'

mysql -h 127.0.0.1 -u root -p