2020 年 3月 16 日随笔档案 - jinzhenshui

2020年3月16日

Mysql：The Merge Storage Engine：类【union all】联合视图存储引擎

摘要： 16.7 The MERGE Storage Engine 16.7.1 MERGE Table Advantages and Disadvantages 16.7.2 MERGE Table Problems The MERGE storage engine, also known as the 阅读全文

posted @ 2020-03-16 19:45 jinzhenshui 阅读(261) 评论(0) 推荐(0)

Mysql：The Federated Storage Engine：联合（联盟）存储引擎：【远程连接】服务器引擎

摘要：重点：目前该引擎仅仅支持Mysqld服务器；如果能支持其他rdbms系统就完美了！ 16.8 The FEDERATED Storage Engine 16.8.1 FEDERATED Storage Engine Overview 16.8.2 How to Create FEDERATED Ta 阅读全文

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

Mysql：16.11.1 Pluggable Storage Engine Architecture

摘要： 16.9 The EXAMPLE Storage Engine The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL sour 阅读全文

posted @ 2020-03-16 18:35 jinzhenshui 阅读(293) 评论(0) 推荐(0)

Mysql：Server Logs：mysqld服务器的各种日志

摘要：比较新的知识点：DDL log，以前没注意到 5.4 MySQL Server Logs 5.4.1 Selecting General Query Log and Slow Query Log Output Destinations 5.4.2 The Error Log 5.4.3 The Ge 阅读全文

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

Mysql：InnoDB Table Compression and InnoDB Page Compression：适用于InnoDB的：表压缩 & 页压缩

摘要： 15.9 InnoDB Table and Page Compression 15.9.1 InnoDB Table Compression 15.9.2 InnoDB Page Compression This section provides information about the Inno 阅读全文

posted @ 2020-03-16 15:44 jinzhenshui 阅读(1171) 评论(0) 推荐(0)

Mysql：Redo Log

摘要： 15.6.5 Redo Log The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During norm 阅读全文

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

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 阅读(282) 评论(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 阅读(1251) 评论(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 阅读(434) 评论(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 阅读(619) 评论(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 阅读(1645) 评论(0) 推荐(0)

Mysql：Information_schema：信息构架 or 数据字典 or 系统目录

摘要： Chapter 25 INFORMATION_SCHEMA Tables 25.1 Introduction INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server suc 阅读全文

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