jinzhenshui - 博客园

2020年3月16日

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 阅读(283) 评论(0) 推荐(0)