Advertisement
Guest User

Untitled

a guest
Feb 6th, 2012
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. [mysqld]
  2. basedir=/var/lib/mysql
  3. datadir=/var/lib/mysql
  4. #log=/var/log/mysqld/log-total.log
  5.  
  6.  
  7. socket=/var/lib/mysql/mysql.sock
  8. user=mysql
  9.  
  10. # Default to using old password format for compatibility with mysql 3.x
  11. # clients (those using the mysqlclient10 compatibility package).
  12. old_passwords=1
  13.  
  14. slow_query_log = 1
  15. slow_query_log_file = /var/lib/mysql/mysql-slow.log
  16. long_query_time = 5
  17.  
  18. # Memory usage
  19. skip-external-locking
  20. max_connections = 512
  21. max_user_connections = 512
  22. max_connect_errors = 999999
  23. key_buffer = 384M
  24. max_allowed_packet = 64M
  25. table_cache = 1536
  26. table_definition_cache = 1536
  27. sort_buffer_size = 1M
  28. read_buffer_size = 1M
  29. read_rnd_buffer_size = 4M
  30. myisam_sort_buffer_size = 64M
  31. thread_cache_size = 256
  32. query_cache_type = 1
  33. query_cache_limit = 4M
  34. query_cache_size = 64M
  35. tmp_table_size = 384M
  36. max_heap_table_size = 384M
  37. join_buffer_size = 1M
  38. low_priority_updates=1
  39.  
  40. # CPU x 2 solitamente
  41. thread_concurrency = 4
  42.  
  43. # Disable Federated by default
  44. # skip-federated
  45.  
  46. # Valore per Slow Query può arrivare anche a 1800
  47. wait_timeout=60
  48.  
  49. [mysqld_safe]
  50. log-error=/var/log/mysqld/error.log
  51. pid-file=/var/run/mysqld/mysqld.pid
  52. log=/var/log/mysqld-total.log
  53.  
  54. [mysqldump]
  55. quick
  56. max_allowed_packet = 16M
  57.  
  58. [mysql]
  59. no-auto-rehash
  60.  
  61. [isamchk]
  62. key_buffer = 128M
  63. sort_buffer_size = 128M
  64. read_buffer = 2M
  65. write_buffer = 2M
  66.  
  67. [myisamchk]
  68. key_buffer = 128M
  69. sort_buffer_size = 128M
  70. read_buffer = 2M
  71. write_buffer = 2M
  72.  
  73. [mysqlhotcopy]
  74. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement