I'm trying to remove some data to get some extra free space, but running the "DELETE FROM table ..." query gives me this error:
Error Code: 3019 Undo Log error: No more space left over in system tablespace for allocating UNDO log pages. Please add new data file to the tablespace or check if filesystem is full or enable auto-extension for the tablespace
I found this:
https://stackoverflow.com/questions/42628687/undo-log-error-no-more-space-left-over-in-system-tablespace-for-allocating-undo
The recommend to run this query:
ALTER UNDO TABLESPACE tablespace_name SET INACTIVE;
But it gives me an Error Code: 1064 MySQL version: 5.7.31
DELETE
: mysql.rjweb.org/doc.php/deletebig . In the short run, please provide more details: disk size, log size,SHOW VARIABLES LIKE 'innodb%';