Guest User

Untitled

a guest
Feb 26th, 2011
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. [mysqld]
  2.  
  3. long_query_time = 10
  4. log-slow-queries = /var/log/mysql/mysql-slow.log
  5.  
  6. socket = /var/lib/mysql/mysql.sock
  7. safe-show-database
  8. old-password=1
  9. set-variable = max_connections=500
  10. interactive_timeout=100
  11. wait_timeout=1000
  12. connect_timeout=30
  13. thread_cache_size=8
  14. key_buffer=256M
  15. join_buffer=512M
  16. max_allowed_packet=512M
  17. table_cache=1800
  18. sort_buffer=256M
  19. record_buffer=64M
  20. thread_cache_size=128
  21. max_user_connections=100
  22.  
  23. thread_concurrency=6
  24. myisam_sort_buffer_size=64M
  25. max_heap_table_size=256M
  26. tmp_table_size=512M
  27. innodb_buffer_pool_size=724M
  28. query_cache_limit=256M
  29. query_cache_size=64M
  30. query_cache_type=1
  31.  
  32. [mysql.server]
  33. user=mysql
  34.  
  35. [safe_mysqld]
  36. err-log=/var/log/mysqld.log
  37. open_files_limit=8192
  38.  
  39. [mysqldump]
  40. quick
  41. max_allowed_packet=32M
  42.  
  43. [mysql]
  44. no-auto-rehash
  45. # Remove the next comment character if you are not familiar with SQL
  46. #safe-updates
  47.  
  48. [isamchk]
  49. key_buffer=512M
  50. sort_buffer=256M
  51. read_buffer=64M
  52. write_bufer=64M
  53.  
  54. [myisamchk]
  55. key_buffer=512M
  56. sort_buffer=256M
  57. read_buffer=64M
  58. write_buffer=64M
  59.  
  60. [mysqlhotcopy]
  61. interactive-timeout
Advertisement
Add Comment
Please, Sign In to add comment