MySQL Forums
Forum List  »  Security

About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()
Posted by: 无 无
Date: July 07, 2022 04:22AM

In the past two days, I have been testing the performance of Mysql using the AES_DECRYPT() and AES_ENCRYPT() functions. It is very slow when using Mysql for batch insertion. It takes 7 seconds for 100 entries. The log configuration has been modified, and the speed has been improved. When using encrypted fields for conditional retrieval, the query speed is very fast, and the speed is comparable to that without encryption.

Here is my question:

- Why is it so slow when inserting in batches?
- Why is decryption by calling the AES_DECRYPT() function? When a single index of encrypted data is so fast, how is the bottom layer implemented? Is there an index?
- How are the two functions AES_DECRYPT() and AES_ENCRYPT() implemented, and are there any configurable items to configure the encryption index?

Hope to get an answer, thanks a lot

Options: ReplyQuote


Subject
Views
Written By
Posted
About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()
79
July 07, 2022 04:22AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.