my.cnf (1139B)
1 [client] 2 port = 3306 3 socket = /var/run/mysqld.sock 4 5 [mysqld] 6 user = root 7 socket = /var/run/mysqld.sock 8 port = 3306 9 basedir = /usr 10 11 ############ Don't put this on the NAND ############# 12 # Figure out where you are going to put the databases 13 # And run mysql_install_db --force 14 datadir = /mnt/data/mysql/ 15 16 ######### This should also not go on the NAND ####### 17 tmpdir = /mnt/data/tmp/ 18 19 skip-external-locking 20 21 bind-address = 127.0.0.1 22 23 # Fine Tuning 24 key_buffer = 16M 25 max_allowed_packet = 16M 26 thread_stack = 192K 27 thread_cache_size = 8 28 29 # Here you can see queries with especially long duration 30 #log_slow_queries = /var/log/mysql/mysql-slow.log 31 #long_query_time = 2 32 #log-queries-not-using-indexes 33 34 # The following can be used as easy to replay backup logs or for replication. 35 #server-id = 1 36 #log_bin = /var/log/mysql/mysql-bin.log 37 #expire_logs_days = 10 38 #max_binlog_size = 100M 39 #binlog_do_db = include_database_name 40 #binlog_ignore_db = include_database_name 41 42 43 [mysqldump] 44 quick 45 quote-names 46 max_allowed_packet = 16M 47 48 [mysql] 49 #no-auto-rehash # faster start of mysql but no tab completition 50 51 [isamchk] 52 key_buffer = 16M 53 54