Advertisement
Guest User

Untitled

a guest
Nov 1st, 2010
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement