jinzhenshui - 博客园

2020年3月15日

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 阅读(789) 评论(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 阅读(391) 评论(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 阅读(560) 评论(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 阅读(1133) 评论(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 阅读(701) 评论(0) 推荐(0)