Guest User

mysql config

a guest
Dec 19th, 2011
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. [mysqld]
  2. datadir = /var/lib/mysql
  3. socket = /var/lib/mysql/mysql.sock
  4. user = mysql
  5.  
  6. low-priority-updates
  7. key_buffer = 16K
  8. max_allowed_packet = 1M
  9. sort_buffer_size = 64K
  10. read_buffer_size = 256K
  11. read_rnd_buffer_size = 256K
  12. net_buffer_length = 2K
  13. thread_stack = 64K
  14. thread_cache_size = 12
  15. # This replaces the startup script and checks MyISAM tables if needed
  16. # the first time they are touched
  17. myisam-recover = BACKUP
  18. max_connections = 100
  19. #back-log = 20
  20. table_cache = 4
  21. #thread_concurrency = 10
  22.  
  23. innodb_file_per_table
  24. innodb_additional_mem_pool_size = 16M
  25. innodb_buffer_pool_size = 256M
  26. innodb_file_io_threads = 4
  27. innodb_thread_concurrency = 4
  28. innodb_flush_log_at_trx_commit = 1
  29. innodb_log_buffer_size = 8M
  30. innodb_data_file_path=ibdata1:5000M;ibdata2:3000M:autoextend
  31. tmpdir=/tmp
  32. skip-external-locking
  33.  
  34. [mysqld_safe]
  35. log-error = /var/log/mysqld.log
  36. pid-file = /var/run/mysqld/mysqld.pid
Advertisement
Add Comment
Please, Sign In to add comment