| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- [client]
- port = 3306
- socket = /var/run/mysqld.sock
- [mysqld]
- user = root
- socket = /var/run/mysqld.sock
- port = 3306
- basedir = /usr
- ############ Don't put this on the NAND #############
- # Figure out where you are going to put the databases
- # And run mysql_install_db --force
- datadir = /mnt/data/mysql/
- ######### This should also not go on the NAND #######
- tmpdir = /mnt/data/tmp/
- skip-external-locking
- bind-address = 127.0.0.1
- # Fine Tuning
- key_buffer = 16M
- max_allowed_packet = 16M
- thread_stack = 192K
- thread_cache_size = 8
- # Here you can see queries with especially long duration
- #log_slow_queries = /var/log/mysql/mysql-slow.log
- #long_query_time = 2
- #log-queries-not-using-indexes
- # The following can be used as easy to replay backup logs or for replication.
- #server-id = 1
- #log_bin = /var/log/mysql/mysql-bin.log
- #expire_logs_days = 10
- #max_binlog_size = 100M
- #binlog_do_db = include_database_name
- #binlog_ignore_db = include_database_name
- [mysqldump]
- quick
- quote-names
- max_allowed_packet = 16M
- [mysql]
- #no-auto-rehash # faster start of mysql but no tab completition
- [isamchk]
- key_buffer = 16M
|
