mysql

clean excess binary logs from mysql - free up space

Posted in mysql
4620
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
4620
1:16 am, July 4, 2023

View Statistics
This Week
34
This Month
139
This Year
660

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 28
mysql Getting 19
mysql just 25
mysql date 21
mysql have 22
mysql Block 17
mysql file 30
mysql Mysql 25
mysql binary 28
mysql actually 24
mysql should 24
mysql free 25
mysql available 31
mysql System 30
mysql files 27
mysql Files 27
mysql latest 32
mysql mount 29
mysql Mount 24
mysql space 28
mysql Space 25
mysql this 29
mysql block 24
mysql check 26
mysql Latest 25
mysql xml 24
mysql html 28
mysql more 26
mysql test 28
mysql mysql 29
mysql name 29
mysql sql 30
mysql MySQL 27
mysql system 28
mysql the 27
mysql from 22
mysql into 28
mysql Check 21
mysql pre 24
mysql code 29
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
In this case my anchor this week becomes driving almost 2hrs outside of Atlanta to one of my favorite hard core gyms in the world.. MetroFlex aka The Dungeon. The gym owners turn the heat way up so it becomes a fun sweat box and the gym members just watch from afar and leave me alone. I happily drive myself long distances to find MY ANCHOR. Our anchor allows us to have balance, focus and be as productive as possible. And if you're in the middle of a heavy set and your headphones start to fall off your head, like mine did here.. well.. f*ck the headphones. Let em break and fall. You can always get a new pair, but the iron ain't ever gonna lift itself.
Unknown
Random CSS Property

grid-row-start

The grid-row-start CSS property specifies a grid item's start position within the grid row by contributing a line, a span, or nothing (automatic) to its grid placement, thereby specifying the inline-start edge of its grid area.
grid-row-start css reference