SHARE
TWEET

Untitled

a guest Jan 18th, 2012 102 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. skip-name-resolve
  3. datadir=/var/lib/mysql
  4. socket=/var/lib/mysql/mysql.sock
  5. log-error=/var/log/mysqld.log
  6. port=48221
  7. user=mysql
  8. old_passwords=0
  9. max_connections = 400
  10. table_cache = 2048
  11. max_allowed_packet = 16M
  12. sort_buffer_size = 2M
  13. thread_cache = 8
  14. thread_concurrency = 32
  15. query_cache_size = 160M
  16. query_cache_limit =3M
  17. #query_cache_type = 0
  18. default-storage-engine = innodb
  19. transaction_isolation = REPEATABLE-READ
  20. tmp_table_size = 256M
  21. max_heap_table_size  = 256M
  22. #log_slow_queries = 0
  23. #slow_query_log_file=/var/log/mysqlslow.log
  24. #long_query_time=1
  25.  
  26. innodb_additional_mem_pool_size=48M
  27. innodb_file_per_table
  28. innodb_flush_log_at_trx_commit=2
  29. innodb_log_buffer_size=32M
  30. innodb_autoinc_lock_mode=2
  31. innodb_io_capacity=1000
  32. innodb_read_io_threads=64
  33. innodb_write_io_threads=64
  34. innodb_buffer_pool_size = 16000M
  35. innodb_lock_wait_timeout = 300
  36. innodb_max_dirty_pages_pct = 90
  37. innodb_thread_concurrency =0
  38.  
  39. #log-bin = /var/log/mysql-bin.log
  40. #binlog-do-db=lolbin
  41. #server-id=1
  42.  
  43. [mysqldump]
  44. quick
  45. single-transaction
  46.  
  47. [mysqld_safe]
  48. log-error=/var/log/mysqld.log
  49. pid-file=/var/run/mysqld/mysqld.pid
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top