# Example mysql config file for large systems. # # This is for large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/run/mysqld/mysqld.sock # Here follows entries for some specific programs [manager] run-as-service monitoring-interval = 4 password-file = /etc/mysql/mysqlmanager.passwd log = /var/log/mysql/mysqlmanager.log pid-file = /var/run/mysqld/mysqlmanager.pid socket = /var/run/mysqld/mysqlmanager.sock angel-pid-file = /var/run/mysqld/mysqlmanager.angel.pid wait-timeout = 120 # The MySQL server [mysqld] port = 3306 user = mysql socket = /var/run/mysqld/mysqld.sock pid-file = /var/run/mysqld/mysqld.pid datadir = /var/lib/mysql log-error = /var/log/mysql/mysql.err #shutdown-delay = 1200 set-variable = key_buffer=256M set-variable = max_allowed_packet=16M set-variable = table_cache=512 set-variable = sort_buffer=16M set-variable = record_buffer=2M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = tmp_table_size=128M set-variable = expire_logs_days=1 max_heap_table_size = 256M large-pages skip-name-resolve skip-external-locking # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 default-character-set = cp1251 # REPLICATION parameters: server-id=701 log-bin = /var/log/mysql/cutter-bin log-slave-updates relay-log = /var/log/mysql/cutter-relay-bin relay-log-index = /var/log/mysql/cutter-relay-bin.index relay-log-info-file = /var/log/mysql/cutter-relay-log.info slave_compressed_protocol = 1 report-host = cutter.vh.com.ru # following section (until END OF REPLICATION) # related to unidb functionality and should be used # while cutter.vh.com.ru servse as unidb #master-host = 127.0.0.1 #master-port = 3308 #master-user = user #master-password = password replicate-do-db = marex_bo replicate-wild-do-table = marex_bo.% replicate-rewrite-db = shop22pre->shop_ro replicate-do-db = shop_ro replicate-do-table = shop_ro.account replicate-do-table = shop_ro.banner_banner replicate-do-table = shop_ro.banner_category replicate-do-table = shop_ro.banner_template replicate-do-table = shop_ro.category replicate-do-table = shop_ro.category_document replicate-do-table = shop_ro.catrelation replicate-do-table = shop_ro.catrelation_ext_data replicate-do-table = shop_ro.catrelation_ext_desc replicate-do-table = shop_ro.catrelation_link replicate-do-table = shop_ro.catrelation_link_type replicate-do-table = shop_ro.catrelation_person replicate-do-table = shop_ro.catrelation_shops replicate-do-table = shop_ro.catrelation_type replicate-do-table = shop_ro.catrelation_type_property replicate-do-table = shop_ro.city replicate-do-table = shop_ro.city_payment replicate-do-table = shop_ro.country replicate-do-table = shop_ro.couriers replicate-do-table = shop_ro.currency replicate-do-table = shop_ro.currency_rate replicate-do-table = shop_ro.delivery_payment replicate-do-table = shop_ro.delivery_rule replicate-do-table = shop_ro.delivery_type replicate-do-table = shop_ro.delivery_zone replicate-do-table = shop_ro.detail replicate-do-table = shop_ro.detail_blob replicate-do-table = shop_ro.detail_date replicate-do-table = shop_ro.detail_fastspvalue replicate-do-table = shop_ro.detail_real replicate-do-table = shop_ro.detail_shop replicate-do-table = shop_ro.detail_string replicate-do-table = shop_ro.detail_type replicate-do-table = shop_ro.directory replicate-do-table = shop_ro.directory_type replicate-do-table = shop_ro.discount replicate-do-table = shop_ro.fake_random replicate-do-table = shop_ro.firm replicate-do-table = shop_ro.full_search replicate-do-table = shop_ro.holiday replicate-do-table = shop_ro.loan replicate-do-table = shop_ro.loan_repayment_period replicate-do-table = shop_ro.loan_required_data replicate-do-table = shop_ro.man_cid replicate-do-table = shop_ro.man_cid_title replicate-do-table = shop_ro.mag replicate-do-table = shop_ro.mag_product replicate-do-table = shop_ro.manufacturer replicate-do-table = shop_ro.metro replicate-do-table = shop_ro.moscow_street_zip replicate-do-table = shop_ro.ms_family replicate-do-table = shop_ro.ms_language replicate-do-table = shop_ro.ms_package replicate-do-table = shop_ro.ms_part replicate-do-table = shop_ro.ms_pool replicate-do-table = shop_ro.ms_pricing replicate-do-table = shop_ro.ms_product replicate-do-table = shop_ro.mview_partner_stat replicate-do-table = shop_ro.new_product replicate-do-table = shop_ro.news_cats replicate-do-table = shop_ro.news_txs replicate-do-table = shop_ro.orderstatlist replicate-do-table = shop_ro.orderstatname replicate-do-table = shop_ro.partner_news replicate-do-table = shop_ro.partner_payment replicate-do-table = shop_ro.partner_product_stake replicate-do-table = shop_ro.partner_refhost replicate-do-table = shop_ro.partner_stake_shop replicate-do-table = shop_ro.partner_vip_shop replicate-do-table = shop_ro.payment replicate-do-table = shop_ro.person replicate-do-table = shop_ro.person_type replicate-do-table = shop_ro.players replicate-do-table = shop_ro.price_range replicate-do-table = shop_ro.prodrelation replicate-do-table = shop_ro._product_document replicate-do-table = shop_ro._product_document_type replicate-do-table = shop_ro.product replicate-do-table = shop_ro.product_detail_group replicate-do-table = shop_ro.product_detail_type replicate-do-table = shop_ro.product_document replicate-do-table = shop_ro.product_document_type replicate-do-table = shop_ro.product_ext_data replicate-do-table = shop_ro.product_ext_data_value replicate-do-table = shop_ro.product_ext_desc replicate-do-table = shop_ro.product_isbn replicate-do-table = shop_ro.product_ordered_with replicate-do-table = shop_ro.product_person replicate-do-table = shop_ro.product_rating replicate-do-table = shop_ro.product_supplier replicate-do-table = shop_ro.product_type replicate-do-table = shop_ro.product_type_property replicate-do-table = shop_ro.pub_banner replicate-do-table = shop_ro.pub_banner_group replicate-do-table = shop_ro.pub_banner_group_banner replicate-do-table = shop_ro.pub_banner_group_catrelation replicate-do-table = shop_ro.review replicate-do-table = shop_ro.shop replicate-do-table = shop_ro.shop_group replicate-do-table = shop_ro.shop_product replicate-do-table = shop_ro.shop_setting_value replicate-do-table = shop_ro.shop_settings replicate-do-table = shop_ro.shop_settings_list replicate-do-table = shop_ro.tax replicate-do-table = shop_ro.top_product replicate-do-table = shop_ro.user_account replicate-do-table = shop_ro.user_account_operation replicate-do-table = shop_ro.vote replicate-do-table = shop_ro.zone_country replicate-do-table = shop_ro._fo_optimize_cats replicate-rewrite-db = mb->mb_ro replicate-do-db = mb_ro replicate-do-table = mb_ro.categories replicate-do-table = mb_ro.export_models3 replicate-do-table = mb_ro.export_models_xml2 replicate-do-table = mb_ro.export_objects replicate-do-table = mb_ro.object_link_type # END OF REPLICATION parameters query_cache_size = 256M query_cache_type = 1 max_connections=500 # Slow queries hunt log-slow-queries=/var/log/mysql/cutter-slow.log long_query_time=0.5 ## misc # Workaround against massive long select locks # In case when all select's are locked due to # insert followed by huge select # May lead to DML queries starvation. low_priority_updates = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=100000 # Uncomment the following if you are using Innobase tables innodb_data_home_dir = /var/lib/mysql-innodb/ innodb_log_group_home_dir = /var/log/innodb/ innodb_data_file_path = ibdata1:100M:autoextend:max:30000M set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=256M set-variable = innodb_log_buffer_size=256M innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT set-variable = innodb_buffer_pool_size=3072M set-variable = innodb_additional_mem_pool_size=24M set-variable = innodb_file_io_threads=8 set-variable = innodb_thread_concurrency=12 set-variable = innodb_lock_wait_timeout=320 # Point the following paths to different dedicated disks tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname #!!!!!!!!!!!!!!! LOG !!!!!!!! #log [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] skip-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout