Review Fine Tuning
Recommended and changed values for server settings:
query_cache_size 32M
tmp_table_size 32M
max_heap_table_size 32M
table_cache 500
innodb_buffer_pool_size 2G
Tools for live monitoring
- mytop
- inntop
Tools for analysis and hints for changes
- consider increasing the buffer pool (all extra space should go there)
- check out the query_cache, but don't put too much memory in the query_cache as it can actually increase load times
Ubuntu 15.04 and MySQL 5.6
- /etc/security/limits.conf
mysql soft nofile 65535 mysql hard nofile 65535
- /lib/systemd/system/mysql.service LimitNOFILE=infinity LimitMEMLOCK=infinity
Replication http://dev.mysql.com/doc/refman/5.1/de/replication.html http://dev.mysql.com/doc/refman/5.1/de/replication-howto.html http://www.thomas-krenn.com/de/wiki/MySQL_Replikation
- Export DB on Master: mysqldump --all-databases --allow-keywords --single-transaction --flush-logs --master-data=2 -r all.sql
- Import all.sql into Slave
- Start replaction (use binlog file and position from header in all.sql): apb mysqlslave --limit=HOSTNAME -tags=changemaster --extra-vars 'binlog=[MASTER_LOG_FILE] binpos=[MASTER_LOG_POS] port=####' Check Slave Status: a HOSTNAME -m mysql_replication