You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.Some details are as follows:The Mysql instance has 400 databases. Each database on an average consi

题目

You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.Some details are as follows:The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query:SELECT TABLE_SCHEMA, ‘ENGINE‘, COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= ‘BASE TABLE‘ GROUP BY TABLE_SCHEMA, ‘ENGINE‘ ;Why is this query slow to execute?（）

A.Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables

B.Aggregating details from various storage engine caches for the final output is time consuming

C.Collecting information requires various disk-level operations and is time consuming

D.Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming

相似考题

1.● Project (74) Management is the Knowledge Area that employs the processes required to ensure timely and appropriate generation, collection, distribution, storage, retrieval, and ultimate disposition of project information.A.IntegrationB.TimeC.PlanningD.Communication

2.Slow ahead_______ engines!A.withB.bothC.andD.to

3.Project(29)Management is the Knowledge Area that employs the processes required to ensure timely and appropriate generation, collection, distribution, storage, retrieval, and ultimate disposition of project information.A．IntegrationB．TimeC．PlanningD．Communication

4.Project（）Management is the Knowledge Area that employs the processes required to ensure timely and appropriate generation, collection, distribution, storage, retrieval，and ultimate disposition of project information．（） A．Integration B．Time C．Planning D．Communication

更多“You want to start monitoring statistics on the distribution of storage engines that are be ”相关问题

  • 第1题：

    Deploying the cisco unified computing system platform into the data center provides which two benefits?()

    A.it leverages low-speed interfaces

    B.only one configuration is used for all blades

    C.storage, computing and networking services are combined onto one blade

    D.it is A pra-as-you-go incremental deployment

    E.server replacement is as easy as replacing the physical blade


    参考答案：D, E

  • 第2题：

    Project(74)Management is the Knowledge Area that employs the processes required to ensure timely and appropriate generation, collection, distribution, storage, retrieval, and ultimate disposition of project information.

    A．Integration

    B．Time

    C．Planning

    D．Communication


    正确答案：D
    解析：项目沟通管理是使用所需过程以确保及时、恰当地产生、收集、分发、存储、收回和最终处置项目信息的知识域。

  • 第3题：

    下面哪一个语句创建了值为storage的宏变量location？ （）

    A．&let location = storage;

    B．let &location = storage;

    C．%let location = "storage";

    D．%let location = storage;


    B

  • 第4题：

    What is the meaning of the word “gadgets” (Paragraph 4)?

    [A] devices [B] tools [C] appliances [D] engines


    正确答案：A

  • 第5题：

    Advise you________engines.

    A.stop

    B.to stop

    C.stopping

    D.stopped


    正确答案：A

  • 第6题：

    毒物动力学常被写成ADME过程，是四个词的字头，包括（）。

    A．分布(distribution)

    B．代谢(metabolism)

    C．吸收(absorption)

    D．排泄(excretion)

    E．贮存(Storage)

    F．转运（Biological Transport）


    ABCD

相关内容