A general purpose MySQL instance is configured with the following options:
—log-slow-queries
—long-query-time=,0001
—log-slow-admin-queries
—general-log
—log-bin
—binlog-format=STATEMENT
—innodb-flush-log-at-trx-commit=1
Which three statements are true()。
A.The General Query Log records more data than the Binary Log
B.The binary Log records more data than the General Query Log
C.The Slow Query Log records more data than the General Query Log
D.The General Query Log records more data than the Slow Query Log
E.The Slow Query Log records more data than the Binary Log
F.The Binary Log records more data than the Slow Query Log
您可能感兴趣的试卷
你可能感兴趣的试题
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?()
A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file
A.InnoDB uses row and table-level locks, but row locks are not escalates
B.InnoDB locks only those rows that are updated
C.InnoDB only uses row locks, not page or table-level locks
D.InnoDB row locks may be escalated to page or table-level locks
E.InnoDB uses row-level or table-level locks depending on the number of rows affected
A.It is a static variable and can be set only at MySQL server startup
B.It enables and starts the General Query Log
C.It sets the target location for the binary logs generated by the MySQL sever
D.It specifies output destinations for the slow and General Query logs
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0.
Which action should be taken to remove the performance bottleneck described here?()
A.Increase the value of table_definition_cache
B.Increase the value of table_open_cache_instances
C.Decrease the value of table_open_cache_instances
D.Increase the value of table_open_cache
E.Decrease the value of table_definition_cache
F.Decrease the value of table_open_cache
A.More memory per thread is beneficial in all scenarios
B.It causes increased overhead due to initial memory allocation
C.It can affect system stability during peak load times, due to swapping
D.It requires increasing the thread_cache_size variable
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.()
Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;
mysql> TRUNCATE t1;
A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B.Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C.$ mysql – u root – p – h localhost test < /tmp/t1.sql
D.Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
A.Can back up a remote database server
B.Allow a consistent backup to be taken
C.Are always faster to restore than binary backups
D.Are able to back up specific items within a database
E.Create automatically compressed backups
F.Will lock all storage engines for duration of backup
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?()
A.Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORY
B.Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
C.Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
D.Set binlog_format=MIXED with the – replicate-ignore-temp-table option
E.Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
A.Mysqld uses internal configuration versioning and reverts to the previous configuration
B.When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes
C.The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes
D.Mysqld prints to the error log about an unknown variable, and then exits
A.MySQL Replication
B.Distributed Replication Block Device
C.Windows Server Failover Clustering
D.MySQL Cluster
最新试题
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?()
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0.Which action should be taken to remove the performance bottleneck described here?()
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 two statements are true about setting the per-thread buffers higher than required?()
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.Which two variables would likely fix this issue?()
You need to dump the data from the master server and import it into a new slave server.Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?()
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.()Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;mysql> TRUNCATE t1;
Which three methods will show the storage engine for the Country table?()
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?()