A.DESCRIBE manufacturing.parts;

B.SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;

C.SHOW INDEXES FROM manufacturing.parts;

D.SELECT * FROM information_schema.COLUMN_STATISTICS;

E.EXPLAIN SELECT INDEXES FROM manufacturing.parts;

A.Run MySQL Server docker containers.

B.Use systemdwith different settings for each instance.

C.Use system tools to lock each instance to its own CPU.

D.Start mysqldor mysqld_safeusing different option files for each instance.

E.Run mysqldwith --datadirdefined for each instance.

F.Use resource groups to lock different instances on separate CPUs.

A.ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

B.ALTER TABLE t1 ENCRYPTION='Y';

C.ALTER TABLE t1 SET TDE = 'ON';

D.ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;

A.Use system tools to lock each instance to its own CPU.

B.Run MySQL Server docker containers.

C.Use systemd with different settings for each instance.

D.Start mysqld or mysqld_safe using different option files for each instance.

E.Run mysqld with --datadir defined for each instance.

F.Use resource groups to lock different instances on separate CPUs.