MySQL | Systems Biology Group

Contents of the my.cnf file at /projects/sysbio/etc/init.d run every time mysqld is launched using startmysql

[mysqld]
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
myisam-recover
basedir=/projects/sysbio/apps/x86_64/mysql
datadir=/home/mysql
port=3306
socket=/home/mysql/mysql.sock
innodb_log_arch_dir=/home/mysql/log/
innodb_log_group_home_dir=/home/mysql/log/
#log=/home/mysql/log/conn.log
#log-bin=/home/mysql/log/bin.log
log-error=/home/mysql/log/mysqld.error.log
myisam_sort_buffer_size=100M
sort_buffer_size=10M
bulk_insert_buffer_size=20M
key_buffer_size=100M
max_allowed_packet=10M
log-slow-queries=/home/mysql/disco-slow.log
log-queries-not-using-indexes
long_query_time=100
log-slow-queries
log-queries-not-using-indexes
long_query_time=100
pid-file=/home/mysql/disco.pid

[mysqld_safe]
log-error=/home/mysql/log/mysqld.error.log
ledir=/projects/sysbio/apps/x86_64/mysql/bin
skip-kill-mysqld

Notes

Before running startmysqld you need to delete /home/mysql/ibdata1 on disco, because if you don't the launch process will fail. Sorry, I've given up (for now) trying to figure out why that is.

-- Main.Gregory Dougherty - 25 Apr 2008