MySQL 9.0.0 新鲜出炉！支持向量类型

MySQL 9.0.0 创新版本已经可以下载了。不过rel notes尚未更新。

感兴趣的同学可以耍起来了。

下载解压后：

[root@centos7 ~]# ll mysql*
-rw-r--r--. 1 root root 1082245120 Jul 1 21:45 mysql-9.0.0-1.el7.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 15319952 Jun 9 22:19 mysql-community-client-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 3628244 Jun 9 22:20 mysql-community-client-plugins-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 709728 Jun 9 22:20 mysql-community-common-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 595193592 Jun 9 22:20 mysql-community-debuginfo-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 2023956 Jun 9 22:20 mysql-community-devel-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 4218992 Jun 9 22:20 mysql-community-embedded-compat-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 2346260 Jun 9 22:20 mysql-community-icu-data-files-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 1592152 Jun 9 22:20 mysql-community-libs-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 687200 Jun 9 22:20 mysql-community-libs-compat-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 63851536 Jun 9 22:21 mysql-community-server-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 26559052 Jun 9 22:21 mysql-community-server-debug-9.0.0-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 366102536 Jun 9 22:22 mysql-community-test-9.0.0-1.el7.x86_64.rpm


YUM安装：

安装完成：

Installed:
mysql-community-client.x86_64 0:9.0.0-1.el7 mysql-community-client-plugins.x86_64 0:9.0.0-1.el7
mysql-community-common.x86_64 0:9.0.0-1.el7 mysql-community-debuginfo.x86_64 0:9.0.0-1.el7
mysql-community-devel.x86_64 0:9.0.0-1.el7 mysql-community-embedded-compat.x86_64 0:9.0.0-1.el7
mysql-community-icu-data-files.x86_64 0:9.0.0-1.el7 mysql-community-libs.x86_64 0:9.0.0-1.el7
mysql-community-libs-compat.x86_64 0:9.0.0-1.el7 mysql-community-server.x86_64 0:9.0.0-1.el7
mysql-community-server-debug.x86_64 0:9.0.0-1.el7 mysql-community-test.x86_64 0:9.0.0-1.el7

Complete!
[root@centos7 ~]#


启动mysqld服务

[root@centos7 ~]# systemctl start mysqld
[root@centos7 ~]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2024-07-01 22:00:35 CST; 18s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 62400 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 62477 (mysqld)
Status: "Server is operational"
Tasks: 35
CGroup: /system.slice/mysqld.service
└─62477 /usr/sbin/mysqld

Jul 01 22:00:22 centos7.shawnyan.cn systemd[1]: Starting MySQL Server...
Jul 01 22:00:35 centos7.shawnyan.cn systemd[1]: Started MySQL Server.


查看日志，获取初始密码：

[root@centos7 ~]# tailf /var/log/mysqld.log
2024-07-01T14:00:24.713911Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-07-01T14:00:24.719696Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.0) initializing of server in progress as process 62435
2024-07-01T14:00:24.739529Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-01T14:00:25.676442Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-01T14:00:27.780001Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: U*T-kvd/J5lp
2024-07-01T14:00:30.609639Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2024-07-01T14:00:31.133904Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-01T14:00:32.129157Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.0) starting as process 62477
2024-07-01T14:00:32.179505Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-01T14:00:34.216355Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-01T14:00:35.236477Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-01T14:00:35.236581Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-01T14:00:35.312522Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.0.0' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2024-07-01T14:00:35.312550Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock


连接数据库重置密码，再次连接，查看版本信息。

[root@centos7 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 9.0.0 MySQL Community Server - GPL

mysql> select version();
+-----------+
| version() |
+-----------+
| 9.0.0 |
+-----------+
1 row in set (0.00 sec)


据陈臣大佬说，已经支持向量数据类型，测试一下果真。

mysql> create table tv (id int, v vector);
Query OK, 0 rows affected (0.01 sec)

mysql> show create table tv\G
*************************** 1. row ***************************
Table: tv
Create Table: CREATE TABLE `tv` (
`id` int DEFAULT NULL,
`v` vector(2048) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.00 sec)


接下来写入2条测试数据。

mysql> insert tv select 1,to_vector('[1,2]');
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> insert tv select 2,to_vector('[2,3]');
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0


查看表数据，直接查看有些难懂，转换一下就好了。

mysql> table tv;
+------+--------------------+
| id | v |
+------+--------------------+
| 1 | 0x0000803F00000040 |
| 2 | 0x0000004000004040 |
+------+--------------------+
2 rows in set (0.00 sec)

mysql> select id,from_vector(v) from tv;
+------+---------------------------+
| id | from_vector(v) |
+------+---------------------------+
| 1 | [1.00000e+00,2.00000e+00] |
| 2 | [2.00000e+00,3.00000e+00] |
+------+---------------------------+
2 rows in set (0.00 sec)


查看向量的维度，用到函数 VECTOR_DIM

mysql> insert tv select 3,to_vector('[1,2,3]');
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> select id,VECTOR_DIM(v) from tv;
+------+---------------+
| id | VECTOR_DIM(v) |
+------+---------------+
| 1 | 2 |
| 2 | 2 |
| 3 | 3 |
+------+---------------+
3 rows in set (0.00 sec)


OK, 先到这里，让我们一起等待9.0文档上线吧。

🌻 往期精彩 ▼

[Oracle]

• Oracle 数据库全面升级为 23ai
• python-oracledb 已率先支持 Oracle 23ai
• 一文带你了解 Oracle 23ai 新特性 Vector 的基础用法

[MySQL]

• 「合集」MySQL 8.x 系列文章汇总
• 如何选择适合的 MySQL Connector/J 版本
• MySQL 8.4.0 LTS 发布 (MySQL 第一个长期支持版本)

[TiDB]

• 星辰考古：TiDB v3.x 忆水木
• 星辰考古：TiDB v2.x 回忆杀
• 敢于公布BUG的国产数据库才是好数据库

[PG]

• [RL9] Rocky Linux 9.4 搭载 PG 16.1
• 即将告别PG 12，建议升级到PG 16.3版本
• 后 EL 7 时代，PG 16 如何在 CentOS 7 上运行

– / END / –

👉 这里可以找到我

• 微信公众号：少安事务所 (mysqloffice)
• 墨天轮：严少安
• PGFans: 严少安
• ITPUB：少安事务所
• TiDB 专栏：@ShawnYan

如果这篇文章为你带来了灵感或启发，就请帮忙点『赞』or『在看』or『转发』吧，感谢！ღ( ´･ᴗ･` )~