![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
hbhe0316
这个作者很懒,什么都没留下…
展开
-
Mysql OCP 第14题
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>.原创 2022-04-23 14:52:55 · 462 阅读 · 0 评论 -
FLUSH TABLES FOR EXPORT
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原创 2021-12-12 11:13:56 · 1303 阅读 · 0 评论 -
Mysql OCP第13题
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原创 2021-12-12 10:25:22 · 253 阅读 · 0 评论 -
Mysql OCP第12题
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原创 2021-12-12 10:17:09 · 244 阅读 · 0 评论 -
Mysql OCP第11题
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原创 2021-12-12 10:12:50 · 532 阅读 · 0 评论 -
Mysql OCP第10题
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原创 2021-12-12 10:00:48 · 425 阅读 · 0 评论 -
Mysql OCP第9题
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原创 2021-12-12 09:57:22 · 254 阅读 · 0 评论 -
Mysql OCP第8题
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原创 2021-12-12 09:55:00 · 169 阅读 · 0 评论 -
Mysql ocp第7题
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.原创 2021-12-12 09:52:07 · 411 阅读 · 0 评论 -
Mysql OCP第6题
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原创 2021-12-12 09:45:29 · 401 阅读 · 0 评论 -
Mysql OCP 第5题
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原创 2021-12-12 09:42:42 · 271 阅读 · 0 评论 -
mysql ocp第4题
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原创 2021-12-11 23:46:05 · 544 阅读 · 0 评论 -
mysql ocp第3题
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原创 2021-12-11 23:44:33 · 356 阅读 · 0 评论 -
mysql ocp第2题
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原创 2021-12-11 23:42:42 · 299 阅读 · 0 评论 -
Mysql innodb_log_file_size参数
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 来调节原创 2021-12-11 11:36:31 · 2815 阅读 · 0 评论