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.
|
1 |
vi /opt/bitnami/mysql/my.cnf |
Find
|
1 |
[mysqld] |
Add below
|
1 |
disable_log_bin |
Here is what i have in the my.cnf
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
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
|
1 2 |
/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
|
1 |
rm -f /opt/bitnami/mysql/data/binlog.* |