MySQL used all drive space running an ALTER and now won't start
Find the file #sql-8aa_25 and remove it.  It is probably in the same directory where the database is.

If you did a kill -9, mysqld did not get a chance to remove the tmp file.