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

@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:

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.

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]

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.

Code: [Select]

find / -type f -size +500Mcan add in

Code: [Select]

-name "*.ext"

I usually use:

Code: [Select]

sudo find / -xdev -type f -size +500Mor

Code: [Select]

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

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.

Super honeypot! Good idea.

Super honeypot! Good idea.

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