jyavenard

Untitled

Aug 16th, 2013
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. jyavenard@htpc:/etc/mysql/conf.d$ cat mythtv.cnf
  2. [mysqld]
  3. # Customized config for MythTV baseline
  4.  
  5. bind-address=0.0.0.0
  6. skip-external-locking
  7. key_buffer_size = 64M
  8. tmp_table_size = 32M
  9. table_cache = 256
  10. query_cache_limit = 3M
  11. query_cache_size = 32M
  12.  
  13.  
  14. # Set Base Innodb Specific settings here
  15. innodb_flush_method = O_DIRECT
  16. innodb_file_per_table = 1
  17. innodb_file_format = barracuda
  18. innodb_max_dirty_pages_pct = 90
  19. innodb_lock_wait_timeout = 20
  20. innodb_flush_log_at_trx_commit = 2
  21. innodb_additional_mem_pool_size = 16M
  22. innodb_buffer_pool_size = 128M
  23. innodb_thread_concurrency = 8
  24.  
  25. # Logging Options
  26. log-queries-not-using-indexes
  27. log_error
  28. long_query_time = 5
  29. log_slow_queries = /var/log/mysql/mysql-slow.log
  30. general_log_file = /var/log/mysql/mysql.log
  31. general_log = 1
  32. log_error = /var/log/mysql/error.log
  33. binlog_do_db = include_database_name
  34. jyavenard@htpc:/etc/mysql/conf.d$
Advertisement
Add Comment
Please, Sign In to add comment