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

Python - Xen and libvirt

more function can be found in python dir libvirtclass.txt shell> find / -name libvirtclass.txt Generated Classes for libvir-python # # Global functions of the module # # functions from module libvirt open() openReadOnly() virEventRegisterImpl() virInitialize() # functions from module virterror virGetLastError() virResetLastError() # # Set of classes of the module # Class virDomain()     # functions from module libvirt     ID()     OSType()     XMLDesc()     attachDevice()     blockPeek()     connect()     coreDump()     create()     destroy()     detachDevice()     maxMemory()     maxVcpus()     memoryPeek() migrate()     name()     reboot()     ref()     resume()     save()     setAutostart()     setMaxMemory()     setMemory()     setVcpus()     shutdown()     suspend()     undefine()     # functions from module python     UUID()     UUIDString()     autostart()     blockStats()     info()     interfaceStats()     pinVc
Post a Comment
Read more

Building a KVM Proxy

Traditionally we seldomly connect our KVM from the port directly to the server that consists of usb for keyboard and mouse, vga cable for display purposes. More advanced you may have an experience using the iKVM which connect all you kvm port from the internet where you can have a remote location as long as you have the internet connection. When technology evolve, physical server are becoming obsolete since we have the virtualization technology. Since that to access your virtual machine (vm) are more easier. Instead of using SSH, like a Xen hypervisor, the Xen itself can host as a KVM server and map to the vm on different port as configured from the config file.
Post a Comment
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