Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- jyavenard@htpc:/etc/mysql/conf.d$ cat mythtv.cnf
- [mysqld]
- # Customized config for MythTV baseline
- bind-address=0.0.0.0
- skip-external-locking
- key_buffer_size = 64M
- tmp_table_size = 32M
- table_cache = 256
- query_cache_limit = 3M
- query_cache_size = 32M
- # Set Base Innodb Specific settings here
- innodb_flush_method = O_DIRECT
- innodb_file_per_table = 1
- innodb_file_format = barracuda
- innodb_max_dirty_pages_pct = 90
- innodb_lock_wait_timeout = 20
- innodb_flush_log_at_trx_commit = 2
- innodb_additional_mem_pool_size = 16M
- innodb_buffer_pool_size = 128M
- innodb_thread_concurrency = 8
- # Logging Options
- log-queries-not-using-indexes
- log_error
- long_query_time = 5
- log_slow_queries = /var/log/mysql/mysql-slow.log
- general_log_file = /var/log/mysql/mysql.log
- general_log = 1
- log_error = /var/log/mysql/error.log
- binlog_do_db = include_database_name
- jyavenard@htpc:/etc/mysql/conf.d$
Advertisement
Add Comment
Please, Sign In to add comment