hbhe0316的专栏

You created a backup of the world database with this command:shell> mysqldump --opt world > dump.sqlWhich two will import the data from dump.sql?A. shell> mysqladmin recover test dump.sqlB. shell> mysql test < dump.sqlC. shell>.

1.源端mysql版本[root@mysql57 ~]# mysql -Vmysql Ver 14.14 Distrib 5.7.36, for linux-glibc2.12 (x86_64) using EditLine wrapper[root@mysql57 ~]# mysql -vWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server versio

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance?A. a backup cre

You have installed MySQL Server for the first time on your system. However, the datadirectory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?A. Run the create_system_t

Host slave1 has ip address 192.0.2.10.Host slave2 has ip address 203.0.113.50Examine these commands:Why did this error occur?A. The host on the command line is not defined in the login path.B. The mysqld instance has not been restarted after cr

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

Which two statements are true about InnoDB auto-increment locking?A. InnoDB never uses table_level locks.B. InnoDB always protects auto-increment updates with a table-level lockC. InnoDB does not use locks to enforce auto-increment uniqueness.D. The auto-i

Which two options describe how MySQL Server allocates memory?A. Each connection may have its own per-thread memory allocations.B. Thread memory is pre-allocated up to thread_cache_size for performance.C. Each thread allocates memory from a global poo

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host.Assume that the defau.

Which three allocate memory per thread in MySQL?A. query cacheB. thread cacheC. read bufferD. internal temporary tableE. sort bufferF. InnoDB buffer pool instanceAnswer: C,D,E全局缓存：key_buffer_size： 决定索引处理的速度， 尤其是索引读的速度。 默认值是 16M， 通过检查状态值 Key_read_reque

How does the InnoDB storage engine handle deadlocks when they are detected?A. Both the affected transactions will be rolled back.B. The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.C. One of the affected transaction

Which three statements correctly describe MySQL InnoDB Cluster?A. The cluster can be operated in multimaster mode with conflict detection for DML statements.B. All MySQL client programs and connectors can be used for executing queries.C. It provides fully

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.mysql> SHOW SLAVE STATUS\ G...Slave_IO_Running: YesSlave_SQL_Running: NoWhat are two reasons that you may stop the SQL thread on the slave while keeping

Consider the key buffer in a MySQL server. Which two statements are true about this feature?#考虑MySQL服务器中的 key buffer。关于这个特性，哪两种说法是正确的？A. It caches index blocks for MyISAM tables only.B. It caches index blocks for all storage engine tables.C. It is

 MySQL的InnoDB 存储引擎使用一个指定大小的Redo log空间（一个环形的数据结构），Redo log的空间通过innodb_log_file_size和innodb_log_files_in_group（默认为2）参数来调节。将这俩参数相乘即可得到总的可用Redo log 空间。尽管技术上并不关心你是通过innodb_log_file_size还是innodb_log_files_in_group来调整Redo log空间，不过多数情况下还是通过innodb_log_file_size 来调节