[MDEV-11984] Avoid accessing SYS_TABLESPACES unnecessarily Created: 2017-02-03  Updated: 2018-03-22  Resolved: 2018-03-22

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.1, 10.2, 10.3
Fix Version/s: 10.2.14, 10.3.6

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: performance

Sprint: 10.3.6-1

 Description   

The view information_schema.innodb_tablespaces_encryption is unnecessarily retrieving the data from the SYS_TABLESPACES table instead of directly fetching it from the fil_system cache. InnoDB always loads all tablespace metadata into memory at startup and never evicts it while the tablespace exists.
Similar unnecessary access could exist elsewhere in InnoDB. We should replace all those. Only the view INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES is intentionally retrieving the data directly from the table.



 Comments   
Comment by Marko Mäkelä [ 2018-03-22 ]

bb-10.2-marko

Comment by Thirunarayanan Balathandayuthapani [ 2018-03-22 ]

Patch approved. OK to push

Generated at Thu Feb 08 07:54:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.