my.cnf 1.1 KB

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