This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
What is the effect of setting innodb_thread_concurrency to zero?
No users can connect.
An infinite number of users can connect.
Thread concurrency doesn't define how many users can connect.
What is an explicit transaction?
An explicit transaction includes the START TRANSACTION and COMMIT keywords.
All transactions are explicit unless you add keywords.
An explicit transaction is one with more than one statement that rollback at the same time.
When might you consider using a thread pool?
Your workload often has between 400 and 600 simultaneous connections, with occasional bursts of high activity.
Your workload requires low CPU utilization.
Your workload has long periods of inactivity followed by high activity.
What type of statement does metadata locking prevent when a transaction is in progress?
DML statement.
Both DDL and DML statements.
DDL statement.
You must answer all questions before checking your work.
Was this page helpful?
Need help with this topic?
Want to try using Ask Learn to clarify or guide you through this topic?