| 1 |
# Wait max 10 min for key encryption threads to encrypt all spaces |
| 2 |
# Success! |
| 3 |
SET GLOBAL innodb_encryption_threads=4; |
| 4 |
SET @encryption_threads_running=4; |
| 5 |
SELECT COUNT(*) INTO @encrypt_threads_running |
| 6 |
FROM performance_schema.threads |
| 7 |
WHERE NAME LIKE '%encrypt%'; |
| 8 |
SELECT @encryption_threads_running; |
| 9 |
@encryption_threads_running |
| 10 |
4 |
| 11 |
# restart: --innodb-read-only=1 --innodb-encrypt-tables=1 |
| 12 |
SET GLOBAL innodb_encryption_threads=4; |
| 13 |
SET @encryption_threads_running=0; |
| 14 |
SELECT COUNT(*) INTO @encryption_threads_running |
| 15 |
FROM performance_schema.threads |
| 16 |
WHERE NAME LIKE '%encrypt%'; |
| 17 |
SELECT @encryption_threads_running; |
| 18 |
@encryption_threads_running |
| 19 |
0 |
| 20 |
# All done |