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

Popular posts from this blog

FreeBSD :- Nginx , PHP-FPM

One of my forum that I managed previously used Apache as a web server. From my observation Apache with PHP suck a lot of memory resources but that doesn't hang up the server. So google around and I found others using Apache as a proxy using reverse proxy. While Nginx serve as front end web server. The result is good! Nginx still using minimum memory usage! impressive :) But that's does not stop me from searching other solution that best for the forum, and I found solution for Nginx with PHP-FPM (FastCGI Process Manager). Before that I've tried with spawn-fcgi but the process had died repeatedly. Not satisfied with that I've tried PHP-FPM ! Now stick with Nginx + PHP-FPM very satisfied! :)

Python - How to check active domain

This is python and libvirt related post, beware!! Ok now I want to check from my script, let's say : bash> xencheck.py nameofvps So I want the script to check if the vps name is available and active. This is what I done : #!/usr/bin/python -u import libvirt import sys import os def Startup():  if not os.access("/proc/xen", os.R_OK):     print "System is not running Xen kernel!"     sys.exit(1) #connect to hypervisor conn = libvirt.open("xen:///default") if conn == None:     print 'Failed to connect to hypervisor'     sys.exit(1) dom0 = conn.listDomainsID() for id in dom0:  dom1 = conn.lookupByID(id)  if dom1.name() == sys.argv[1]:   print dom1.name() #main function to execute def main():  Startup() if __name__ == "__main__":  main()

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...