30、
You have a consistent InnoDB backup
created with mysqldump,the largest table is 50 GB in size.You start to restore
your backup with this command;
shell>mysql -uroot -p < backup.sql
After 30 minutes,you notice that the rate
of restore seems to have slowed down.
No other processes or external factors are
affecting server performance.
Which is the most likely explanation for
this slowdown?
A、The MySQL server has
stopped inserting data to check index consistency;
B、InnoDB
is doing CRC32 checks over the tablespace data as it grows;
C、The MySQL
server is taking a periodical snapshot of data so it can resume the restore if
it is interrupted mid-way;
D、InnoDB
has filled the redo log and now must flush the pages;
E、Secondary
indexes no longer fit into the buffer pool;
Answer:A;
使用mysqldump创建了一个一致的InnoDB备份，最大的表大小为50gb。使用此命令开始恢复备份;
shell>mysql -uroot -p < backup.sql
30分钟后，您注意到恢复的速度似乎放慢了。
没有其他进程或外部因素影响服务器性能。
这种放缓最可能的解释是什么?
A、MySQL服务器已经停止插入数据来检查索引一致性;
