Mysql：Changes in MySQL 5.6.1 (Not released, Milestone 5)：--log -> --general-log ...
摘要：Changes in MySQL 5.6.1 (Not released, Milestone 5) Functionality Added or Changed Incompatible Change: The following obsolete constructs have been rem
阅读全文
posted @
2020-03-29 11:12
jinzhenshui
阅读(152)
推荐(0)
Mysql：Changes in MySQL 5.6.0 (Not released, Milestone 4)：Global UUID
摘要：Changes in MySQL 5.6.0 (Not released, Milestone 4) Globally Unique Server IDs Replication: Globally unique IDs for MySQL servers were implemented. A U
阅读全文
posted @
2020-03-29 11:05
jinzhenshui
阅读(164)
推荐(0)
Mysql：Changes in MySQL 5.6.4 (2011-12-20, Milestone 7)：微秒支持、Innodb全文索引支持
摘要：Changes in MySQL 5.6.4 (2011-12-20, Milestone 7) Fractional Seconds Handling Incompatible Change: MySQL now permits fractional seconds for TIME, DATET
阅读全文
posted @
2020-03-29 10:56
jinzhenshui
阅读(155)
推荐(0)
Mysql：Changes in MySQL 5.6.6 (2012-08-07, Milestone 9)：Group-Commit等等：重大变化版本！
摘要：Changes in MySQL 5.6.6 (2012-08-07, Milestone 9) Note This is a milestone release, for use at your own risk. Upgrades between milestone releases (or f
阅读全文
posted @
2020-03-29 10:48
jinzhenshui
阅读(168)
推荐(0)
Mysql：Changes in MySQL 5.6.9 (2012-12-11, Release Candidate)：GTID-based variables have been 【renamed】
摘要：Changes in MySQL 5.6.9 (2012-12-11, Release Candidate) Functionality Added or Changed Incompatible Change; Replication: A number of variable and other
阅读全文
posted @
2020-03-29 10:32
jinzhenshui
阅读(130)
推荐(0)
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
阅读(147)
推荐(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
阅读(94)
推荐(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
阅读(173)
推荐(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
阅读(111)
推荐(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
阅读(185)
推荐(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
阅读(287)
推荐(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
阅读(1182)
推荐(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
阅读(131)
推荐(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
阅读(142)
推荐(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
阅读(205)
推荐(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
阅读(497)
推荐(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
阅读(97)
推荐(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
阅读(551)
推荐(0)
Mysql：Stored Object：视图、触发器、调度事件、存储过程、存储函数：【复合语句】语法
摘要：begin [...] end 复合语句，可以为“空”的begin end复合语句 复合语句内可以包含0+其他语句，包括复合语句 复合语句内包含的语句需要以分号 " ; " 分割 整个复合语句必须作为一个完整的整体字符串发送给mysqld服务器去处理，因此，客户端必须要能正确处理批命令结束符，尤其是
阅读全文
posted @
2020-03-25 15:57
jinzhenshui
阅读(242)
推荐(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
阅读(249)
推荐(0)
浙公网安备 33010602011771号