my.cnf file for development box

my.cnf

[mysqld]
socket=/var/lib/mysql/mysql.sock

###############
## query log  #
###############
# < 5.1.6 format turn on general log and accepts a path
# log = /usr/local/mysql/data/queries.log

# > 5.1.6
# turns on general log
# name defaults to {}.log but can be changed with general_log_file
#general-log
# sets path for general log
# general_log_file = queries.log

################
# slow qry log #
################
# < 5.1.6 format
log_slow_queries
# >= 5.1.6 format
# slow-query-log

################
# indexes log  #
# Whether queries that do not use indexes are logged to the slow query log
# used in combination with slow query log (that must be on for this to be active)
# so you can enable log_queries_not_using_indexes then dial up the
# long_query_time and then the slow query log will only be logging missing index queries
################
log_queries_not_using_indexes

########################
# output logs to tables (in mysql db)
# this setting supersedes log/general_log
#   select * from mysql.general_log
#   select * from mysql.slow_log
# >= 5.1.6
log-output = TABLE
long_query_time = 3

# days to hold the binary log
# expire_logs_days = 1

[client]
socket=/var/lib/mysql/mysql.sock