jinzhenshui - 博客园

2020年3月16日

Mysql：DoubleWrite Buffer：类似于redo-log：提高data写性能，间接提高data写安全性！

摘要： 15.6.4 Doublewrite Buffer The doublewrite buffer is a storage area in the system tablespace where InnoDB writes pages that are flushed from the buffer 阅读全文

posted @ 2020-03-16 12:38 jinzhenshui 阅读(284) 评论(0) 推荐(0)

Mysql：UNDO Tablespaces && UNDO Logs

摘要： 15.6.3.4 Undo Tablespaces Undo tablespaces contain undo logs, which are collections of undo log records that contain information about how to undo the 阅读全文

posted @ 2020-03-16 12:33 jinzhenshui 阅读(1266) 评论(0) 推荐(0)

Mysql：Temporary Tablespaces

摘要：重点： Session Temporary Tablespaces：用户session临时表空间的管理 15.6.3.5 Temporary Tablespaces InnoDB uses session temporary tablespaces and a global temporary ta 阅读全文

posted @ 2020-03-16 11:21 jinzhenshui 阅读(436) 评论(0) 推荐(0)

Mysql：innodb engines：Moveing Tablespace Files when mysqld server is Offline!

摘要： 15.6.3.6 Moving Tablespace Files While the Server is Offline The innodb_directories option, which defines directories to scan at startup for tablespac 阅读全文

posted @ 2020-03-16 11:16 jinzhenshui 阅读(621) 评论(0) 推荐(0)

Mysql：账号与权限

摘要： 6.2 Access Control and Account Management 6.2.1 Account User Names and Passwords 6.2.2 Privileges Provided by MySQL 6.2.3 Grant Tables 6.2.4 Specifyin 阅读全文

posted @ 2020-03-16 10:26 jinzhenshui 阅读(1658) 评论(0) 推荐(0)