Getting the dreaded "DISK FULL: Can't start MySQL!"

[Starburst]

@overseer
I remember this being a problem in the past, and I can't remember what the simple fix was.
All log files have already been deleted, and that didn't make a difference.

Multiple AlmaLinux 9 servers with the same config for mirrors, but this one has run out of disk space.
Which is weird.

--

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


DISK FULL: Can't start MySQL!


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

[overseer]

I assume you've already gone on a hunt for +500MB files?

Look for a singular very large myisam table (all files) .frm, .MYI, .MYD -- offload or download & delete to free up disk space.

[Starburst]

Yea, I think the space is getting eating up by rsync.
But I can't find where.

On this mirror server we where running rsync for MariaDB, besides the regular http & https.

Any trick to find only large files?

Code Select Expand

du -hs /*
Wasn't much of a help, and couldn't find any rsync.log with find.

What I have wound up doing was deleting the whole MariaDB directory, and am pulling from the master now to rebuild with rsync disabled.

[BeZazz]

Code Select Expand

find / -type f -size +500M
can add in

Code Select Expand

-name "*.ext"

[overseer]

I usually use:

Code Select Expand

sudo find / -xdev -type f -size +500M
or

Code Select Expand

du -ahx . | sort -rh | head -5

[Starburst]

Will try that if it happens again.

To get the mirror back operational, so it can be attacked by script kiddies in India I just deleted and re-imaged the MariaDB repo.

Bringing up a server just for the MariaDB repo mirror in India with AL9 now.
And will see how it does with rsync enabled.

[overseer]

Super honeypot! Good idea.

[Starburst]

Super honeypot! Good idea.

So far out of all the mirrors, the new ones in India are getting hit the hardest.