I would like to know where will my error logged for mysql server. As of now I just see one log that is in /var/log/mysqld.log. I saw some have .err files too am I missing something here? What would the ib_logfile contain will they contain those errors too? But we cant view them right?
The log buffer writes redo log information to ib_logfile0 and ib_logfile1 for transactional purposes only. There is nothing text readable within those files.
The file /var/log/mysqld.log is the main error-logging mechanism built in mysql. Anything additional would probably be in /var/log/messages.