A
A
Alexey Buchakow2017-08-04 14:00:05
MySQL
Alexey Buchakow, 2017-08-04 14:00:05

How to rescue MySQL (MariaDB) when partition overflows?

Good afternoon!
There is a web server, and within its framework MySQL (MariaDB).
Given:

  • Under the database was given a separate section of 10GB
  • This was done after the shared partition was clogged with backups (so that the database would not stop)
  • The site's caching system scored this section at 0 (8Kb left and the database got up)

What to do?
  • Can't delete tables with cache. Truncate doesn't work. Delete all doesn't work. Everything hangs in anticipation and that's it.
  • After restarting the machine, the mysql server doesn't even start.

One more question.
Is it possible to physically delete files with this table? Will the integrity of the database be preserved? The cache (the same 8GB) is two tables in total.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
W
Wexter, 2017-08-04
@aseven

mount the partition to another location, mount a larger partition to the db folder, copy the data while maintaining rights to the new partition, run

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question