WL#8396: Deprecate and remove temp-pool

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

When investigating changing the default setting for temp-pool, it seems clear
that this setting was introduced to compensate for a Linux discrepancy.

Documentation for --temp-pool:

It was introduced in MySQL 3.23 with the following comment:

"Added --temp-pool option to mysqld. Using this option causes most
temporary files created to use a small set of names, rather than a
unique name for each new file. This is to work around a problem in
the Linux kernel dealing with creating a bunch of new files with
different names. With the old behavior, Linux seems to "leak" memory,
as it's being allocated to the directory entry cache instead of the
disk cache."

In MySQL 4.0.3 (Aug 2002) it was set as default for Linux.

In all supported Linuxes, the issue at hand is fixed, so there is no need for
this setting.

temp-pool is deprecated in 5.7 and removed in 8.0

User Documentation

NF-1: No change in performance. Only relevant on Linux.