SHOW:
|
|
- or go back to the newest paste.
| 1 | # Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208 | |
| 2 | - | # Configuration name wowdb generated for carlos@asenjo.es at 2012-07-29 17:27:56 |
| 2 | + | |
| 3 | [mysql] | |
| 4 | ||
| 5 | # CLIENT # | |
| 6 | port = 3306 | |
| 7 | socket = /var/lib/mysql/mysql.sock | |
| 8 | ||
| 9 | [mysqld] | |
| 10 | ||
| 11 | # GENERAL # | |
| 12 | user = mysql | |
| 13 | default_storage_engine = InnoDB | |
| 14 | socket = /var/lib/mysql/mysql.sock | |
| 15 | pid_file = /var/lib/mysql/mysql.pid | |
| 16 | ||
| 17 | # MyISAM # | |
| 18 | key_buffer_size = 32M | |
| 19 | myisam_recover = FORCE,BACKUP | |
| 20 | ||
| 21 | # SAFETY # | |
| 22 | max_allowed_packet = 16M | |
| 23 | max_connect_errors = 1000000 | |
| 24 | skip_name_resolve | |
| 25 | sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY | |
| 26 | sysdate_is_now = 1 | |
| 27 | innodb = FORCE | |
| 28 | ||
| 29 | # DATA STORAGE # | |
| 30 | datadir = /var/lib/mysql/ | |
| 31 | ||
| 32 | # BINARY LOGGING # | |
| 33 | log_bin = /var/lib/mysql/mysql-bin | |
| 34 | expire_logs_days = 14 | |
| 35 | sync_binlog = 1 | |
| 36 | ||
| 37 | # CACHES AND LIMITS # | |
| 38 | tmp_table_size = 32M | |
| 39 | max_heap_table_size = 32M | |
| 40 | query_cache_type = 0 | |
| 41 | query_cache_size = 0 | |
| 42 | max_connections = 70 | |
| 43 | thread_cache_size = 16 | |
| 44 | open_files_limit = 65535 | |
| 45 | table_definition_cache = 4096 | |
| 46 | table_open_cache = 4096 | |
| 47 | ||
| 48 | # INNODB # | |
| 49 | innodb_flush_method = O_DIRECT | |
| 50 | innodb_log_files_in_group = 2 | |
| 51 | innodb_log_file_size = 256M | |
| 52 | innodb_flush_log_at_trx_commit = 1 | |
| 53 | innodb_file_per_table = 1 | |
| 54 | innodb_buffer_pool_size = 5G | |
| 55 | ||
| 56 | # LOGGING # | |
| 57 | log_error = /var/lib/mysql/mysql-error.log | |
| 58 | log_queries_not_using_indexes = 1 | |
| 59 | slow_query_log = 1 | |
| 60 | slow_query_log_file = /var/lib/mysql/mysql-slow.log |
