jinzhenshui - 博客园

2020年3月25日

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

2020年3月23日

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

2020年3月22日

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