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
阅读(620)
推荐(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
阅读(1112)
推荐(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
阅读(195)
推荐(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
阅读(276)
推荐(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
阅读(1171)
推荐(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
阅读(416)
推荐(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
阅读(607)
推荐(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
阅读(1606)
推荐(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
阅读(292)
推荐(0) 编辑
Mysql：General Tablespace：一般（普通）（用户共享）表空间
摘要：15.6.3.3 General Tablespaces A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. General tablespace cap
阅读全文
posted @
2020-03-15 20:42
jinzhenshui
阅读(733)
推荐(0) 编辑
Mysql：innodb：File-Per-Table Tablespace：最大的弊病（每次增长仅仅4M）：碎片、慢！
摘要：15.6.3.2 File-Per-Table Tablespaces A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system
阅读全文
posted @
2020-03-15 20:38
jinzhenshui
阅读(368)
推荐(0) 编辑
Mysql：as of 8.0.14+：--admin-address、--admin-port、--create-admin-listener-thread
摘要：【不指定】该--admin-address选项（系统变量），则不会起该管理监听！！！ admin_address PropertyValue Command-Line Format --admin-address=addr Introduced 8.0.14 System Variable admi
阅读全文
posted @
2020-03-15 19:16
jinzhenshui
阅读(542)
推荐(0) 编辑
Mysql：Group Replication & Replication
摘要：Chapter 18 Group Replication Table of Contents 18.1 Group Replication Background 18.1.1 Replication Technologies 18.1.2 Group Replication Use Cases 18
阅读全文
posted @
2020-03-15 18:51
jinzhenshui
阅读(1084)
推荐(0) 编辑
Mysql：Replication & Group Replication
摘要：Chapter 17 Replication Table of Contents 17.1 Configuring Replication 17.1.1 Binary Log File Position Based Replication Configuration Overview 17.1.2
阅读全文
posted @
2020-03-15 18:49
jinzhenshui
阅读(671)
推荐(0) 编辑
Mysql：Plugin：clone=mysql_clone：as of 8.0.17
摘要：5.6.7 The Clone Plugin 5.6.7.1 Installing the Clone Plugin 5.6.7.2 Cloning Data Locally 5.6.7.3 Cloning Remote Data 5.6.7.4 Cloning Encrypted Data 5.6
阅读全文
posted @
2020-03-15 14:10
jinzhenshui
阅读(506)
推荐(0) 编辑
Mysql：来源于Mariadb的【审计】插件：server_audit
摘要：一：直接从mariadb的GA版本中提取server_audit{.so|.dll}，根据测试，不支持 Mysql 8+ 主要的、最近的版本 都已经是 1.4.4+： 完整的功能了。 CONNECT, QUERY, TABLE, QUERY_DDL, QUERY_DML, QUERY_DCL, QU
阅读全文
posted @
2020-03-14 18:51
jinzhenshui
阅读(1154)
推荐(0) 编辑
Mysql：--init-file && --init-connect
摘要：init_file PropertyValue Command-Line Format --init-file=file_name System Variable init_file Scope Global Dynamic No SET_VAR Hint Applies No Type File
阅读全文
posted @
2020-03-13 21:33
jinzhenshui
阅读(354)
推荐(0) 编辑
Mysql：8.0.19：Upgrading Mysql：升级
摘要：2.11 Upgrading MySQL 2.11.1 Before You Begin 2.11.2 Upgrade Paths 2.11.3 What the MySQL Upgrade Process Upgrades 2.11.4 Changes in MySQL 8.0 2.11.5 Pr
阅读全文
posted @
2020-03-13 20:26
jinzhenshui
阅读(1540)
推荐(0) 编辑
Mysql：8.0.19：新特性、过期、已经删除的
摘要：1.4 What Is New in MySQL 8.0 1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0 1.4 What Is New in MySQL 8.0 This
阅读全文
posted @
2020-03-13 20:18
jinzhenshui
阅读(1120)
推荐(0) 编辑
Mysql：5.5-5.6：Components & Plugins
摘要：5.5 MySQL Server Components 5.5.1 Installing and Uninstalling Components 5.5.2 Obtaining Server Component Information 5.5.3 Error Log Components MySQL
阅读全文
posted @
2020-03-13 19:51
jinzhenshui
阅读(391)
推荐(0) 编辑
