Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What are the main new features of MySQL8.0

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what are the main new features of MySQL 8.0". In daily operation, I believe many people have doubts about what are the main new features of MySQL 8.0. I have consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts about "what are the main new features of MySQL 8.0"! Next, please follow the small series to learn together!

MySQL is the major release of Oracle MySQL platform, and the open source community is waiting for its official release.

The conference introduced many new features of MySQL 8.0. In addition to data dictionaries, CTEs and Windows features, it also covers:

Use utf8 (mb4) as the default character set for MySQL

21 language-specific case-insensitive collations (utf8)

hide index

descending index

Improved availability of UUID and IPV 6 operations

SQL role

SET PERIST Global variable value used to set persistence

Performance Schema, Data Lock Detection

Performance Schema to detect error messages

Improving the cost model by using histograms

There are also some new replication features in MySQL 8, click here to see.

Angular 4.1.0 officially released, adding support for TypeScript 2.2 and 2.3

This is the first minor release of Angular 4.0, check out Angular version number semantics and release schedule.

The new version adds support for TypeScript 2.2 and 2.3. This version of Angular was compiled and released using TypeScript 2.3, but rest assured that this does not affect TypeScript 2.1 support.

Angular 4.1 enables TypeScript's strictNullChecks feature. This means that you can turn on Strict NullChecks in your project, or you can choose not to use Strict NullChecks.

In addition to the above updates, this release also includes bug fixes. The details are as follows:

router: forwarding query parameters during ng1-> ng2 url synchronization (#16249) (2f97731), closes #16067

upgrade: Use correct attribute names for upgrade component bindings (#16128) (d1fb066), closes #8856

TensorFlow 1.1.0 Released, Adding Initial Version Installation Guides for Java, C and Go

The new version adds Java API support for Windows and initial installation guides for Java, C and Go. As well as the following updates:

Add Text Dashboard to TensorBoard

Add tf.spectral module. Move existing FFT operations to tf.spectral while retaining old positions (tf. *) the alias in

Add Keras 2 API

Add a new lightweight queue object- RecordInput

Docker images: TF images on gcr.io and Docker Hub upgraded to ubuntu 16.04

Add some useful features to TensorFlow Debugger(tfdbg)

Rust 1.17 Released, Mozilla's Programming Language

Overall, the main update to Rust 1.17.0 is a small improvement in the efficiency of writing code. For example, the lifecycle of 'static' is now assumed in statics and consts. When writing a const or static like this:

const NAME: &'static str = "Ferris";static NAME: &'static str = "Ferris";

Rust 1.17 will allow you to remove 'static' because there is only one life cycle that makes sense.

const NAME: &str = "Ferris";static NAME: &str = "Ferris";

In some cases, this can clear a lot of boilerplate code:

// oldconst NAMES: &'static [&'static str; 2] = &["Ferris", "Bors"];// newconst NAMES: &[2] = &["Ferris", "Bors"];Wine 2.0.1 stable release, with Ubuntu installation tutorial

This is the first release of the Wine 2.0 stable series. The updates are mainly bug fixes and general feature improvements, including crash fixes and performance tweaks for many games and applications, including the following:

Need For Speed

Magic: The Gathering Online 4.0

Venom Codename: Outbreak

ComicRack 0.9.x

Odallus The Dark Call

Git for Windows

Marvel Heroes 2015 launcher

DirectDraw games

UnrealEngine4 games

This updated version correctly detects GeForce GT 525M graphics cards and obtains AMD FIJI GPU information.

TypeScript 2.3 Released, Microsoft Script Programming Language

TypeScript is a free and open source programming language developed by Microsoft, a superset of JavaScript that can be compiled into pure JavaScript and run on any browser, any computer, and any operating system. 2.3 Includes the following new features:

Type checking in JavaScript files using// @ts-check and--checkJs

Support for language server plugins

Default Type Parameters

Support for generators and asynchronous generators

GitLab 9.1 brings new service desks, new Canary Deployments, and Burndown Charts

New deployment method- Canary Deployments. This feature allows you to deploy new code to a small portion of your project, giving you a chance to recover with minimal impact if an error occurs. If a problem is detected, it can also be quickly recovered, minimizing the impact on users.

The new Service Desk feature in GitLab 9.1 enables a growing user base to email teams for any feedback or support via a dedicated address for each project. These appear in the project as GitLab private questions. Comment on them to reply to the original email sender and create a new channel for integrated user feedback within GitLab. Because the service desk is built into GitLab, it eliminates the complexity and inefficiency of multiple tools and external integration, greatly reducing the cycle time from feedback to software updates.

The new version also comes with Protected Tags. Using Protected Tags makes it easier to control who can create or update tags. A similar approach can be used to protect branches, and it is now easy to control any project.

Other popular software updates:

Kotlin 1.1.2 Released, JVM-Based Programming Language

Rails 5.1 officially released, open source web application framework

Vue 2.3.0 officially released with new server-side rendering guidelines

Kali Linux 2017.1 released with a host of updates and features

Ubuntu 17.10 Daily Build ISO Release, Still Using Unity 7 Desktop Environment

OpenResty 1.11.2.3 Published, Web Application Server

Scala Native 0.2.0 released, compiling Scala code into native code

Apache FTP Server 1.1.1 Released, Pure Java FTP Server Software

Hamsters.js 4.1.0, Javascript Multithreading and Parallel Execution Library

Google Chrome for Android Update, Released 58 Official Version

GNOME 3.26 will redesign the GNOME Control Center

Ionic 3.1.0 Released, HTML5 Mobile App Framework

Nginx releases mainline version 1.13.0

IntelliJ IDEA 2017.1.2 Released

This week's open source project recommendation provides elastic cloud native application service grid open source project-Linkerd

Linkerd is an open source project that provides a resilient cloud-native application service mesh, with a transparent proxy at its core.

Linkerd (pronounced "linker-DEE") is a transparent service grid designed to make modern applications secure and reliable by transparently adding service discovery, Load Balancer, fault handling, instrumentation, and routing to all inter-service communications without intruding into the implementation of the application itself.

Linkerd is built on Netty and Finagle, a production-tested RPC framework used by high-traffic companies such as Twitter, Pinterest, Tumblr and PagerDuty. Linkerd is managed by the Cloud Native Computing Foundation (CNCF).

The following figure demonstrates how Linkerd is deployed as a service grid for application instances:

At this point, the study of "What are the main new features of MySQL 8.0" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report