WL#8356: Improve scalability by not acquiring unnecessary locks for internal temp tables

Affects: Server-5.7   —   Status: Complete

After WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB
tables" has been implemented LOCK_plugin and THR_LOCK_lock became more prominent
as scalability bottlenecks in workloads which involve creation of internal
in-memory temporary tables (like Sysbench's SELECT_DISTINCT test for InnoDB).

The goal of this WL is to remove these bottlenecks. There is no real reason why
we should acquire these locks for internal temporary tables.