Score:0

How to start myslq if it fails to start due to insufficient space, and the main files eating up space are mysql binary log files

pe flag

My server disk usage looks like this:

Filesystem      Size  Used Avail Use% Mounted on
udev            989M     0  989M   0% /dev
tmpfs           200M   21M  180M  11% /run
/dev/xda1        59G   57G  9.7M 100% /
tmpfs           998M     0  998M   0% /dev/mhs
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs           998M     0  997M   0% /sys/fs/cgroup
/dev/xda14      124M  278K  124M   1% /boot/efi
tmpfs           200M     0  200M   0% /run/user/2000

And when I search for large files, there's basically 52 binary log files that are ~1.1GB.

I can't start mysql due to insufficient space, so I can't purge binary log files properly (apparently your not allowed to delete them manually).

Server runs on bitnami/wordpress/amazon lightsail.

So, what do I do? Please help.

Score:0
ua flag

How old is the oldest of the 52?

Delete the oldest binlogs until you can get going again.

Add to config

expire_logs_days = 7

if you would like the binlogs to be kept for only one week.

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.