Mysql OCP 35题

Is it true that binary backups always take less space than text backups?
A. Yes, because binary backups only contain data, and not statements required to insert data into the tables.
B. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.
C. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.
D. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.
Answer: C

https://www.cndba.cn/hbhe0316/article/22774

https://www.cndba.cn/hbhe0316/article/22774

https://www.cndba.cn/hbhe0316/article/22774 https://www.cndba.cn/hbhe0316/article/22774

二进制(物理)备份总比逻辑备份占用的空间小吗？
A． 是的，因为二进制备份仅包含数据，而不是SQL语句
B． 不是，因为逻辑备份是有优化的，这使它变得更小，例如一次性更新多行
C． 不是，因为InnoDB表包含很多空页，它会占用很多空间
D． 是的 ，因为即使InnoDB表包含很多空页，逻辑备份也会同样存在很多空的INSERT语句对应这些空页https://www.cndba.cn/hbhe0316/article/22774https://www.cndba.cn/hbhe0316/article/22774

https://www.cndba.cn/hbhe0316/article/22774

https://www.cndba.cn/hbhe0316/article/22774 https://www.cndba.cn/hbhe0316/article/22774 https://www.cndba.cn/hbhe0316/article/22774

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL