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

Warning Nuffnanger's!

Dear Nuffnangers, As you might already know, there are 2 different types of campaigns from Nuffnang: Metered (mCPM) Campaigns , which pay according to the number of visitors who see the ads; and Cost-Per-Click (CPC) campaigns, which pay bloggers based on the number of clicks generated on the ads. It has come to our attention that certain groups have been committing click fraud, which is defined as clicking on CPC advertisements intentionally just to generate earnings for a blog's owner. Do note that this act is an abuse of our Terms & Conditions under Section 6. Banner ads are only supposed to be clicked on if the viewer is interested to find out more about the advertising campaign, and not for the intention of earning extra money. Should this situation worsen, the frequency of ad campaigns might be significantly reduced as we'll only be able to sell ad spaces on blogs with no click fraud record. Our system is capable of tracking these illegal actions...
2 comments
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

Zenclouds October Promotion - Malaysia VPS Hosting

For those who are not familiar with what Zenclouds.com is , check this out : Zenclouds subsidiary of Art In Software Sdn Bhd is an industry-leading, privately virtual private server hosting and software services provider with headquarters in Malaysia. Since 2003, the company has provided businesses worldwide with reliable, high-capacity networks to host websites, email, business applications, video and other modern, rich-media content. Zenclouds evolve in one year of research and development mainly focus on Control Panel for managing virtual private server. Zenclouds integrate between Xen technologies and our own Control Panel to ease our customer managing multiple server with different Data Center with one control panel. Zenclouds integrates the industry's best technologies for each customer's specific need and delivers it as a service via the company's commitment and support. For this upcoming October you can win and own a brand new iPod Shuffle, Nano and Touch when y...
3 comments
Read more