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

https://www.youtube.com/watch?v=tKskvRTOkX0

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