Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
B. MySQL Server Status > SHOW ENGINE INNODB STATUS
The InnoDB storage engine exposes a lot of information about
its internals in the output of SHOW ENGINE INNODB
STATUS, or its older synonym, SHOW
INNODB STATUS.
Unlike most of the SHOW commands,
its output consists of a single string, not rows and columns. It is
divided into sections, each of which shows information about a different
part of the InnoDB storage engine. Some of the output is most useful for
InnoDB developers, but much of it is
interesting—or even essential—if you’re trying to understand and configure
InnoDB for high performance.
Note
Older versions of InnoDB often print out 64-bit numbers in two
pieces: the high 32 bits and the low 32 bits. An example is a
transaction ID, such as TRANSACTION 0
3793469. You can calculate the 64-bit number’s value by
shifting the first number left 32 bits and adding it to the second one.
We show some examples later.