What Are mysql-bin files, How to Delete Them?

By | March 7, 2019

Sometimes, when you run out of space, you can see that there are lots of files like

mysql-bin.000131

in your mysql directory (usually /var/lib/mysql). How can you delete these logs without harming your server?

These are mysql binary log files. These are files that contain information about data modifications, that were made by the MySQL server. The log consists of a set of binary log files, plus an index file, so you cannot just use rm to delete them all. In 99.9% cases these files are useless and your server can work without them.

Fortunately, there is a simple MySQL command that will allow you to clean them. Let me share it.

First of all, login as root.

mysql -uroot -p

Then, use the following command:

PURGE BINARY LOGS BEFORE NOW();

The command above will delete all these old files, and only the latest one will be left. In 5 seconds about 25 Gb on my server were available again.

170 thoughts on “What Are mysql-bin files, How to Delete Them?

  1. zakupy online

    You’re truly a just right webmaster. The web site loading speed is amazing.

    It seems that you are doing any unique trick. Furthermore, the contents are masterwork.
    you have performed a great activity on this matter!
    Similar here: sklep online and also here: Bezpieczne zakupy

    Reply
  2. ecommerce

    Hey! Do you know if they make any plugins to assist with
    SEO? I’m trying to get my blog to rank for some targeted keywords
    but I’m not seeing very good gains. If you know of any please
    share. Cheers! You can read similar article here: E-commerce

    Reply
  3. ecommerce

    Hey there! Do you know if they make any plugins to help with Search
    Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but
    I’m not seeing very good results. If you know of
    any please share. Many thanks! You can read similar art here:
    Najlepszy sklep

    Reply
  4. najlepszy sklep

    Hello! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get
    my blog to rank for some targeted keywords but I’m not seeing very
    good success. If you know of any please share. Thanks!
    You can read similar blog here: Najlepszy sklep

    Reply
  5. GSA List

    Good day! Do you know if they make any plugins
    to assist with SEO? I’m trying to get my website to rank for some targeted keywords but I’m not
    seeing very good results. If you know of any please share.

    Cheers! You can read similar art here: Backlink Building

    Reply
  6. GSA Verified List

    Hello! Do you know if they make any plugins to assist with
    Search Engine Optimization? I’m trying to get my blog to rank
    for some targeted keywords but I’m not seeing very good success.
    If you know of any please share. Appreciate it!
    I saw similar art here: Scrapebox AA List

    Reply
  7. Backlink Portfolio

    Hey there! Do you know if they make any plugins to help with Search
    Engine Optimization? I’m trying to get my site to rank for some targeted keywords but I’m
    not seeing very good success. If you know of any
    please share. Thank you! You can read similar article here: Backlink Building

    Reply
  8. Kristi05

    Wow, superb blog layout!
    How long have you ever been running a blog for?
    you make blogging glance easy. The full look of your web site
    is great, as smartly as the content material! I saw similar here prev
    next and those was wrote by
    Emile98.

    Reply
  9. Nadine99

    Wow, marvelous blog layout!
    How long have you ever been blogging for? you make running a blog glance
    easy. The entire glance of your website is wonderful, as smartly as the content material!
    I read similar here prev next and those was wrote by Vania92.

    Reply
  10. Monte70

    Wow, marvelous weblog layout!

    How long have you been running a blog for? you made blogging glance easy.
    The total glance of your website is great, as neatly
    as the content! I saw similar here prev next and those
    was wrote by Mikki72.

    Reply
  11. Rachel98

    Wow, wonderful weblog layout!

    How lengthy have you been blogging for? you make blogging look easy.

    The total look of your web site is fantastic, let alone the
    content! You can see similar here prev next and those was wrote by Amy89.

    Reply
  12. CoryNar

    Wow, amazing weblog layout!
    How lengthy have you ever been running a blog for?
    you made running a blog look easy. The entire glance of your site is wonderful,
    let alone the content material! You can see similar here prev next and that was wrote by King61.

    Reply
  13. senin ben bas bacini sikiyim

    This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!

    Reply
  14. julie cash porn

    Very well presented. Every quote was awesome and thanks for sharing the content. Keep sharing and keep motivating others.

    Reply
  15. porn videos

    This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!

    Reply
  16. nina kayy porn

    I’m often to blogging and i really appreciate your content. The article has actually peaks my interest. I’m going to bookmark your web site and maintain checking for brand spanking new information.

    Reply
  17. penis buyutucu

    For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.

    Reply
  18. here

    Your blog is a wealth of information. I always learn something new from your posts. This one was particularly enlightening. Great job!blogpulse

    Reply
  19. website

    You have a real gift for writing. Your posts are always so engaging and full of valuable information. Keep up the great work!nexusnook

    Reply
  20. the gas safe register

    I¡¦ll immediately clutch your rss feed as I can not find your email subscription link or e-newsletter service. Do you have any? Kindly permit me realize in order that I could subscribe. Thanks.

    Reply
  21. i gas engineers plumbing & heating

    After study a handful of the web sites for your web site now, and i also genuinely such as your technique for blogging. I bookmarked it to my bookmark site list and you will be checking back soon. Pls look at my site as well and let me know if you agree.

    Reply
  22. gas registered plumbers near me

    Some excellent secrets that can be learnt from the post. I have now come to understand that that a person can really be successful on this issue and acquire additional skills and qualities by reading a weblog like yours. Thank you for the interesting tips you’ve shared here.

    Reply
  23. heating gas engineer

    My spouse and i have been very peaceful that Edward managed to finish up his inquiry out of the ideas he acquired through the web page. It is now and again perplexing to just find yourself giving away information and facts which usually some other people could have been making money from. We remember we need the website owner to be grateful to for that. All of the explanations you’ve made, the straightforward web site menu, the relationships your site assist to instill – it is all fabulous, and it’s assisting our son and us understand that topic is exciting, which is very indispensable. Many thanks for all!

    Reply
  24. met 1 gas safe engineer

    I and also my guys came digesting the excellent tips and tricks found on the website then quickly I got a terrible feeling I never thanked the blog owner for those techniques. Most of the ladies are actually totally thrilled to read through them and have now sincerely been loving those things. Thanks for getting very considerate and for picking varieties of marvelous subject matter most people are really eager to discover. My very own honest apologies for not expressing gratitude to you sooner.

    Reply
  25. air duct cleaning services

    There are some attention-grabbing time limits on this write-up but I don’t know if I see all of them heart to heart. There may possibly be some validity but I will consider maintain viewpoint until I look into it additional. Great article , thanks and we want additional! Added to FeedBurner at the same time.

    Reply
  26. after hours ac repair

    Outstanding read, I just passed this onto a colleague who was doing a little investigation on that. And he really bought me lunch because I discovered it for him smile So let me rephrase that: Thanks for lunch!

    Reply
  27. hvac heat exchanger replacement

    We stumbled over here by a different web page and thought I should check things out. I like what I see so now i’m following you. Look forward to looking over your web page yet again.

    Reply
  28. gas safe plumber

    It absolutely was any exhilaration finding your site yesterday evening. We arrived here these days seeking something totally new. I used to be not disappointed. Your opinions on brand new approaches on this factor were helpful as well as an superb help to me personally. Appreciate leaving out time to write out these items and for discussing your thoughts.

    Reply
  29. home ac repair

    For illustration, create suppliers have worked with the Food & Drug Administration (FDA) to make sure that the industry criteria developed outcome in the most beneficial and most successful processes. And to communicate any public announcements, the marketplace has formulated relationships with associations like the Nationwide Grocer’s Association (NGA).

    Reply
  30. gas safe plumber

    Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you could do with a few pics to drive the message home a little bit, but other than that, this is fantastic blog. A fantastic read. I’ll definitely be back.

    Reply
  31. duct cleaning near me

    I think this is one of the most vital information for me. And i’m glad reading your article. But wanna remark on some general things, The web site style is wonderful, the articles is really nice : D. Good job, cheers

    Reply
  32. certified gas engineer near me

    I do accept as true with all the ideas you have offered in your post. They are really convincing and can definitely work. Still, the posts are too quick for novices. May just you please prolong them a bit from next time? Thank you for the post.

    Reply
  33. central air repair near me

    I am often to blogging we actually appreciate your posts. The content has truly peaks my interest. I am going to bookmark your web site and maintain checking achievable data.

    Reply
  34. gas valve replacment

    Hello There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and return to read more of your useful info. Thanks for the post. I’ll certainly comeback.

    Reply
  35. certified gas fitters near me

    Howdy, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam comments? If so how do you prevent it, any plugin or anything you can suggest? I get so much lately it’s driving me insane so any assistance is very much appreciated.

    Reply
  36. central air repair near me

    You’re the best, I was doing a google search and your site came up for bank owned homes in Winter Springs, FL but anyway, I have had a pleasant time reading it, keep it up!

    Reply
  37. lpg gas fitters

    Great weblog here! Also your web site lots up very fast! What host are you the usage of? Can I am getting your affiliate hyperlink for your host? I want my web site loaded up as fast as yours lol.

    Reply
  38. air conditioner maintenance near me

    Howdy. Very nice web site!! Guy .. Excellent .. Wonderful .. I’ll bookmark your web site and take the feeds additionally…I am satisfied to locate numerous helpful information here within the article. Thank you for sharing.

    Reply
  39. gas cooker service engineer near me

    Thanks for any other informative website. Where else may just I am getting that kind of info written in such an ideal means? I’ve a mission that I’m just now working on, and I have been at the glance out for such info.

    Reply
  40. good escape room

    Good day! Do you know if they make any plugins
    to assist with SEO? I’m trying to get my website to rank for some targeted keywords but I’m not seeing very good success.
    If you know of any please share. Cheers! I saw similar article here:
    All escape rooms

    Reply
  41. ac maintenance services

    Positive points apparel it all check to two different females: old Zune company owners that focusing on an upgrade, and individuals seeking to determination between a Microsoft zune and an ipod devices. (San francisco spa battlers worthwhile considering about, for instance the The Personal stereo By, however , Truly hope guarantees you sufficient statistics that helps make an informed resolution with the Zune instead of manufacturers other than ipod range same.)

    Reply
  42. gas engineer services

    fantastic submit, very informative. I ponder why the opposite experts of this sector do not understand this. You must proceed your writing. I’m sure, you have a great readers’ base already!

    Reply
  43. 24 hour heating repair

    An impressive share, I just given this onto a colleague who was doing a little evaluation on this. And he in reality bought me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love studying extra on this topic. If potential, as you develop into expertise, would you mind updating your weblog with extra particulars? It’s extremely useful for me. Huge thumb up for this weblog submit!

    Reply
  44. ductless heating and cooling

    Intimately, the article is in reality the most excellent on that precious topic. I agree with your conclusions and will thirstily look forward to your coming updates. Simply saying thanks definitely will not simply be sufficient, for the phenomenal lucidity in your writing. I definitely will at once grab your rss feed to stay informed of any kind of updates. Fabulous work and also much success in your business dealings!

    Reply
  45. air conditioning service

    Dude.. I am not much into reading, but somehow I got to read many articles on your blog. Its amazing how interesting it is for me to stop by you pretty often.

    Reply
  46. �irig teblayorgnik

    This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!

    Reply
  47. domestic gas engineer

    I’m usually to blogging and that i really appreciate your articles. The actual article has really highs my personal curiosity. I am going to bookmark your own site and maintain checking for brand spanking new info.

    Reply
  48. find local gas safe engineer

    Thx for your personal great post! I seriously liked reading this, you’re an great author. I shall always save your blog and will eventually revisit at some point. We wish to motivate continue your terrific work, have a nice holiday weekend… FYI have you read Syria eye-popping news reports? Cheers … Easy Website Builder

    Reply
  49. gas valve replacment

    This site is actually a walk-through its the internet you desired about it and didn’t know who to ask. Glimpse here, and you’ll absolutely discover it.

    Reply
  50. gas boiler fitters

    I do accept as true with all the ideas you have presented in your post. They are very convincing and will certainly work. Still, the posts are very quick for starters. Could you please prolong them a bit from subsequent time? Thank you for the post.

    Reply
  51. tiktok video downloader

    Hi, I do think this is an excellent website. I stumbledupon it ;) I will return yet again since I book marked it. Money and freedom is the best way to change, may you be rich and continue to help other people.

    Reply
  52. home air conditioner maintenance

    Hey! Someone in my Facebook group shared this website with us so I came to look it over. I’m definitely enjoying the information. I’m bookmarking and will be tweeting this to my followers! Wonderful blog and fantastic style and design.

    Reply
  53. ac blower repair

    Hey! I know this is kinda off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!

    Reply
  54. lpg gas installers near me

    Undeniably believe that which you said. Your favorite reason seemed to be on the net the simplest thing to be aware of. I say to you, I certainly get annoyed while people think about worries that they plainly don’t know about. You managed to hit the nail upon the top and defined out the whole thing without having side-effects , people could take a signal. Will probably be back to get more. Thanks

    Reply
  55. Mike

    I have been browsing on-line more than 3 hours lately, but I by no means discovered any attention-grabbing article like yours. It’s pretty worth sufficient for me. In my view, if all web owners and bloggers made good content material as you did, the net can be much more useful than ever before!

    Reply
  56. ac maintenance services

    Good day! Do you know if they make any plugins to protect against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

    Reply
  57. Professional AC installation

    I am commenting to make you understand what a great encounter our girl encountered checking your site. She learned a wide variety of details, most notably what it is like to have a wonderful giving nature to have other folks clearly learn chosen extremely tough matters. You actually did more than readers’ desires. Many thanks for displaying such precious, trusted, revealing and as well as fun guidance on the topic to Emily.

    Reply
  58. heat pump repair

    Good post. I study one thing tougher on totally different blogs everyday. It can all the time be stimulating to learn content from different writers and observe a bit of something from their store. I’d favor to use some with the content material on my weblog whether or not you don’t mind. Natually I’ll offer you a link on your web blog. Thanks for sharing.

    Reply
  59. heat pump maintenance

    I do agree with all the ideas you’ve presented in your post. They are really convincing and will certainly work. Still, the posts are too short for newbies. Could you please extend them a bit from next time? Thanks for the post.

    Reply
  60. emergency air conditioner repair

    Nice post. I learn something tougher on distinct blogs everyday. Most commonly it is stimulating to see content off their writers and use a little there. I’d want to use some with all the content on my blog whether you don’t mind. Natually I’ll offer you a link on the web weblog. Many thanks sharing.

    Reply
  61. heating and cooling repair

    Fine website, in which did you come up with the info in this piece? I¡¯m pleased I uncovered it though, ill be checking back quickly to find out what other content articles you might have.

    Reply
  62. Quiet air conditioning options

    An interesting discussion might be priced at comment. I do think that you need to write read more about this topic, it might be described as a taboo subject but typically consumers are not enough to communicate on such topics. To another location. Cheers

    Reply
  63. duct cleaning near me

    I have to show my appreciation to the writer just for bailing me out of this particular circumstance. Just after exploring throughout the world-wide-web and finding solutions that were not beneficial, I figured my life was over. Living without the approaches to the difficulties you’ve fixed through your good short post is a crucial case, and those that would have badly affected my entire career if I had not come across your site. Your personal knowledge and kindness in touching the whole thing was useful. I don’t know what I would have done if I hadn’t come across such a thing like this. I can also now relish my future. Thanks a lot so much for the impressive and amazing help. I won’t be reluctant to suggest your web page to any person who desires guidance on this matter.

    Reply
  64. ductless heating and cooling

    The the very next time I read a weblog, Hopefully that this doesnt disappoint me as much as this blog. I am talking about, It was my method to read, but I really thought youd have something fascinating to state. All I hear is a few whining about something you could fix if you werent too busy seeking attention.

    Reply
  65. mp3juice

    Aw, this was an exceptionally good post. Taking the time and actual effort to make a top notch article… but what can I say… I put things off a whole lot and don’t manage to get nearly anything done.

    Reply
  66. duct cleaning near me

    I’d need to consult you here. Which isn’t some thing Which i do! I enjoy reading a post that can make people feel. Also, appreciate your allowing me to comment!

    Reply
  67. Ductless mini-split installation

    Walking out and about into the Online marketing arena can be quite a overwhelming endeavor for lawyer search engine optimization that novice internet business small business owner. These we outline twelve with a vey important details that will keep in mind making plans for the first plan.

    Reply
  68. ductwork cleaning

    This is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your posts, I guess I am not the only one having all the enjoyment here! Keep up the excellent work.

    Reply
  69. commercial hvac

    Nice post. I discover something very complicated on distinct blogs everyday. Most commonly it is stimulating to read content off their writers and use a specific thing from their store. I’d would rather apply certain with all the content on my own blog no matter whether you do not mind. Natually I’ll supply you with a link for your internet weblog. Many thanks sharing.

    Reply
  70. commercial hvac services

    This is some agreeable material. It took me some time to finally find this web page but it was worth the time. I noticed this article was buried in yahoo and not the first spot. This web site has a lot of fine stuff and it doesnt deserve to be burried in the searches like that. By the way I am going to add this web publication to my list of favorites.

    Reply
  71. ductwork cleaning

    Very easily, the post is really the greatest on this precious topic. I harmonise with your conclusions and also definitely will thirstily look forward to your incoming updates. Simply just saying thanks can not simply just be enough, for the extraordinary lucidity in your writing. I definitely will quickly grab your rss feed to stay abreast of any kind of updates. Genuine work and much success in your business endeavors!

    Reply
  72. 24 hour air conditioning service near me

    After study several of the web sites with your website now, we truly much like your technique for blogging. I bookmarked it to my bookmark site list and will also be checking back soon. Pls have a look at my web site in addition and told me how you feel.

    Reply
  73. air conditioner fan repair

    I’ve been browsing on-line greater than three hours nowadays, but I never discovered any attention-grabbing article like yours. It?¦s pretty value enough for me. In my view, if all webmasters and bloggers made just right content as you probably did, the internet will probably be much more useful than ever before.

    Reply
  74. emergency heating service near me

    Thanks for the several tips shared on this weblog. I have seen that many insurance carriers offer shoppers generous savings if they favor to insure a couple of cars together. A significant quantity of households have got several cars or trucks these days, particularly those with older teenage kids still living at home, as well as savings upon policies may soon begin. So it is good to look for a good deal.

    Reply
  75. air condition repair

    I’m truly enjoying the design and layout of your website. It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a developer to create your theme? Exceptional work!

    Reply
  76. air conditioner not cooling

    Hiya, I’m really glad I have found this info. Nowadays bloggers publish just about gossips and web and this is really frustrating. A good blog with exciting content, that is what I need. Thank you for keeping this site, I’ll be visiting it. Do you do newsletters? Cant find it.

    Reply
  77. heat pump repair

    I am still learning of your stuff, and i am attempting to achieve my objectives. I completely adore reading through all that is written in your website. Maintain the actual ideas arriving for long term ! Thanks !

    Reply
  78. hvac repair

    There are some interesting points at some point in this post but I do not know if they all center to heart. There exists some validity but I most certainly will take hold opinion until I look into it further. Very good article , thanks so we want a lot more! Added onto FeedBurner likewise

    Reply
  79. emergency ac repair

    I’d have to examine with you here. Which isn’t something I usually do! I take pleasure in studying a publish that can make individuals think. Additionally, thanks for permitting me to comment!

    Reply
  80. youtube to mp3 downloader

    After exploring a few of the articles on your site, I truly appreciate your way of blogging. I saved as a favorite it to my bookmark website list and will be checking back in the near future. Please visit my web site too and tell me your opinion.

    Reply
  81. air conditioner service

    Hey! I know this is kinda off topic but I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog post or vice-versa? My blog addresses a lot of the same topics as yours and I believe we could greatly benefit from each other. If you happen to be interested feel free to shoot me an email. I look forward to hearing from you! Excellent blog by the way!

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *