Here is how we can see if we have MySQL locks due to indexing:
SELECT IS_USED_LOCK('db_name_here.reindex_full');
SELECT RELEASE_LOCK('db_name_here.reindex_full');
This is how to create a gpg key without any user interaction or password. This can be used in cases where the primary goal is to secure the data in transit but the gpg key can/must be stored locally without a password. An example of this is the hiera-gpg plugin which doesn't support passwords.
The below genkey-batch file will use the default which currently are RSA/RSA and 2048 bit length. See the reference link to set this to something else.