[mysqld] # --Master replication options server_id=1 log-bin=minime-bin binlog_format=MIXED replicate-ignore-table=mobile_analytics.device_selections_BH replicate-wild-ignore-table=I.q% datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 max-allowed-packet=512M #init-file=/usr/local/wirelesswerx/init-script.sql #init-file=/usr/local/wirelesswerx/populate_memory_tables.sql max-connections=512 default_time_zone=SYSTEM #skip-locking key_buffer_size = 256M table_open_cache = 256 sort_buffer_size = 50M read_buffer_size = 1M read_rnd_buffer_size = 4M thread_cache_size = 8 thread_concurrency = 8 query_cache_size= 16M max_heap_table_size = 536870912 myisam_sort_buffer_size = 64M innodb_buffer_pool_size = 2G max-connect-errors=10000 [mysqld_safe] timezone=UTC log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid