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 –u root –p < backup.sqlAfter 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?
Which two options describe how MySQL Server allocates memory? (Choose two.)
Which three are key advantages of standard MySQL replication? (Choose three.)
You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.Which statement describes the activation of that access for the user?
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)
You have just executed a manual backup by using this command: mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backupThe operation completed without error.What is the state of this backup and operation required before it is ready to be restored?
