UTF8MB4 Emoji Support EXPLODES Table From 500GB to 2TB?!
CHARACTER SET BOMB! Changed to utf8mb4 for emoji support! Table size EXPLODES 4x overnight! 500GB becomes 2.1TB! Disk fills up during ALTER! Database goes READ-ONLY! Watch this explosion!
#sql #sqldisaster #utf8mb4 #emoji #storageexplosion #altertable #sqlfails #diskfull #sqlshorts #databasedisaster #sqlwtf #characterset
Briefly gone fixing #diskfull #mastoadmin happy holidays!!!
Love when I go to check something and it's unresponsive. Then I look and find this:
```
user@host:~$ df -h
Filesystem Size Used Avail Use% Mounted on
tmpfs 795M 1.2M 793M 1% /run
/dev/mapper/ubuntu--vg-ubuntu--lv 30G 29G 0 100% /
tmpfs 3.9G 0 3.9G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
/dev/sda2 2.0G 182M 1.7G 10% /boot
tmpfs 795M 12K 795M 1% /run/user/1000
```
My next 15 minutes are planned out for me. Used to be 20, I had to google the lvm command format.
#linux #lvm #selfhost #diskfull
POV: you solve all the dependency issues, solved the outdated code bugs after hours of trial and error, and then the script starts downloading a 1,5 Gb model into your WSL2 environment, leading to #diskfull #ilovethis
Episode No. 5,528 for March 18th 2014
"disk full" https://www.bonequest.com/5528.html
#afterdark #dir #diskfull #full #installation #macintosh #straydot #unix
