Skip to main content

Mysqld-bin logs problem

After continuous running of Mysql server, I've noticed that /var/lib/mysql directory uses too much disk space. The reason of that problem was a set of mysqld-bin.xxxxxx files. Each of that file was 1GB in size. First I thought that I can stop the Mysql server and remove that files, but I didn't want to act this way because there was sensitive data in databases that I didn't want to loose. So I found the better way to achieve this. Connect to Mysql server and perform the following

mysql> flush logs;

mysql> reset master;

That's it! After that the all logbin files should be removed. Also you can disable mysqld-bin logging completely by commenting out log-bin line in my.cnf and restarting Mysql server daemon.
Labels:

Comments

  1. 静墨寒鱼February 26, 2010 at 12:48 AM

    I had try to delete this files ,that I found if I delete this files ,mysql server won't start

    ReplyDelete
  2. AnonymousApril 1, 2010 at 12:30 AM

    gj, ty!

    ReplyDelete
  3. theRemixApril 22, 2010 at 10:12 PM

    thanks! this helped me

    ReplyDelete
  4. 静墨寒鱼April 22, 2010 at 10:50 PM

    能评论中文吧

    ReplyDelete
  5. AnonymousJune 2, 2010 at 7:13 AM

    thanks man !

    ReplyDelete
  6. LaebshadeFebruary 9, 2011 at 10:16 AM

    Old post, but thanks for that! I have a Slicehost and with the limited space, I was wondering where it went. Thanks!

    ReplyDelete
  7. AnonymousDecember 30, 2011 at 11:53 PM

    Yes, excellent, thanks!

    ReplyDelete
  8. UnknownOctober 10, 2012 at 10:56 AM

    greate

    ReplyDelete
  9. AnonymousNovember 8, 2012 at 2:33 PM

    I really needed this command very badly, indeed. Thank you very much for getting this posted - I don't care how long ago!!!

    ReplyDelete
  10. AnonymousJanuary 21, 2013 at 6:49 AM

    Yup, saved me from having to search around mysql's site, thanks!

    ReplyDelete

Post a Comment

Popular posts from this blog

Increase USB Flash Drive Write Speed

The one of the biggest problems of usb flash drives is a slow data write speed. This article will guide you through the process that can possibly increase your flash stick write speed. Okay, first I bought Transcend 8GB usb flash stick. It had been formatted with FAT32 filesystem initially. So I decided to run data read/write speed test. Mount the filesystem and execute following # hdparm -t /dev/sdb /dev/sdb: Timing buffered disk reads: 102 MB in 3.05 seconds = 33.43 MB/sec $ dd count=100 bs=1M if=/dev/urandom of=/media/disk/test 100+0 records in 100+0 records out 104857600 bytes (105 MB) copied, 29.5112 s, 3.6 MB/s The disk read speed is good enough, but the write speed is not so good. That's because most of NAND flash drives (the most commonly used flash sticks) have 128k erase block size. Filesystems usually have 4k (4096 bytes) block size. And here we came into problem. If the filesystem blocks are not aligned to flash drive blocks, the performance overhead during disk writ
43 comments
Read more

Alsa Audio Meter

If you need to watch the realtime sound output level on some graphical meter, you might consider difficult to find the program for these needs. After some searching I found nice software called ameter especially for these functions. This program can be used with the most of ALSA and OSS apps. After program installation you should create .asoundrc in your home directory with the following contents: pcm_scope.ameter { type ameter } pcm_scope_type.ameter { lib /usr/local/lib/libameter.so } pcm.ameter { type meter slave.pcm 'hw:0,0' #can be hw or hw:0,1 etc... scopes.0 ameter } pcm.dsp0 ameter The program source can be downloaded from here Also I have created an ebuild for easy installation on Gentoo Linux. Simply add it to your local overlay # Copyright 1999-2009 Gentoo Foundation # Distributed under the terms of the GNU General Public License v2 # $Header: $ EAPI="2" DESCRIPTION="Alsa meter plugin for audio software with GUI" HOMEPAGE="http://laugeo.free.
2 comments
Read more

Gentoo Portage SquashFS + zsync

If you are Gentoo user and you're wondering about how to reduce portage tree disk usage and makes emerge --sync faster, this article is for you. Lets talk about key problems of portage tree: Large disk usage because of uncompressed text data Heavy inode usage because of huge amount of files The above problems result in excessive disk I/O during emerge operations. The most popular solution is to squash the portage tree. It is well-described in  this article . But I've made an easier  script that can handle all the headache for you. I hope you like it! :)
Post a Comment
Read more