Advertisement
Guest User

Untitled

a guest
Jan 18th, 2012
151
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
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement