Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #BEGIN CONFIG INFO
- #DESCR: custom
- #TYPE: SYSTEM
- #END CONFIG INFO
- [client]
- #password = [your_password]
- port = 3306
- socket = /opt/local/var/run/mysql5/mysqld.sock
- [mysqld]
- port = 3306
- socket = /opt/local/var/run/mysql5/mysqld.sock
- back_log = 50
- skip-networking
- #max_connections = 5
- max_connect_errors = 10
- table_cache = 2048
- #external-locking
- max_allowed_packet = 128M
- binlog_cache_size = 4M
- max_heap_table_size = 64M
- sort_buffer_size = 128M
- join_buffer_size = 16M
- thread_cache_size = 8
- thread_concurrency = 8
- query_cache_size = 64M
- query_cache_limit = 2M
- ft_min_word_len = 4
- #memlock
- default_table_type = INNODB
- thread_stack = 192K
- # Set the default transaction isolation level. Levels available are:
- # READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE
- transaction_isolation = READ-COMMITTED # XXX
- tmp_table_size = 128M
- log-bin=mysql-bin
- #log_slave_updates
- #log
- #log_warnings
- log_slow_queries
- long_query_time = 5
- log_long_format
- #tmpdir = /tmp
- # *** Replication related settings
- server-id = 1
- #server-id = 2
- #master-host = <hostname>
- #master-user = <username>
- #master-password = <password>
- #master-port = <port>
- #read_only
- #*** MyISAM Specific options
- key_buffer_size = 64M
- read_buffer_size = 2M
- read_rnd_buffer_size = 8M
- bulk_insert_buffer_size = 32M
- myisam_sort_buffer_size = 128M
- myisam_max_sort_file_size = 10G
- myisam_max_extra_sort_file_size = 10G
- myisam_repair_threads = 2
- myisam_recover
- # *** BDB Specific options ***
- skip-bdb
- # *** INNODB Specific options ***
- #skip-innodb
- innodb_additional_mem_pool_size = 16M
- innodb_buffer_pool_size = 1280M
- innodb_data_file_path = ibdata1:10M:autoextend
- #innodb_data_home_dir = <directory>
- innodb_file_io_threads = 4
- #innodb_force_recovery=1
- innodb_thread_concurrency = 4
- innodb_flush_log_at_trx_commit = 2 # 0, 1, 2
- #innodb_fast_shutdown
- innodb_log_buffer_size = 8M
- innodb_log_file_size = 192M
- innodb_log_files_in_group = 2
- #innodb_log_group_home_dir
- innodb_max_dirty_pages_pct = 90
- #innodb_flush_method=O_DSYNC
- innodb_lock_wait_timeout = 120
- [mysqldump]
- quick
- max_allowed_packet = 16M
- [mysql]
- no-auto-rehash
- #safe-updates
- [isamchk]
- key_buffer = 512M
- sort_buffer_size = 512M
- read_buffer = 8M
- write_buffer = 8M
- [myisamchk]
- key_buffer = 512M
- sort_buffer_size = 512M
- read_buffer = 8M
- write_buffer = 8M
- [mysqlhotcopy]
- interactive-timeout
- [mysqld_safe]
- open-files-limit = 8192
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement