# Getting the Length of TDE Key in Audit database

**URL:** <https://forums.percona.com/t/getting-the-length-of-tde-key-in-audit-database/26804>\
**Category:** MySQL & MariaDB\
**Created:** [November 27, 2023, 3:02pm UTC](https://forums.percona.com/t/getting-the-length-of-tde-key-in-audit-database/26804 "2023-11-27T15:02:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andre1976](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@Andre1976](https://forums.percona.com/u/Andre1976)\
**Post date:** [November 27, 2023, 3:02pm UTC](https://forums.percona.com/t/getting-the-length-of-tde-key-in-audit-database/26804/1 "2023-11-27T15:02:43Z")

</div>

Hello

I need to get the length of TDE Key stored in FS,. I have been using the plugin keyring\_udf , however , It returns NULL

Whats is the best approach ?

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/d67024f16196745f03991b6f2f9f988e49e52f87.png)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/65814aff7381a56a8ebbfbf695a2d4a8299e2389.png)

---

<div class="post-metadata">

**Author:** ![yunus.uyanik](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus.uyanik/32/19250_2.png) [@yunus.uyanik](https://forums.percona.com/u/yunus.uyanik)\
**Post date:** [December 4, 2023, 9:04am UTC](https://forums.percona.com/t/getting-the-length-of-tde-key-in-audit-database/26804/2 "2023-12-04T09:04:27Z")

</div>

Hi @Andre1976 ,  
On my side, I’m able to see the length.  
Do other functions result in NULL, too?

`SELECT keyring_key_type_fetch('MyKey');`

Have you tried to create another one for a test?

And what is your current configuration and status?

`SELECT * FROM performance_schema.keyring_component_status;`

---

<div class="post-metadata">

**Author:** ![Andre1976](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@Andre1976](https://forums.percona.com/u/Andre1976)\
**Post date:** [December 4, 2023, 9:44am UTC](https://forums.percona.com/t/getting-the-length-of-tde-key-in-audit-database/26804/3 "2023-12-04T09:44:17Z")

</div>

Hello @Yuanlin_Wu

Yes , If I create by function keyring\_udf a new key ( keyring\_key\_generate ) I can get this way SELECT keyring\_key\_type\_fetch(‘MyKey’), however my old key in FS I can’t get the lenght yet

Andre Rodrigues