LP #1620348: empty ibuf aio reads in innodb status

Description

**Reported in Launchpad by flex last update 07-09-2016 12:06:55

Percona Server Version: 5.7.14-7.1.el7
OS: CentOS 7.2

Problem:

`SHOW ENGINE INNODB STATUS` gave an empty ibuf aio reads:

-------- FILE I/O
-------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (read thread)
I/O thread 9 state: waiting for completed aio requests (read thread)
I/O thread 10 state: waiting for completed aio requests (write thread)
I/O thread 11 state: waiting for completed aio requests (write thread)
I/O thread 12 state: waiting for completed aio requests (write thread)
I/O thread 13 state: waiting for completed aio requests (write thread)
I/O thread 14 state: waiting for completed aio requests (write thread)
I/O thread 15 state: waiting for completed aio requests (write thread)
I/O thread 16 state: waiting for completed aio requests (write thread)
I/O thread 17 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
1296 OS file reads, 4121277 OS file writes, 163479 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s

Please have a look at the 4th line from the bottom line, should it be zero?

Environment

None

Smart Checklist

Activity

Show:

Julia Vural March 4, 2025 at 9:03 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

lpjirasync January 24, 2018 at 10:20 AM

**Comment from Launchpad by: Laurynas Biveinis on: 07-09-2016 12:06:55

Thank you. Please post the bug link here once you have it reported

lpjirasync January 24, 2018 at 10:20 AM

**Comment from Launchpad by: flex on: 07-09-2016 11:58:57

Ok, Since this empty output caused our monitor script throw errors, I will report to Oracle, thanks.

lpjirasync January 24, 2018 at 10:20 AM

**Comment from Launchpad by: Laurynas Biveinis on: 07-09-2016 11:44:42

Indeed empty output here indicates that there are no used AIO segments at the time of printout.

This is something we inherited from Oracle MySQL - do you want to report it to them?

Won't Do

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created January 24, 2018 at 10:20 AM
Updated March 4, 2025 at 9:03 PM
Resolved March 4, 2025 at 9:03 PM