专栏首页MySQL修行 | 老叶茶馆The complete list of new features in MySQL 8.0

The complete list of new features in MySQL 8.0

截止目前最完整的MySQL 8.0新特性列表。

原文出处:https://mysqlserverteam.com/the-complete-list-of-new-features-in-mysql-8-0/

There are over 300 new features in MySQL 8.0. The MySQL Manual is very good, but verbose. This is a list of new features in short bullet form. We have tried very hard to make sure each feature is only mentioned once. Note the similar list for MySQL 5.7.

Please download MySQL 8.0 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.

SQL DML

  1. Non-recursive CTEs [1]
  2. Recursive CTEs [1]
  3. Window functions [1]
  4. ORDER BY and DISTINCT with ROLLUP [1]
  5. LATERAL derived tables [1]
  6. Outer table references in derived tables [1]
  7. VALUES [1]
  8. Referencing old/new row in INSERT … ON DUPLICATE KEY UPDATE [1]
  9. LIMIT in recursive CTEs [1]

SQL DDL

  1. Instant ADD COLUMN [1]
  2. Instant RENAME COLUMN [1]
  3. Instant RENAME TABLESPACE [1]
  4. RESTART statement [1]
  5. SET PERSIST statement [1]
  6. RENAME TABLES under LOCK TABLES [1]
  7. Option to disallow tables without primary keys [1]
  8. Character set conversion as an inplace operation [1 2]
  9. CREATE TABLESPACE without DATAFILE clause [1]
  10. CREATE RESOURCE GROUP [1 2]
  11. ALTER RESOURCE GROUP [1 2]
  12. DROP RESOURCE GROUP [1 2]
  13. Expressions as DEFAULT values [1]
  14. CHECK constraint [1]
  15. ALTER TABLE … ADD CONSTRAINT [1]
  16. ALTER TABLE … DROP CONSTRAINT [1]
  17. ALTER TABLE … ALTER CONSTRAINT [1]
  18. CLONE INSTANCE [1]

Indexes

  1. Invisible indexes [1]
  2. Descending indexes [1]
  3. Functional indexes [1]
  4. Index skip scan [1]
  5. Index Hints USE / IGNORE / FORCE INDEX [1]

Functions

  1. New function REGEXP_INSTR [1]
  2. New function REGEXP_LIKE [1]
  3. New function REGEXP_REPLACE [1]
  4. New function REGEXP_SUBSTR [1]
  5. New function UUID_TO_BIN [1]
  6. New function BIN_TO_UUID [1]
  7. New function IS_UUID [1]
  8. New function GROUPING [1 2]
  9. New function STATEMENT_DIGEST [1]
  10. New function STATEMENT_DIGEST_TEXT [1]
  11. Bit operations allowed on BINARY, VARBINARY, BLOB, TINYBLOB, MEDIUMBLOB and LONGBLOB [1]
  12. TIMESTAMP/DATETIME values can now include timezone details [1]

JSON

  1. New function JSON_PRETTY [1]
  2. New function JSON_STORAGE_SIZE [1]
  3. New function JSON_STORAGE_FREE [1]
  4. New function JSON_MERGE_PATCH [1]
  5. New aggregation and window function JSON_ARRAYAGG [1]
  6. New aggregation and window function JSON_OBJECTAGG [1]
  7. New table function JSON_TABLE [1]
  8. Faster sorting of JSON values [1]
  9. Ranges in JSON patch expressions [1 2]
  10. In-place updates of JSON values [1 2]
  11. JSON Schema validation [1]
  12. JSON array indexes [1 2]
  13. New operator MEMBER_OF [1]
  14. New function JSON_OVERLAPS [1]
  15. New function JSON_VALUE [1]

GIS

  1. Spatial reference systems (SRSs) [1 2 3 4]
  2. CREATE SPATIAL REFERENCE SYSTEM statement [1 2]
  3. DROP SPATIAL REFERENCE SYSTEM statement [1]
  4. SRID type modifier [1 2]
  5. Geographic R-trees [1]
  6. New setter function ST_SRID(geometry, new_srid) [1]
  7. New setter function ST_X(geometry, new_x) [1]
  8. New setter function ST_Y(geometry, new_y) [1]
  9. New function ST_SwapXY [1]
  10. New function ST_Latitude [1]
  11. New function ST_Longitude [1]
  12. New function ST_Transform [1]
  13. Geography support in ST_Distance, ST_Contains, ST_Crosses, ST_Disjoint, ST_Equals, ST_Intersects, ST_Overlaps, ST_Touches, ST_Within, MBRContains, MBRCoveredBy, MBRCovers, MBRDisjoint, MBREquals, MBRIntersects, MBROverlaps, MBRTouches, MBRWithin, ST_IsSimple, ST_IsValid, ST_Length, ST_Validate, ST_Area [1 2 3 4 5 6 7 8]
  14. ST_Distance_Sphere for geographic geometries [1]
  15. Ellipsoidal ST_Distance between any two geometry types [1]
  16. GEOMCOLLECTION as synonym to GEOMETRYCOLLECTION [1 2 3]
  17. Optional SPATIAL keyword in R-tree index clauses [1]
  18. Ability to specify length unit in ST_Distance() [1]
  19. Ability to specify length unit in ST_Length() [1]

Character sets and collations

  1. UTF-8 (utf8mb4) as default character set [1 2 3 4 5 6 7 8 9 10 11]
  2. General Unicode 9.0 collations covering German (dictionary order), Austrian German (dictionary order), English, French (including accent insensitive Canadian French), Irish, Indonesian, Italian, Luxembourgian, Malay, Dutch (including Flemish), Portuguese (including Brazilian Portuguese), Swahili, and Zulu [1 2]
  3. Unicode 9.0 collation for Czech
  4. Unicode 9.0 collation for Danish (also valid for Norwegian)
  5. Unicode 9.0 collation for German (phonebook order)
  6. Unicode 9.0 collation for Esperanto
  7. Unicode 9.0 collation for Spanish
  8. Unicode 9.0 collation for Spanish (traditional)
  9. Unicode 9.0 collation for Estonian
  10. Unicode 9.0 collation for Croatian (also valid for Serbian with latin characters, and Bosnian)
  11. Unicode 9.0 collation for Hungarian
  12. Unicode 9.0 collation for Icelandic
  13. Unicode 9.0 collation for Lithuanian
  14. Unicode 9.0 collation for Latvian
  15. Unicode 9.0 collation for Polish
  16. Unicode 9.0 collation for Romanian
  17. Unicode 9.0 collation for Slovak
  18. Unicode 9.0 collation for Slovenian
  19. Unicode 9.0 collation for Swedish
  20. Unicode 9.0 collation for Turkish
  21. Unicode 9.0 collation for Vietnamese
  22. Unicode 9.0 collation for Japanese (including kana sensitive collation)
  23. Unicode 9.0 collation for Chinese
  24. Unicode 9.0 collation for Russian (also valid for Bulgarian)
  25. Unicode support in RLIKE and REGEXP [1]
  26. Unicode 9.0 code point order collation (utf8mb4_0900_bin) [1]

Information Schema

  1. Information Schema implemented as views over data dictionary tables [1]
  2. VIEW_TABLE_USAGE [1]
  3. VIEW_ROUTINE_USAGE [1]
  4. KEYWORDS [1]
  5. COLUMN_STATISTICS [1]
  6. ST_GEOMETRY_COLUMNS [1]
  7. ST_SPATIAL_REFERENCE_SYSTEMS [1]
  8. ST_UNITS_OF_MEASURE [1]
  9. RESOURCE_GROUPS [1]
  10. CHECK_CONSTRAINTS [1, 2]
  11. APPLICABLE_ROLES [1]
  12. ADMINISTRABLE_ROLE_AUTHORIZATIONS [1]
  13. ENABLED_ROLES [1]
  14. ROLE_TABLE_GRANTS [1]
  15. ROLE_COLUMN_GRANTS [1]
  16. ROLE_ROUTINE_GRANTS [1]

Performance Schema

  1. Performance Schema Indexes [1]
  2. Instrument server errors [1]
  3. Statements latency histograms [1]
  4. Instrument data locks [1]
  5. Pluggable performance schema tables [1]
  6. Added QUERY_SAMPLE_TEXT [1]
  7. Added Thread Pool Tables [1] (Enterprise)

SHOW

  1. SHOW now lists hidden columns [1]
  2. SHOW now lists index information [1]

Optimizer

  1. Histograms [1 2 3]
  2. Adaptive scan buffer size [1]
  3. IO costs separation between memory and disk [1]
  4. Default values in cost tables [1]
  5. Sampling interface in storage engine API [1 2 3 4]
  6. NOWAIT and SKIP LOCKED [1 2]
  7. Avoid unnecesary index dives with FORCE INDEX [1 2 3]
  8. Optimizer switch to use invisible indexes [1 2 3]
  9. Increased default optimizer trace buffer size [1]
  10. New hint MERGE [1]
  11. New hint INDEX_MERGE [1]
  12. New hint NO_INDEX_MERGE [1]
  13. New hint JOIN_FIXED_ORDER [1]
  14. New hint JOIN_ORDER [1]
  15. New hint JOIN_PREFIX [1]
  16. New hint JOIN_SUFFIX [1]
  17. New hint SET_VAR [1]
  18. Consider covering prefix indexes for LIKE [1]
  19. Transformed statement in EXPLAIN of INSERT/UPDATE/REPLACE/DELETE [1]
  20. EXPLAIN ANALYZE [1]
  21. HASH JOIN (inner-, outer-, anti- and semijoin) [1]
  22. Batch Key Access in the iterator executor [1 2]
  23. Enhanced group-by loose index scan [1]
  24. New optimizer switch to disable limit optimization [1]
  25. Semijoin now works with single-table UPDATE/DELETE [1 2]

InnoDB

  1. Highly scalable latch free redo log implementation [1 2].
  2. Redesign of LOB infrastructure for better performance [1 2 3]
  3. State of the art lock scheduler using Contention Aware Transaction Scheduling (CATS) (Contribution from University of Michigan) [1]
  4. Infrastructure to do non locking parallel reads (currently used by CHECK TABLE) [1]
  5. Instant add column and virtual column [1]
  6. Report pages cached in the buffer pool by indexes via the information schema [1]
  7. Persistent auto increment [1]
  8. Manage UNDO tablespaces using SQL syntax [1]
  9. New in-memory temptable storage engine for use by optimiser [1]
  10. Support for BLOBs in new temptable engine [1 2]
  11. Dedicated server mode, automatically configures the buffer pool and redo log size [1 2]
  12. Remove the buffer pool mutex (Percona contribution) [1]
  13. Improved purge [1]
  14. Dynamically enable/disable the deadlock detector [1]
  15. IO layer is now more scalable and efficient [1]
  16. Extended locking semantics with skip and no-waits [1 2]
  17. Use the new error logging infra structure [1]
  18. System data dictionary is now stored in InnoDB [1]
  19. New configuration to generate smaller core files [1]
  20. Deprecate Shared tablespaces in partitioned table [1]
  21. Reclaim temporary tablespace disk space online [1]
  22. New option to control write IOPs when idle [1]
  23. Support for table data sampling for histograms [1]
  24. Case insensitive names for partition tables [1]
  25. Improved CATS implementation (Lock manager) [1]
  26. Lock-sys optimization: sharded lock_sys mutex [1]
  27. Write double write buffer to a separate file to ensure atomic writes [1]
  28. Enable/disable redo log globally [1]
  29. CREATE/TRUNCATE of undo tablespaces are now redo logged [1]
  30. Tablespace filename validation has been made optional [1]
  31. Tablespaces has been restricted to known directories [1 2]

Data Dictionary, Atomic and crash safe DDL, Upgrade

  1. Transactional Data Dictionary [1]
  2. Store all meta data in InnoDB, no FRMs, TRG etc [1,2]
  3. Store redundant copy of meta data in SDI [1]
  4. Tablespace version support for better upgrade/downgrade experience [1]
  5. Self describing tablespaces with Serialized Dictionary Information (SDI) [1]
  6. Tools to manage the SDI [ 1]
  7. Atomic and crash safe DDL [1]
  8. CREATE TABLE…SELECT has been made atomic and crash-safe [1]
  9. Automatic upgrade of dictionary tables, and enhanced checks [1]
  10. Automatic upgrade, no need for mysql_upgrade script [1]

Network

  1. Support multiple addresses for the –bind-address command option [1]
  2. Add Admin Port [1 2 3 4 5]
  3. Remove mutex bottlenecks for connect/disconnect performance [1]
  4. Support host names longer than 60 characters [1]

Error logging

  1. Improved error logging in 8.0 [1]
  2. Defaults change: log_error_verbosity=2 [1]
  3. Added severity, error code, subsystem to error messages [1]
  4. Filtering the error log [1]
  5. Error logging in JSON format [1]
  6. Force-print specific non-error messages to error log [1]
  7. Suppress error logs of type warning or note [1]
  8. New “syseventlog” settings [1]
  9. Added –log-slow-extra, for richer slow logging [1]
  10. Added new “ts” timestamp for JSON error log [1]

Replication

  1. Multi-source Replication Per Channel Filters [1]
  2. Atomic DDL Recovery With The Binary Log [1]
  3. Write-set Based Transaction Dependency Tracking [1 2 ]
  4. Reduced Contention Between Receiver and Applier Threads [1]
  5. GTID Support for Temporary Tables Inside Transactions [1]
  6. Partial JSON Update Replication [1]
  7. Extended table metadata in the binary log [1 2]
  8. RESET MASTER TO ‘x’ [1]
  9. Settable GTID_PURGED When GTID_EXECUTED is Not Empty [1]
  10. Sub-second Binary Logs Expiration Settings [1]
  11. Non-Blocking Replication Monitoring even when Disk is Full [1]
  12. Transaction Byte Length Metadata in Binary log [1]
  13. Server Versions for each Transaction in the Binary Log [1, 2, 3]
  14. Support for START SLAVE UNTIL for Multi-Threaded Applier [1]
  15. Delayed Replication in Microseconds [1]
  16. binlog-row-event-max-size system variable [1]
  17. PFS: Applier Lag and Queues Monitoring [1 2 3]
  18. PFS: Read Consistent Log Positions for Backups [1]
  19. PFS: Row-based Replication Applier Thread Progress [1]
  20. PFS: Counters for Replication Applier Retries [1]
  21. Rotating binary log master key online [1]
  22. Partition metadata in the Binary Log [1]
  23. Encrypt binary log caches [1]
  24. Protocol compression support for mysqlbinlog [1]
  25. Replication with privilege checks [1 2]
  26. New CHANGE MASTER … REQUIRE_ROW_FORMAT option [1]
  27. New slave_preserve_commit_order option [1]
  28. Binary log compression [1]
  29. Enable/disable primary key checks on slaves [1]

Group Replication

  1. Transaction Savepoint Support [1]
  2. Disallow Writes to Isolated Members in Group Replication [1 2 3]
  3. Group-wide Certification and Applier Stats Monitoring [1 2]
  4. Options to Fine-tune the Flow-Control [1 2 3 4 5 6 7 8]
  5. Support for Hostnames in the Whitelist [1]
  6. Shutdown Server When Server Drops Out of the Group [1]
  7. Online and User-Triggered Primary Switchover/Election [1 2]
  8. Online and User-Triggered Single-to-Multi Primary Switchover [1 2]
  9. Configurable Messaging Pipelining [1 2]
  10. Relaxed Member Eviction [1]
  11. Consistent Reads [1]
  12. Consistent Reads on Primary Fail-over [1]
  13. IPv6 Support [1 2]
  14. Tracing for Message Passing [1]
  15. Configure primary failover candidates priority [1 2]
  16. PFS: Instrumented Threads [1 2]
  17. PFS: Instrumented Mutexes and Condvars [1 2]
  18. PFS: Instrumented Memory Used for the Message Cache [1 2]
  19. Better support for large transactions in GR [1 1]
  20. Ability to configure the GR communication protocol [1 1]
  21. Changed EXIT STATE ACTION default to READ_ONLY [1]
  22. Auto-rejoin of Group Members [1 2]
  23. New fencing mode for Group Replication: OFFLINE_MODE [1 2]
  24. Group Replication distributed recovery with automated instance cloning [1]
  25. Enhanced cross-version inter-operability for Group Replication [1]
  26. TLS 1.3 support for Group Communication System (GCS/XCom) [1 2]
  27. Group Delivery Message Service [1]
  28. Lower minimum value of group_replication_message_cache_size [1]
  29. Increase default group_replication_autorejoin_tries [1]
  30. Increase default group_replication_member_expel_timeout [1]
  31. IPs and ports used during GR distributed recovery can now be specified [1]
  32. Classify important GR log messages as system messages [1]
  33. START GROUP_REPLICATION to support credentials as parameters [1]
  34. Added support for binary log checksums in GR [1]

Security – Authentication

  1. Caching sha2 authentication plugin [1]
  2. Introduce delays in authentication based on failed logins [1]
  3. Password rotation policy enforcement [1]
  4. Old password required for SET PASSWORD for some users [1]
  5. Support 2 active passwords per user account [1]
  6. Identification by RANDOM PASSWORD [1 2]
  7. Option to display passwords as hexadecimal strings [1]
  8. Extra authentication to allow SET PERSIST for security sensitive variables [1]
  9. SASL authentication for LDAP on windows [1] (Enterprise)
  10. LDAP authentication plugin (client and server) [1] (Enterprise)
  11. Add support for users with multiple LDAP groups [1] (Enterprise)
  12. Allow users to store user account COMMENT/ATTRIBUTE into the mysql.user table [1]
  13. Support separate set of TLS certificates for admin connection port [1]

Security – Authorization

  1. SQL Roles [1]
  2. Break the SUPER privilege into dynamic privileges [1]
  3. Granting default roles when new users are created [1 2 3]
  4. Additional safety to –skip-grant-tables [1]
  5. Secure session variable setting (MYSQL_SESSION_ADMIN privilege) [1]
  6. Checking authorization for rolling back XA-transactions [1]
  7. Added Partial Revokes [1]
  8. Added the SYSTEM_USER dynamic privilege [1]
  9. FAILED_LOGIN_ATTEMPTS/PASSWORD_LOCK_TIME counters per user [1]
  10. Added the SHOW_ROUTINE privilege [1]

Security – Auditing

  1. Audit log: abort queries on rule based conditions [1] (Enterprise)
  2. Audit log: JSON format, compression and encryption [1] (Enterprise)
  3. Audit log: SQL function to inject data into the Audit log [1] (Enterprise)
  4. Audit log: Multiple encryption passwords [1] (Enterprise)

Security – Encrypt Data at Rest

  1. Control Table encryption [1]
  2. Redo log encryption [1]
  3. Undo log encryption [1]
  4. General Tablespace encryption [1]
  5. System Tablespace encryption [1]
  6. Binary Log encryption [1]

Security – Keyring

  1. Server as a keyring backend migration tool [1]
  2. Keyring plugin for AWS KMS [1] (Enterprise)
  3. Keyring plugin for Hashicorp Vault [1] (Enterprise)
  4. Allow users to store, retrieve, and manage any opaque data in the keyring [1]

Security – Data Masking

  1. Data masking functions [1] (Enterprise)

Security – SSL & Other

  1. Atomic ACL statements [1]
  2. OpenSSL Only [1]
  3. Support for FIPs enabled OpenSSL library [1 2]
  4. Ensure that foreign key error does not reveal information about parent table [1]
  5. Added support for TLS 1.3 [1]
  6. Allow switching SSL options for a running server [1]
  7. The –ssl-mode client side option to streamline SSL checking [1]
  8. Support for TLS 1.3 in Asynchronous Replication: MASTER_TLS_CIPHERSUITES option on CHANGE MASTER command, the group_replication_recovery_tls_version plugin option and the group_replication_recovery_tls_ciphersuites plugin option [1]

Shell

  1. InnoDB Cluster: A packaged solution for Shell, Router, and Group Replication [1 2]
  2. InnoDB ReplicaSet: A packaged solution for Shell, Router, and Async. Replication [1]
  3. Remote MySQL server configuration and re-configuration for InnoDB clusters [1]
  4. Extended cluster status display, including replication lag times [1]
  5. Manual primary switch-over and topology re-configuration in InnoDB clusters [1]
  6. Advanced cluster customizations for more use-cases and environments
  7. MySQL server upgrade checker [1, 2]
  8. Import JSON and JSON serialized BSON data [1, 2]
  9. Updated X DevAPI support
  10. Secure password management [1, 2]
  11. Display column metadata for query results [1]
  12. Direct command line execution of shell APIs [1]
  13. Improved built-in help [1]
  14. Screen paging [1]
  15. Auto-completion [1]
  16. Persisted command history by Shell mode. [1]
  17. Custom prompts [1]
  18. The \sql shell command also works in JavaScript or Python mode [1]
  19. Support for server monitoring through user defined reports and the \show and \watch shell commands [1]
  20. Parallel Data Import Utility [1]
  21. Support for Shell Extensions [1]
  22. Support for Shell Plugins [1 2]
  23. Support for different result formats: Table, tabbed, vertical, json/raw, json/pretty [1]
  24. MySQL Shell Logical Dump and Load Utilities [1 2 3 4 5]
  25. Support for hiding instances on MySQL InnoDB Cluster/ReplicaSet [1]

Router

  1. Persist last known metadata-server addresses [1]
  2. Reset max_connect_errors on successful connections [1]
  3. Build Router as part of the MySQL Server source-tree [1]
  4. Added mysqlrouter_plugin_info tool [1]
  5. Reduced metadata-cache TTL from 300s to 500ms [1]
  6. Added routing strategies [1]
  7. Added bootstrap option for –report-host [1]
  8. Added bootstrap option for –account-host [1]
  9. Disconnect clients to server-nodes that changed from PRIMARY to SECONDARY [1]
  10. Log-rotation via SIGHUP [1]
  11. HTTP server plugin [1]
  12. Flexible support for single/multi-PRIMARY Group Replication [1]
  13. New mysqlrouter_keyring utility [1]
  14. Sub-second timestamp resolution in router log [1]
  15. Support for ReplicaSet in Router [1]
  16. Handle the metadata upgrade in the Router [1]
  17. New bootstrap option (–account) to allow reuse of an existing account [1]
  18. Authenticating the HTTP component against the MySQL Innodb Cluster metadata [1]
  19. New pid-file option [1]
  20. New “note” and “system” log level [1]
  21. User configurable log filename [1]
  22. Support hiding nodes from applications [1]

X Protocol / X Plugin

  1. Connection compression in the X Plugin / X Protocol [1]
  2. Zstd compression in the X Plugin / X Protocol [1]
  3. Configurable compression level in the X Plugin / X Protocol [1]
  4. Document schema validator in the X Plugin [1]
  5. Multiple –mysqlx-bind-address now supported in the X Plugin [1]

Misc

  1. Defaults change: Binlog is ON [1 2]
  2. Defaults change: X Protocol is Enabled [1]
  3. Defaults change: master_info_repository = TABLE [1 2]
  4. Defaults change: relay_log_info_repository = TABLE [1 2]
  5. Defaults change: explicit_defaults_for_timestamp= ON [1]
  6. Defaults change: max_error_count=1024 [1]
  7. Renamed tx_read_only variable to transaction_read_only [1]
  8. Renamed tx_isolation variable to transaction_isolation [1]
  9. Defaults change: max_allowed_packet=67108864 [1]
  10. Defaults change: event_scheduler=ON [1]
  11. Defaults change: back_log=-1 (auto-sized) [1]
  12. Defaults change: table_open_cache=4000 [1 2]
  13. Added mysqld_safe-functionality to server [1 2 3]
  14. Minimal tarballs [1]
  15. New Backup Lock [1]
  16. Server version stored in InnoDB tablespaces [1]
  17. Enable MDL Locking for Recovered and Detached Prepared XA Transactions [1]
  18. Support meta data locking for Foreign Keys [1]
  19. The service registry and the component infrastructure [1]
  20. CLI interface to read the replication stream [1]
  21. UDF registration service to allow components to auto-register UDFs [1]
  22. MySQL server strings component service [1]
  23. Make result set metadata transfer optional [1]
  24. Status variables service for components [1]
  25. Performance schema instrumentation via a component service [1]
  26. System variables service for components [1]
  27. Password validation plugin implemented as a component [1]
  28. Component service to deliver signals to the host application
  29. Allow plugins to use prepared statements [1]
  30. INSERT/UPDATE/DELETE in query rewrite plugin [1]
  31. Dynamic allocation of sort buffer [1]
  32. Variable length sort keys for NO PAD collations [1]
  33. Faster SELECT COUNT (*) without grouping [1]
  34. Source code improvements [1]
  35. Small tarball download option [1]
  36. CAST to FLOAT and DOUBLE [1]
  37. OS user as a connection attribute [1]
  38. gtid_purged as a comment in mysqldump files [1]
  39. Early plugin load flag [1]
  40. Current thread component service [1]
  41. Mutex lock order tool [1]
  42. Connection compression control [1]
  43. Dynamic linking of Protobuf [1]
  44. Increase max value for max_prepared_stmt_count [1]
  45. Move sys Schema to the mysql server tree [1]
  46. Compile time check of error message arguments [1]
  47. Identifying the exact location where a document violates a schema constraint [1]
  48. Command line tool’s –binary-as-hex on by default for interactive terminals [1]
  49. Character Sets in the User Defined Functions API [1 2]
  50. Sys Schema: Stored functions have been replaced by native functions [1]
  51. The “system” mysql command line command now also works on Windows [1]
  52. Admin sessions are not subject to the max_connection limit [1]
  53. Duplicate key error information now includes the table name of the key [1]
  54. Use signal SIGUSR1 to flush logs [1]
  55. The MySQL C API now supports compression for asynchronous functions [1]
  56. Client library safe LOAD DATA LOCAL INFILE directories [1]

Enjoy MySQL 8.0 :)

全文完。

本文分享自微信公众号 - 老叶茶馆(iMySQL_WX),作者:Geir Hoydalsvik

原文出处及转载信息见文内详细说明,如有侵权,请联系 yunjia_community@tencent.com 删除。

原始发表时间:2020-08-10

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

我来说两句

0 条评论
登录 后参与评论

相关文章

  • 手把手教学-MySQL主从复制架构转换MGR架构(mysq_shell版)

    可以推断出, 在转为MGR过程中,由于有选举动作的产生,原事务对master 地址的访问很可能因为原master角色变更而失败,这一点需要注意。

    老叶茶馆
  • pt-osc在线重建表导致死锁的分析及对应的优化方案

    在业务低峰通过pt-osc在线做DDL期间出现死锁,导致业务的SQL被回滚了,对应用不友好。 本案例死锁发生的场景:pt-osc拷贝最后一个chunk-siz...

    老叶茶馆
  • MySQL中RR模式下死锁一例

    一、案例模拟二、死锁分析三、关于锁模式的变化四、关于LOCK_ORDINARY[next_key_lock]来历最后

    老叶茶馆
  • SAP S/4HANA Customer Management里的页面搜索结果的分页显示原理

    You might also be interested with this blog Search Paging implementation in S/4H...

    Jerry Wang
  • 干货 | 运筹学、数学规划、离散优化求解器大PK,总有一款适合你

    CPLEX 是IBM公司的一个优化引擎。软件IBM ILOG CPLEX Optimization Studio中自带该优化引擎。该软件具有执行速度快、其自带的...

    用户1621951
  • 在多线程构建场景下Powermockito无法在不同类中Mock同一个静态方法

    在修改单元测试的过程中,不幸踩了个坑,发现 Powermockito 的PowerMock.mockStatic(ClassThatContainsStatic...

    Allen Cheng
  • C#实现文件数据库

    本文为 Dennis Gao 原创技术文章,发表于博客园博客,未经作者本人允许禁止任何形式的转载。

    跟着阿笨一起玩NET
  • C#实现文件数据库

    本文转载:http://www.cnblogs.com/gaochundong/archive/2013/04/24/csharp_file_database....

    跟着阿笨一起玩NET
  • Asp.net Dynamic Data之三改变编辑和操作数据的现实方式

    Asp.net Dynamic Data之三改变编辑和操作数据的现实方式 本专题介绍如何运用RouteCollection 添加或是修改Routing URL...

    阿新
  • php_curl.dll libssh2.dll 始终无法加载的原因 及解决办法

    在StackOverflow得到最终原因及解决办法 http://stackoverflow.com/questions/16424117/php-unable...

    庞小明

扫码关注云+社区

领取腾讯云代金券