add info about encrypted tablespaces in pt-mysql-summary
General
Escalation
General
Escalation
Description
Let's start from what we currently have in encryption section for pt-mysql-summary.
Which looks decent, but it doesn't include info if encrypted table is in a encrypted single tablespace or part of some encrypted general tablespace which includes many tables.
In my case t1 is part of "foo" tablespace and t2 is in a single table tablespace.
I also have encrypted general tablespace "bar" but it doesn't include any tables so it's not visible here.
I think it would be helpful to: 1. add info in encrypted tables part about tablespace to which the table is belonging (and is it a single or general tablespace) 2. add another table to list encrypted tablespaces (maybe here list just general tablespaces and not single table since it might duplicate a lot with encrypted tables list)
Since implements a flag to show encryption related info only if specified to avoid slowdowns caused by querying I_S tables, this ticket has to be implemented after and should depend on that flag to be set
Carlos Salguero May 10, 2018 at 7:45 PM
Just a comment and it might be just a different interpretation.
8192 is bit 14 (13 starting count from 0): 0b10000000000000 = 0d8192
Let's start from what we currently have in encryption section for pt-mysql-summary.
Which looks decent, but it doesn't include info if encrypted table is in a encrypted single tablespace or part of some encrypted general tablespace which includes many tables.
In my case t1 is part of "foo" tablespace and t2 is in a single table tablespace.
I also have encrypted general tablespace "bar" but it doesn't include any tables so it's not visible here.
I think it would be helpful to:
1. add info in encrypted tables part about tablespace to which the table is belonging (and is it a single or general tablespace)
2. add another table to list encrypted tablespaces (maybe here list just general tablespaces and not single table since it might duplicate a lot with encrypted tables list)
For 2. it seems it's not straightforward but it can be listed, see here how: https://jira.percona.com/browse/PS-3962
short example: