Advertisement
Guest User

my.cnf

a guest
Dec 17th, 2012
373
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. [client]
  2. port = 3306
  3. socket = /var/run/mysqld/mysqld.sock
  4.  
  5. [mysqld_safe]
  6. socket = /var/run/mysqld/mysqld.sock
  7. nice = 0
  8.  
  9. [mysqld]
  10. user = mysql
  11. pid-file = /var/run/mysqld/mysqld.pid
  12. socket = /var/run/mysqld/mysqld.sock
  13. port = 3306
  14. basedir = /usr
  15. datadir = /var/lib/mysql
  16. tmpdir = /tmp
  17. language = /usr/share/mysql/english
  18. skip-external-locking
  19. skip-name-resolve
  20. thread_cache_size = 612
  21. table_cache = 30000
  22. key_buffer = 20M
  23. max_allowed_packet = 16M
  24. max_connect_errors = 10
  25. tmp_table_size=16M
  26. max_heap_table_size=16M
  27. query_cache_size=0
  28. query_cache_type=0
  29. query_cache_limit=0
  30. max_connections=1500
  31. interactive_timeout=38000
  32. wait_timeout=5
  33. innodb_buffer_pool_size = 13100M
  34. innodb_additional_mem_pool_size = 8M
  35. innodb_flush_log_at_trx_commit = 2
  36. innodb_support_xa = 0
  37. innodb_lock_wait_timeout = 10
  38. innodb_flush_method=O_DIRECT
  39. innodb_log_files_in_group = 2
  40. innodb_log_file_size = 250M
  41. innodb_log_buffer_size = 10M
  42. innodb_thread_concurrency = 0
  43. #log = /var/log/mysql/mysql.log
  44. log_slow_queries = /var/log/mysql/mysql-slow.log
  45. long_query_time = 0.1
  46. skip-log-warnings
  47. log-queries-not-using-indexes
  48. max_binlog_size = 100M
  49. [mysqldump]
  50. quick
  51. quote-names
  52. max_allowed_packet = 16M
  53.  
  54. [mysqlhotcopy]
  55. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement