| 失效链接处理 |
|
Mysql ocp5.6答案最新修正版 PDF 下载
本站整理下载：
相关截图：
主要内容：
1. Consider a total and sustained failure of the disk on which the MySQL data directory
resides.
Which three High Availability scenarios are resilient to this case?
A. active/passive Distributed Replicated Block Device (DRBD).
B. standard master-slave replication
C. MYSQL service for Windows Cluster
D. MySQL NDB Cluster
E. Oracle Solaris Cluster
解释:
经常硬盘故障，那就要选择基于复制的高可用架构，保证数据有冗余不丢失，才是合适的高可用。
A.是磁盘复制；B.标准主从复制；D.NDB底层的每个node可以存一部分数据，或者完整的数据(根据
配置)
C、E均是基于共享存储的高可用。
2. 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. Counting and summarizing all table pages in the InnoDB shared tablespace is time
consuming.
B. Collecting information requires various disk-level operations and is time consuming.
C. Aggregating details from various storage engine caches for the final output is time
consuming.
D. Collecting information requires large numbers of locks on various
INFORMATION_SCHEMA tables, thereby causing contention.
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
