How to read innodb log file?

Question

I would like to see "general query log" from innodb log file, so is there anybody know how to see / read those query logs?

I tried MySQL admin utility, it shows only error log and query log is disabled.

Answer 1

The answer is that you can not.

The ib_logfile* files do not contain queries, but rather 512-byte aligned instructions on how to re-apply changes made by queries. For example:

[Space-id] [Page-id] [Where-in-the-page-to-modify] [Payload]

• Space-id is the file number (e.g. ibdata1 = file number zero).
• Page-id is which page within that file. All pages are 16K.