mysql

clean excess binary logs from mysql - free up space

Posted in mysql
6041
1:16 am, July 4, 2023
 

clean excess binary logs from mysql - free up space

Update: 30 July 2023

I actually prefer this command, i just have to figure out why im getting so many binlog files!

MYSQL

PURGE BINARY LOGS BEFORE '2023-07-30 00:00:00';
PURGE BINARY LOGS BEFORE NOW(); 

go into /var/lib/mysql/

check the latest bin log file name

e.g: binlog.000319

load mysql command

run the following to purge all bin log files before the last one. 

MYSQL

PURGE BINARY LOGS TO 'binlog.000319';

Check the disk space

df -h

This should now free up a lot more space!

HTML

Filesystem     1K-blocks     Used Available Use% Mounted on
udev              984416        0    984416   0% /dev
tmpfs             203072      936    202136   1% /run
/dev/vda1       34030160 14712892  17570888  46% /
Posted in mysql
6041
1:16 am, July 4, 2023

View Statistics
This Week
1479
This Month
2956
This Year
2081

No Items Found.

Add Comment
Type in a Nick Name here
 
Other Items in mysql
clean excess binary logs from mysql - free up space
Related Search Terms
mysql getting 47
mysql Getting 33
mysql just 44
mysql date 40
mysql have 38
mysql Block 33
mysql file 51
mysql Mysql 43
mysql binary 49
mysql actually 41
mysql should 41
mysql free 52
mysql available 50
mysql System 50
mysql files 48
mysql Files 38
mysql latest 49
mysql mount 41
mysql Mount 43
mysql space 45
mysql Space 43
mysql this 50
mysql block 46
mysql check 47
mysql Latest 45
mysql xml 50
mysql html 48
mysql more 55
mysql test 52
mysql mysql 60
mysql name 45
mysql sql 53
mysql MySQL 48
mysql system 46
mysql the 40
mysql from 47
mysql into 47
mysql Check 33
mysql pre 40
mysql code 46
Other Categories in Code
alpine js apps c css factorio font awesome images linux quick modals sqlite site bugs site updates slick slider sliders testing windows apps apache api apps asp bat bootstrap bootstrap templates charts cookies core css css filters css grid design elements docker domains emoji fancybox fonts foundation framework gimp git html icons ideas image formatting images javascript javascript functions jquery js linux mac misc modals mysql nginx node php php errors php function php functions php simple html dom pi400 python react regex sections simple_html_dom simplepie php site bugs site documentation slick slider sql sqlite ssh sublime svg svg css templates tools virtual box vscode vue webdev windows windows 11 windows commands wordpress
Search Code
Search Code by entering your search text above.
Welcome

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...

Subscribe to weekly updates about things i have added to the site or thought interesting during the last week.

You could also follow me on twitter or not... does anyone even use twitter anymore?

If you found something useful or like my work, you can buy me a coffee here. Mmm Coffee. ☕

❤️👩‍💻🎮

🪦 2000 - 16 Oct 2022 - Boots
Random Quote
“If you just sit and observe, you will see how restless your mind is. If you try to calm it, it only makes it worse, but over time it does calm, and when it does, there’s room to hear more subtle things. You see so much more than you could see before. It’s a discipline; you have to practice it.”
Steve Jobs
Random CSS Property

hyphens

The hyphens CSS property specifies how words should be hyphenated when text wraps across multiple lines. It can prevent hyphenation entirely, hyphenate at manually-specified points within the text, or let the browser automatically insert hyphens where appropriate.
hyphens css reference