Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Encrypted table status query causes high load over multiple minutes

Description

The encrypted table status in PT-1530 causes a heavy load - running longer than 2 minutes on a server with many databases. This actually caused big performance problems on some of our productions servers. You might want to fix that.

Environment

None

Attachments

1

Smart Checklist

Activity

Carlos Salguero April 24, 2018 at 5:47 PM

Since the slowdown cannot be avoided because querying information_schema tables is slow on certain conditions, I added a new parameter: --list-encrypted-tables

By default it is set to false

Pieter Bos April 22, 2018 at 5:00 PM

Thanks for taking a look! It's possible this is only a problem for older percona versions - the affected servers are running a 5.6 version of percona server. I can check the exact version later if that helps. 

The query plan, in JSON form:

{"query_block":{"select_id":1,"table":{"table_name":"TABLES","access_type":"ALL","open_frm_only":true,"scanned_databases":"all","attached_condition":"(`information_schema`.`tables`.`CREATE_OPTIONS` like '%ENCRYPTION=\"Y\"%')"}}}

I also uploaded a screenshot of the performance statistics tool running on that server. 

Michael Coburn April 22, 2018 at 4:25 PM

Thanks for the report , we'll take a look and update the ticket with our findings!

Done

Details

Assignee

Reporter

Priority

Fix versions

Time tracking

1d logged

Smart Checklist

Created April 21, 2018 at 3:46 PM
Updated March 4, 2024 at 4:33 PM
Resolved May 4, 2018 at 1:18 PM