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

Mysql：FAQ：A.4 Stored Procedures and Functiions

摘要：A.4 MySQL 5.7 FAQ: Stored Procedures and Functions A.4.1. Does MySQL 5.7 support stored procedures and functions? A.4.2. Where can I find documentatio 阅读全文

posted @ 2020-03-25 13:50 jinzhenshui 阅读(208) 评论(0) 推荐(0) 编辑

ANSI SQL 2003：美国国家标准：SQL-2003：该规范并不是free获取——你得花钱！

摘要：A.4.4. Where can I find the ANSI SQL 2003 specification for stored procedures? Unfortunately, the official specifications are not freely available (AN 阅读全文

posted @ 2020-03-25 13:38 jinzhenshui 阅读(1331) 评论(0) 推荐(0) 编辑

Mysql：可恨又可怜Query Cache特性：已死！莫用！

摘要：A.1.4. Does MySQL 5.7 have a Query Cache? Does it work on Server, Instance or Database? Yes. (However, the query cache is deprecated as of MySQL 5.7.2 阅读全文

posted @ 2020-03-25 11:40 jinzhenshui 阅读(273) 评论(0) 推荐(0) 编辑

Mysql：Innodb Cluster【It's not NDB】：Based On Group Replication

摘要：Chapter 21 InnoDB Cluster Table of Contents 21.1 Introducing InnoDB Cluster 21.2 Creating an InnoDB Cluster 21.2.1 Deployment Scenarios 21.2.2 InnoDB 阅读全文

posted @ 2020-03-23 13:47 jinzhenshui 阅读(307) 评论(0) 推荐(0) 编辑

Mysql：read-only 配置

摘要：重点： super_read_only、read_only：不会从master传递（复制）到slave super_read_only=on隐含实现read_only=on read_only=off隐含实现super_read_only=off super_read_only PropertyVa 阅读全文

posted @ 2020-03-22 20:16 jinzhenshui 阅读(2260) 评论(0) 推荐(0) 编辑

Mysql：我自己总也记不住的【选项语法规则】： Command-Line-Options、Configure-Options、System-Variables、Status-Variables

摘要：横杠与下划线：-、_：At runtime, system variable names must be written using underscores, not dashes 前缀：--maximum- 大小写：布尔值：0、1、off、on、false、true：某些布尔值配置，在启动命令阅读全文

posted @ 2020-03-22 17:46 jinzhenshui 阅读(407) 评论(0) 推荐(0) 编辑

Mysql：Delayed Replication：延迟复制

摘要：语法很简单，意义却很重大！ 16.3.10 Delayed Replication MySQL 5.7 supports delayed replication such that a slave server deliberately lags behind the master by at le 阅读全文

posted @ 2020-03-22 16:23 jinzhenshui 阅读(412) 评论(0) 推荐(0) 编辑

Mysql：Semi-Synchronous Replication：大名鼎鼎的【半同步】复制

摘要：提示：配置很简单：安装插件，然后...没有什么然后，哈哈 master-side: SET GLOBAL rpl_semi_sync_master_enabled={0|1}; SET GLOBAL rpl_semi_sync_master_timeout={10000|N}; --10秒 slav 阅读全文

posted @ 2020-03-22 14:20 jinzhenshui 阅读(430) 评论(0) 推荐(0) 编辑

Mysql：Replication

摘要：Chapter 16 Replication Table of Contents 16.1 Configuring Replication 16.1.1 Binary Log File Position Based Replication Configuration Overview 16.1.2 阅读全文

posted @ 2020-03-22 12:42 jinzhenshui 阅读(221) 评论(0) 推荐(0) 编辑

Mysql：Group Replication：实战：注意事项

摘要：重点： GR中第1台必须使用group_replication_bootstrap_group=on 之后，手工start group_replication，自举创建第一个GR资源视图。随后的第2+台万万不可再使用该参数！ Configuring group_replication_bootstr 阅读全文

posted @ 2020-03-21 23:13 jinzhenshui 阅读(226) 评论(0) 推荐(0) 编辑

Mysql：Group Replication

摘要：Chapter 17 Group Replication Table of Contents 17.1 Group Replication Background 17.1.1 Replication Technologies 17.1.2 Group Replication Use Cases 17 阅读全文

posted @ 2020-03-21 09:46 jinzhenshui 阅读(677) 评论(0) 推荐(0) 编辑

Mysql：SQL Modes：最令我烦的sql-modes：一个标准它不香么？！

摘要：核心：所谓的各种sql mode就是mysqld的各种语法检查开关。原则：如果你不想有各种烦恼：不要去设置它！提示：如果你想设置它，尽量兼容国际标准。 The default SQL mode in MySQL 8.0 includes these modes: ONLY_FULL_GROUP_ 阅读全文

posted @ 2020-03-17 11:39 jinzhenshui 阅读(524) 评论(0) 推荐(0) 编辑

Mysql：Alternative Storage Engines：可替换存储引擎：mysqld的核心特性

摘要：请注意：NO_ENGINE_SUBSTITUTION Chapter 16 Alternative Storage Engines Table of Contents 16.1 Setting the Storage Engine Storage engines are MySQL componen 阅读全文

posted @ 2020-03-17 09:27 jinzhenshui 阅读(414) 评论(0) 推荐(0) 编辑

Mysql：The BLACKHOLE Storage Engine

摘要：Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated t 阅读全文

posted @ 2020-03-17 09:05 jinzhenshui 阅读(172) 评论(0) 推荐(0) 编辑

Mysql：The ARCHIVE Storage Engine

摘要：记录下，尚不知如何用？！ 16.5 The ARCHIVE Storage Engine The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in 阅读全文

posted @ 2020-03-17 08:57 jinzhenshui 阅读(214) 评论(0) 推荐(0) 编辑

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 阅读(273) 评论(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 阅读(182) 评论(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 阅读(254) 评论(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 阅读(667) 评论(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 阅读(278) 评论(0) 推荐(0) 编辑

随笔分类 - Mysql

随笔分类 (1001)

随笔档案 (746)

最新评论