2020 年 3月 25 日随笔档案 - jinzhenshui

2020年3月25日

摘要：记住：永远使用：binlog_format=row 记住：尽量使max_allowed_packet大，如：max_allowed_packet=32M：sets max size of any single message between the MySQL server and clients 阅读全文

posted @ 2020-03-25 20:51 jinzhenshui 阅读(547) 评论(0) 推荐(0)

Mysql：Stored Object：视图、触发器、调度事件、存储过程、存储函数：【复合语句】语法

摘要： begin [...] end 复合语句，可以为“空”的begin end复合语句复合语句内可以包含0+其他语句，包括复合语句复合语句内包含的语句需要以分号 " ; " 分割整个复合语句必须作为一个完整的整体字符串发送给mysqld服务器去处理，因此，客户端必须要能正确处理批命令结束符，尤其是阅读全文

posted @ 2020-03-25 15:57 jinzhenshui 阅读(240) 评论(0) 推荐(0)

Mysql：Stored Object：视图、触发器、调度事件、存储过程、存储函数

摘要： Terminology used in this document reflects the stored object hierarchy: Stored routines include stored procedures(L1-1-1) and functions(L1-1-2). Store 阅读全文

posted @ 2020-03-25 15:32 jinzhenshui 阅读(247) 评论(0) 推荐(0)

Mysql：FAQ：A.14 Replication

摘要： A.14 MySQL 5.7 FAQ: Replication In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. A.14 阅读全文

posted @ 2020-03-25 14:49 jinzhenshui 阅读(154) 评论(0) 推荐(0)

Mysql：How do I force the master to block updates until the slave catches up?

摘要： A.14.4. How do I force the master to block updates until the slave catches up? Use the following procedure: On the master, execute these statements: m 阅读全文

posted @ 2020-03-25 14:39 jinzhenshui 阅读(169) 评论(0) 推荐(0)

Mysql：FAQ：A.5 Triggers

摘要： A.5 MySQL 5.7 FAQ: Triggers A.5.1. Where can I find the documentation for MySQL 5.7 triggers? A.5.2. Is there a discussion forum for MySQL Triggers? A 阅读全文

posted @ 2020-03-25 14:14 jinzhenshui 阅读(267) 评论(0) 推荐(0)

Mysql：Where are stored {procedures | functions | triggers} ? （例程）存储过程、函数、触发器，存在哪儿？

摘要： A.4.7. Where are stored procedures stored? In the proc table of the mysql system database. However, you should not access the tables in the system dat 阅读全文

posted @ 2020-03-25 14:02 jinzhenshui 阅读(139) 评论(0) 推荐(0)

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 阅读(237) 评论(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 阅读(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)