jinzhenshui - 博客园

2020年3月25日

Mysql：5.7：all triggers are 【FOR EACH ROW】

摘要： A.5.3. Does MySQL 5.7 have statement-level or row-level triggers? In MySQL 5.7, all triggers are FOR EACH ROW; that is, the trigger is activated for e 阅读全文

posted @ 2020-03-25 13:54 jinzhenshui 阅读(242) 评论(0) 推荐(0)

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