Shulou(Shulou.com)06/01 Report--

1. ALGORITHM=INSTANT algorithm is supported for DROP COLUMN deleted fields.

Example: alter table T1 drop column name,ALGORITHM=INSTANT

This algorithm is not supported in MySQL version 8.0.17

2. Support changing character set utf8- > utf8mb4 conversion using ALGORITHM=INSTANT algorithm

Example: alter table T1 change name name varchar (100) CHARSET utf8mb4,ALGORITHM=INSTANT

This algorithm is not supported in MySQL version 8.0.17

3. Add authentication plug-in-Unix Socket

The unix_socket authentication plug-in allows users to use the operating system's credentials when connecting to MariaDB through a local Unix socket file.

Usage:

1. Create a database account hechunyang

MariaDB [(none)] > GRANT ALL ON *. * TO 'hechunyang' IDENTIFIED VIA

Unix_socket

Query OK, 0 rows affected (0.001 sec)

2. Create an operating system account hechunyang

# useradd hechunyang

# passwd hechunyang

Log in to the operating system as a hechunyang user

3. Log in to MariaDB

[root@localhost ~] # su-hechunyang

Last login: Wed Jul 31 14:18:17 CST 2019 on pts/2

[hechunyang@localhost ~] $

[hechunyang@localhost] $mysql-S / tmp/mysql3306.sock-uhechunyang

Welcome to the MariaDB monitor. Commands end with; or\ g.

Your MariaDB connection id is 45

Server version: 10.4.6-MariaDB-log MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

MariaDB [(none)] > show databases

+-+

| | Database |

+-+

| | information_schema |

| | test |

+-+

2 rows in set (0.001 sec)

In this example, user hechunyang is logged into the operating system and has full shell access. He has authenticated using the operating system, and his MariaDB account has been configured to use the unix_socket authentication plug-in, so he does not need to authenticate the database again. MariaDB accepts his operating system credentials and allows him to connect.

4. The mysqladmin shutdown command adds the-- wait-for-all-slaves parameter, which means waiting for the last binlog event to be sent to all connected Slave slave libraries before shutting down the mysqld process.

Example: MariaDB [(none)] > SHUTDOWN WAIT FOR ALL SLAVES

Query OK, 0 rows affected (0.000 sec)

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.