While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?（）A.Activating the MySQL Enterprise thread pool plu

题目

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?（）

A.Activating the MySQL Enterprise thread pool plugin

B.Relocating your data and log files to separate storage devices

C.Disconnecting idle localhost client sessions

D.Implementing storage engine data compression options

相似考题

1.MySQL数据库产品包括()A、MySQL企业服务器B、MySQL社区服务器C、MySQL嵌入数据库D、MySQL集群

2.The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’;When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@%’);ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?（）A.The password is eight characters long, but needs to exceed validate_password_length to be validB.All of the MEDIUM password policy requirements have not been honoredC.The password matches a substring Hover as a dictionary wordD.The password does not match the validate_passoword_number_count requirementE.There is no dictionary file defined, so password validation cannot work as expected

3.When backing up a replication slave, which three should also be backed up in addition to data?()A.The master.info and relay.info filesB.The relay log filesC.The relay index fileD.Mysql.slave_master_info tableE.Mysql.slave_relay_log_info tableF.Mysql.slave_worker_info table

4.修改MySQL用户root的密码的指令是?()A.mysqladmin-urootpasswordtestB.mysql-urootpasswordtestC.mysql-uroot-ptestD.mysql-uroot-passwordtest

更多“While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number ”相关问题

  • 第1题：

    Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( );Mysql＞ LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql＞ SHOW TABLES;How many events are added to the audit log as a result of the preceding statements?（）

    A.12; only top-level statements and stored procedure events are logged

    B.111; top-level statements and all lower-level statements are logged

    C.3; only the top-level statements are logged

    D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event


    参考答案：C

  • 第2题：

    php连接上mysql之后,采用哪个函数配置循环可以得到指定表中的记录?()

    A.mysql_fetch_row

    B.mysql_select_db

    C.mysql_query

    D.mysql_connect


    参考答案：A

  • 第3题：

    以下不能在Mysql中实现循环操作的语句是 （）。

    A．CASE

    B．LOOP

    C．REPEAT

    D．WHILE


    A

  • 第4题：

    PHP使用以下哪个函数连接MySQL数据库服务器()

    A.mysql_query

    B.mysql_select_db

    C.mysql_connect

    D.mysql_fetch_array


    参考答案：C

  • 第5题：

    php哪个函数用于向mysql数据库发送指令?()

    A.mysql_select_db

    B.mysql_connect

    C.mysql_query

    D.mysql_fetch_field


    参考答案：C

  • 第6题：

    连接mysql数据库服务器的函数是什么？

    A．mysqli_connect()

    B．mysqli_query()

    C．mysqli_error()

    D．mysqli_select_db()


    mysqli_connect()

相关内容