WL#7464: InnoDB: provide a way to do non-locking reads

Affects: Server-8.0   —   Status: Complete

New Data Dictionary allows INFORMATION_SCHEMA queries to get their data
directly from DD tables (see WL#6599 for more information). The main point
is that I_S tables will be represented as views, thus a query from I_S
table will be a query from a view.

I_S queries can be executed under different isolation levels that is set by
user. Hence it is possible that I_S queries getting blocked by a parallel
DDL operation. This will be a huge compatibility issue.

The proposed behavior is to request InnoDB to do lockless read operation
from the underlying DD-tables.

In order to do that, there should be a way to request non-locking read on
per handler (in terms of the Handler API) instance. This WL is about
providing such a way.