Mysql：Changes in MySQL 5.6.13 (2013-07-31, General Availability)：不再支持可能引起混乱的【选项缩略】写法！
摘要：Changes in MySQL 5.6.13 (2013-07-31, General Availability) Functionality Added or Changed Previously, program options could be specified in full or as
阅读全文
posted @
2020-03-29 10:20
jinzhenshui
阅读(141)
推荐(0) 编辑
Mysql：Changes in MySQL 5.6.22 (2014-12-01, General Availability)：【sql-log-bin】
摘要：Changes in MySQL 5.6.22 (2014-12-01, General Availability) Deprecation and Removal Notes Replication: The global scope for the sql_log_bin system vari
阅读全文
posted @
2020-03-29 10:05
jinzhenshui
阅读(85)
推荐(0) 编辑
Mysql：Changes in MySQL 5.6.30 (2016-04-11, General Availability)：--ssl-mode：
摘要：Changes in MySQL 5.6.30 (2016-04-11, General Availability) Security Notes The linked OpenSSL library for the MySQL Commercial Server has been updated
阅读全文
posted @
2020-03-29 09:55
jinzhenshui
阅读(163)
推荐(0) 编辑
Mysql：Changes in MySQL 5.6.34 (2016-10-12, General Availability)：secure-file-priv
摘要：Changes in MySQL 5.6.34 (2016-10-12, General Availability) Security Notes Incompatible Change: The secure_file_priv system variable is used to limit t
阅读全文
posted @
2020-03-29 09:47
jinzhenshui
阅读(104)
推荐(0) 编辑
Mysql：Changes in MySQL 8.0.13 (2018-10-22, General Availability)：utf8mb3 ->utf8mb4
摘要：Changes in MySQL 8.0.13 (2018-10-22, General Availability) Deprecation and Removal Notes ... InnoDB: Support for TABLESPACE = innodb_file_per_table an
阅读全文
posted @
2020-03-28 13:52
jinzhenshui
阅读(176)
推荐(0) 编辑
Mysql：Changes in MySQL 8.0.17 (2019-07-22, General Availability)：是mysqld 内在转变的版本！！！
摘要：Changes in MySQL 8.0.17 (2019-07-22, General Availability) Deprecation and Removal Notes FLOAT(M,D) and DOUBLE(M,D) syntax to specify the number of di
阅读全文
posted @
2020-03-28 13:38
jinzhenshui
阅读(270)
推荐(0) 编辑
Mysql：Changes in MySQL 8.0.19 (2020-01-13, General Availability):（\!）可以在windows下正常工作了！
摘要：Changes in MySQL 8.0.19 (2020-01-13, General Availability) Deprecation and Removal Notes Setting the hash_join optimizer switch (see optimizer_switch
阅读全文
posted @
2020-03-28 13:25
jinzhenshui
阅读(1142)
推荐(0) 编辑
Mysql：Changes in MySQL 5.7.5 (2014-09-25, Milestone 15)：innodb_buffer_pool_size parameter is 【dynamic】
摘要：InnoDB Notes Incompatible Change: The InnoDB storage engine can no longer be disabled. The --skip-innodb option is deprecated and has no effect, and i
阅读全文
posted @
2020-03-27 20:54
jinzhenshui
阅读(123)
推荐(0) 编辑
Mysql：Changes in MySQL 5.7.7 (2015-04-08, Release Candidate)：The innodb_file_format default value was changed to Barracuda
摘要：Changes in MySQL 5.7.7 (2015-04-08, Release Candidate) Functionality Added or Changed Important Change; InnoDB: The following changes were made to Inn
阅读全文
posted @
2020-03-27 20:43
jinzhenshui
阅读(135)
推荐(0) 编辑
Mysql：Changes in MySQL 5.7.9 (2015-10-21, General Availability)：很重要的版本！
摘要：Changes in MySQL 5.7.9 (2015-10-21, General Availability) Server Administration A new SHUTDOWN SQL statement is available. This provides an SQL-level
阅读全文
posted @
2020-03-27 20:30
jinzhenshui
阅读(195)
推荐(0) 编辑
Mysql：Changes in MySQL 5.7.13 (2016-06-02, General Availability)：maximum length of MySQL user names was increased from 16 to 32 characters
摘要：Changes in MySQL 5.7.13 (2016-06-02, General Availability) Account Management Notes In MySQL 5.7.8, the maximum length of MySQL user names was increas
阅读全文
posted @
2020-03-27 20:22
jinzhenshui
阅读(488)
推荐(0) 编辑
Mysql：Changes in MySQL 5.7.22 (2018-04-19, General Availability)：These compatibility 【SQL modes】 are now deprecated and will be removed
摘要：Changes in MySQL 5.7.22 (2018-04-19, General Availability) Deprecation and Removal Notes These compatibility SQL modes are now deprecated and will be
阅读全文
posted @
2020-03-27 20:06
jinzhenshui
阅读(92)
推荐(0) 编辑
Mysql：Row-based Replication：运维：一直更新中...
摘要：记住：永远使用 ：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
阅读(543)
推荐(0) 编辑
Mysql：Stored Object：视图、触发器、调度事件、存储过程、存储函数：【复合语句】语法
摘要：begin [...] end 复合语句，可以为“空”的begin end复合语句 复合语句内可以包含0+其他语句，包括复合语句 复合语句内包含的语句需要以分号 " ; " 分割 整个复合语句必须作为一个完整的整体字符串发送给mysqld服务器去处理，因此，客户端必须要能正确处理批命令结束符，尤其是
阅读全文
posted @
2020-03-25 15:57
jinzhenshui
阅读(235)
推荐(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
阅读(234)
推荐(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
阅读(149)
推荐(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
阅读(164)
推荐(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
阅读(263)
推荐(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
阅读(133)
推荐(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
阅读(227)
推荐(0) 编辑
