Mysql - 随笔分类(第5页) - jinzhenshui

Mysql：The CSV Storage Engine

摘要：注意： 1）表定义（换句话说）数据列必须不能为空Null！ 2）修复表，极有可能丢失数据 16.4 The CSV Storage Engine 16.4.1 Repairing and Checking CSV Tables 16.4.2 CSV Limitations The CSV stora 阅读全文

posted @ 2020-03-17 08:46 jinzhenshui 阅读(286) 评论(0) 推荐(0)

Mysql：The Memory Storage Engine

摘要：16.3 The MEMORY Storage Engine The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memo 阅读全文

posted @ 2020-03-17 08:45 jinzhenshui 阅读(190) 评论(0) 推荐(0)

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 阅读(264) 评论(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 阅读(713) 评论(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 阅读(295) 评论(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 阅读(696) 评论(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 阅读(1183) 评论(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 阅读(204) 评论(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 阅读(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 阅读(1264) 评论(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 阅读(1655) 评论(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 阅读(316) 评论(0) 推荐(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 阅读(793) 评论(0) 推荐(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 阅读(396) 评论(0) 推荐(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 阅读(561) 评论(0) 推荐(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 阅读(1138) 评论(0) 推荐(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 阅读(702) 评论(0) 推荐(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 阅读(532) 评论(0) 推荐(0)

随笔分类 - Mysql