A.The thread cache has been configured with thread_cache_sizeset to at least 6.

B.There are 140 Performance Schema threads at the time of the output.

C.All max_connectionswere in use at 2018-03-22 14:54:06

D.There are more connections being idle than executing queries.

E.There are 510 connections to MySQL at the time of the output.

A.whether you are using any indexes in your query

B.whether there are any indexes on the tables that you are querying

C.if it is possible for you to include any indexes in your query

D.if there are any indexes that may be used to solve this query

A.Query the INFORMATION_SCHEMA.PARTITIONS table

B.Use the command: SHOW TABLE STATUS

C.Query the performance_schema.objects_summary_global_by_type table

D.Query the INFORMATION_SCHEMA.TABLES table for the partition_count

E.Use the command: SHOW CREATE TABLE

A.mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
'employee'@'localhost';
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

B.mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';

C.mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;

D.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';

A.Change the table to use HASH indexes instead of BTREE indexes.

B.Increase the value of the innodb_lock_wait_timeoutoption.

C.Increase the value of the innodb_read_io_threadsoption.

D.Set the value of innodb_adaptive_hash_indexto zero.

E.Increase the size of the InnoDB buffer pool.

F.Deactivate the query cache.