单项选择题

A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND.
The database is refreshed periodically, but the resultset size of the queries does not fluctuate.
Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high.
All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase.
The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service.
Based solely on the information provided, what is the most likely cause for this slowdown at the database level?()

A.The Query Cache is pruning queries due to an increased number of requests
B.Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
C.Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
D.The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题

Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql
Which two commands will restore the sakila database without interfering with other running database?()

A.Mysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';
B.Shell> mysql –u root –p sakila sakila2013.sql
C.Shell> mysql import –u root –p sakila sakila2013.sql
D.Shell> mysql  –u root -p  –e 'use sakila; source sakila2013.sql'
E.Shell> mysql  –u root  –p  –silent < sakila2013.sql

3.单项选择题

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?()

A.A syntax error will result as you cannot specify more than one partition in the same statement
B.All data in p1 and p3 partitions are removed and the table definition is changed
C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged
D.Only the first partition (p1) will be dropped as only one can be dropped at any time

最新试题

Which two are true regarding MySQL binary and text backups?()

题型:多项选择题

Which three statements are true about memory buffer allocation by a MySQL Server?()

题型:多项选择题

You use—login-path to access a MySQL server on a Linux installation.Which statement is true about the – login-path option that is created by using mysql_config_editor?()

题型:单项选择题

Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?()

题型:单项选择题

Which two capabilities are granted with the SUPER privilege?()

题型:多项选择题

Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start.Which two statements would explain why the service did not start?()

题型:多项选择题

Which statement is true about the log-output variable?()

题型:单项选择题

A user executes the statement;PURGE BINARY LOGS TO 'mysql-bin.010';What is the result?()

题型:单项选择题

You have table 'apps','userdata' on server that uses MyISAM storage engine.You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands:Shell> mysqldump –u root –h server –no-data apps userdata mysql –u root –p appsShell> mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;'Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata mysql –u root –p appsWhat effect does the – order-by-primary argument have on the mysqldump command?()

题型:单项选择题

An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?()

题型:单项选择题