MySQL Forums
Forum List  »  Security

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

无 无 Wrote:
> 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

Another question is, when querying in batches, whether the underlying Mysql decrypts all data at one time before matching, or decrypts them one by one, and whether the underlying Mysql decrypts decrypts once or multiple times

Options: ReplyQuote

Written By
Re: About the underlying principles of AES_DECRYPT() and AES_ENCRYPT()
July 07, 2022 04:29AM

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.