This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
building_mariadb_on_freebsd [2010/09/13 16:57] k2patel |
building_mariadb_on_freebsd [2010/09/13 17:06] k2patel |
||
---|---|---|---|
Line 115: | Line 115: | ||
run_rc_command "$1" | run_rc_command "$1" | ||
</code> | </code> | ||
+ | |||
+ | ==== Enable and Start ==== | ||
+ | |||
+ | Final steps.... (remember i am using Modular configure)\\ | ||
+ | |||
+ | <code bash | /etc/my.cnf> | ||
+ | |||
+ | [mysqld] | ||
+ | ## | ||
+ | ## Load Plugins | ||
+ | ## To specify cutom plugin dir use line below. | ||
+ | ## plugin_dir=/usr/local/lib/mysql/plugin | ||
+ | ## | ||
+ | |||
+ | plugin-load=ha_xtradb.so | ||
+ | |||
+ | ## | ||
+ | ## General Optimization | ||
+ | ## | ||
+ | |||
+ | open-files-limit=1024 | ||
+ | local-infile | ||
+ | character-set-server=utf8 | ||
+ | connect-timeout=60 | ||
+ | key_buffer_size=1M | ||
+ | sort_buffer=256K | ||
+ | max_heap_table_size=1M | ||
+ | |||
+ | ## | ||
+ | ## InnoDB Configuration. | ||
+ | ## | ||
+ | |||
+ | innodb_buffer_pool_size = 16M | ||
+ | innodb_additional_mem_pool_size = 2M | ||
+ | innodb_data_file_path = ibdata1:1024M:autoextend | ||
+ | innodb_log_file_size = 5M | ||
+ | innodb_log_buffer_size = 8M | ||
+ | innodb_log_files_in_group=2 | ||
+ | innodb_flush_log_at_trx_commit = 1 | ||
+ | innodb_lock_wait_timeout = 50 | ||
+ | innodb_file_per_table | ||
+ | |||
+ | ## | ||
+ | ## Setting Log / Bin expiry and name | ||
+ | ## | ||
+ | |||
+ | expire_logs_days=5 | ||
+ | log-bin=mysqld-bin | ||
+ | log-bin-trust-function-creators=1 | ||
+ | datadir=/usr/local/var | ||
+ | relay-log=freebsd-relay-bin | ||
+ | binlog-ignore-db=mysql,test | ||
+ | |||
+ | ## | ||
+ | ## Replication Options | ||
+ | ## | ||
+ | |||
+ | server-id=0 | ||
+ | |||
+ | #server-id=2 | ||
+ | #replicate-same-server-id=0 | ||
+ | #auto-increment-increment=5 | ||
+ | #auto-increment-offset=2 | ||
+ | #slave-net-timeout=120 | ||
+ | |||
+ | #master-host=192.168.1.3 | ||
+ | #master-user=repl | ||
+ | #master-password=password | ||
+ | #master-connect-retry=60 | ||
+ | #replicate-ignore-db=mysql,test | ||
+ | </code> | ||
+ | |||
+ | Enabled it in rc.conf | ||
+ | |||
+ | <code bash> | ||
+ | echo 'mysql_enable="YES"' >> /etc/rc.conf | ||
+ | </code> | ||
+ | |||
+ | Now start it using. | ||
+ | |||
+ | <code bash> | ||
+ | /usr/local/etc/rc.d/mysql-server start | ||
+ | </code> | ||
+ | |||
+ | ==== Error ==== | ||
+ | |||
+ | If you get any error related to DB not found (usually get created on first RUN). | ||
+ | |||
+ | <code bash> | ||
+ | mysql_install_db --datadir=/usr/local/var | ||
+ | </code> | ||
+ | |||
+ | ==== ENJOY!! Optimized Version of MySQL MariaDB==== | ||
+ | |||
+ | |||