mirror of
https://github.com/MariaDB/server.git
synced 2025-10-07 08:19:13 +02:00
20 lines
646 B
Text
20 lines
646 B
Text
# Wait max 10 min for key encryption threads to encrypt all spaces
|
|
# Success!
|
|
SET GLOBAL innodb_encryption_threads=4;
|
|
SET @encryption_threads_running=4;
|
|
SELECT COUNT(*) INTO @encrypt_threads_running
|
|
FROM performance_schema.threads
|
|
WHERE NAME LIKE '%encrypt%';
|
|
SELECT @encryption_threads_running;
|
|
@encryption_threads_running
|
|
4
|
|
# restart: --innodb-read-only=1 --innodb-encrypt-tables=1
|
|
SET GLOBAL innodb_encryption_threads=4;
|
|
SET @encryption_threads_running=0;
|
|
SELECT COUNT(*) INTO @encryption_threads_running
|
|
FROM performance_schema.threads
|
|
WHERE NAME LIKE '%encrypt%';
|
|
SELECT @encryption_threads_running;
|
|
@encryption_threads_running
|
|
0
|
|
# All done
|