Where are the MySQL InnoDB log files stored?
I changed some settings for my InnoDB tables in MySQL and encountered the problem that InnoDB was not shown in SHOW ENGINES
output. As an answer I got the suggestion to delete the log files of InnoDB. Where are these stored on Ubuntu?
Solution 1:
ls /var/lib/mysql/
did the job. Every file ib_logfile0
, iblogfile1
is a InnoDB logfile, if I am not mistaken, that is. :-)