Skip to main content

MySQL - disable bin log

Suddenly our forum server unexpectedly give a error message like the web server is dead. So further investigation I found that the /var filesystem is full because of some of the log file size is kinda big. So I plan to disable the bin log file from MySQL which I found that it's quite big :)



-rw-rw----  1 mysql  mysql   631M Dec 19 01:36:56 2009 mysql-bin.000001
-rw-rw----  1 mysql  mysql   2.3M Dec 22 23:09:47 2009 mysql-bin.000002
-rw-rw----  1 mysql  mysql   8.2K Dec 22 23:15:27 2009 mysql-bin.000003
-rw-rw----  1 mysql  mysql   4.3K Dec 22 23:21:13 2009 mysql-bin.000004
-rw-rw----  1 mysql  mysql   125B Dec 25 14:27:18 2009 mysql-bin.000005
-rw-rw----  1 mysql  mysql   125B Dec 25 16:16:06 2009 mysql-bin.000006
-rw-rw----  1 mysql  mysql   125B Apr 24 00:32:48 2011 mysql-bin.000007
-rw-rw----  1 mysql  mysql   332B Apr 24 00:36:37 2011 mysql-bin.000008
-rw-rw----  1 mysql  mysql   1.0G Apr 25 00:25:21 2011 mysql-bin.000009
-rw-rw----  1 mysql  mysql   1.0G Apr 29 13:46:53 2011 mysql-bin.000010
-rw-rw----  1 mysql  mysql   1.0G May  4 15:54:24 2011 mysql-bin.000011
-rw-rw----  1 mysql  mysql   1.0G May  9 16:10:17 2011 mysql-bin.000012
-rw-rw----  1 mysql  mysql   133M May 10 20:47:45 2011 mysql-bin.000013
-rw-rw----  1 mysql  mysql   3.1M May 10 21:21:25 2011 mysql-bin.000014

1) Find /etc/my.cnf

2) Find the line

log-bin=mysql-bin

3) Comment out the line

4) Restart service
/usr/local/etc/rc.d/mysql-server restart

yatta

Comments

Post a Comment

Popular posts from this blog

DirectAdmin - Upgrading MySQL from 5.5 to 5.6

cd /usr/local/directadmin/custombuild mkdir -p mysql cd mysql wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-client-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-devel-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-server-5.5.41-1.linux2.6.x86_64.rpm wget http://files.directadmin.com/services/all/mysql/64-bit/5.5.41/MySQL-shared-5.5.41-1.linux2.6.x86_64.rpm cd .. ./build mysql_backup mv mysql_backups mysql_backups.`date +%F` #after this point, you can't abort rpm -e --noscripts `rpm -qa | grep MariaDB` cd mysql rpm -ivh MySQL*5.5.41*.rpm #ensure it's running. cd .. ./build set mysql 5.6 ./build set mysql_inst yes ./build mysql # confirm mysqld is running. ./build php n
Post a Comment
Read more

MySQL Enterprise thingy

It's been a weird thing when you install MySQL server especially the one that is 'enterprise' version is not working with your PHP. That is the problem that my friend and I facing today. Since PHP require php-mysql extension to connect to MySQL server but php-mysql is only work with mysql-server from the Repos (Redhat/Centos). 1) Remove default mysql-server/php-mysql 2) Install MySQL Enterprise 3) Dependencies conflict occur + headache + install php-mysql shell> yum install php-mysql Loaded plugins: rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package php-mysql.x86_64 0:5.1.6-27.el5 set to be updated --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql --> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql --> Running transaction check ---> Package mysql.x86_64 0:5.0.77-4.el5_4.2 set to be updated --> Process...
2 comments
Read more

Complete guide to update/upgrade cakephp

This is what people always forgotten. How to update your cakephp to the latest from CLI         phpmamp composer.phar update How to upgrade to 3.* branch     phpmamp composer.phar require --update-with-dependencies "cakephp/cakephp:3.5.*"         ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev)       - Removing cakephp/cakephp (3.4.13)       - Installing cakephp/cakephp (3.5.6)         Downloading: 100% Writing lock file Generating autoload files Done !
Post a Comment
Read more