Posted in

Disable MySQL bin log on Bitnami

if you have cloud sevrer with less disk space, it is better disable MySQL bin log as it take approx 3 GB of disk space on bitnami server.

To disable MySQL binlog, edit mysql config file.

vi /opt/bitnami/mysql/my.cnf

Find

[mysqld]

Add below

disable_log_bin

Here is what i have in the my.cnf

root@wordpress-vm:~# cat /opt/bitnami/mysql/my.cnf

[mysqladmin]

user=root

[mysqld]

disable_log_bin basedir=/opt/bitnami/mysql datadir=”/opt/bitnami/mysql/data” port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock tmpdir=/opt/bitnami/mysql/tmp max_allowed_packet=32M bind-address=127.0.0.1 skip-name-resolve=1 default-authentication-plugin=mysql_native_password character-set-server=UTF8 collation-server=utf8_general_ci

[client]

port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock default-character-set=UTF8

[manager]

port=3306 socket=/opt/bitnami/mysql/tmp/mysql.sock pid-file=/opt/bitnami/mysql/tmp/manager.pid default-mysqld-path=/opt/bitnami/mysql/bin/mysqld.bin !include /opt/bitnami/mysql/bitnami/my.cnf root@wordpress-vm:~#

Now restart MySQL

/opt/bitnami/ctlscript.sh stop mysql
/opt/bitnami/ctlscript.sh start mysql

You can now remove the file starting with binlog from folder /opt/bitnami/mysql/data

rm -f /opt/bitnami/mysql/data/binlog.*
Visited 1 times, 1 visit(s) today

Leave a Reply

Your email address will not be published. Required fields are marked *