当前位置：首页 > news >正文

如何获得一个Oracle 23c免费开发者版

news 2025/12/22 21:04:41

获取23c开发者版

简单介绍可参考这里。

获取数据库可以参考这篇文章Introducing Oracle Database 23c Free – Developer Release或这里。

Docker Image

这是最快的方法。在OCI上创建一个计算实例，然后就可以拉取image使用了。

docker的安装和配置不赘述了。

拉取image：

$ docker pull container-registry.oracle.com/database/free
Using default tag: latest
Trying to pull repository container-registry.oracle.com/database/free ...
latest: Pulling from container-registry.oracle.com/database/free
031aed3cb40e: Pull complete
064e6354b87b: Pull complete
e0e26966d0d9: Pull complete
0d1f063a4da2: Pull complete
Digest: sha256:474f570148ef37d1152ccff3361109fb8b92e0eab523cef32efe273e5abcbb94
Status: Downloaded newer image for container-registry.oracle.com/database/free:latest
container-registry.oracle.com/database/free:latest

image大约11G：

$ docker images
REPOSITORY                                    TAG                 IMAGE ID            CREATED             SIZE
container-registry.oracle.com/database/free   latest              d45af382bf76        5 weeks ago         10.6GB

然后启动数据库，第一次时间长点，但感觉比企业版要快很多：

$ docker run container-registry.oracle.com/database/free:latest
Starting Oracle Net Listener.
Oracle Net Listener started.
Starting Oracle Database instance FREE.
Oracle Database instance FREE started.The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:
PDB$SEED(2):Opening pdb with Resource Manager plan: DEFAULT_PLAN
FREEPDB1(3):SUPLOG: Initialize PDB SUPLOG SGA, old value 0x0, new value 0x18
FREEPDB1(3):Autotune of undo retention is turned on.
FREEPDB1(3):Undo initialization recovery: Parallel FPTR failed: start:245860668 end:245860669 diff:1 ms (0.0 seconds)
FREEPDB1(3):[162] Successfully onlined Undo Tablespace 2.
FREEPDB1(3):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x18, new 0x0 (no suplog)
2023-09-08T09:00:33.615993+00:00
FREEPDB1(3):Opening pdb with Resource Manager plan: DEFAULT_PLAN
Completed: Pluggable database FREEPDB1 opened read write
Completed: ALTER DATABASE OPEN
2023-09-08T09:00:34.918003+00:00
===========================================================
Dumping current patch information
===========================================================
No patches have been applied
===========================================================

正式启动一次：

$ docker run -d --name ORCLCDB container-registry.oracle.com/database/free:latest
8c8facd08dc24261c2b2092ff9ecb2a41189303eaa059e1d2a1034226a6da1db$ docker ps
CONTAINER ID        IMAGE                                                COMMAND                  CREATED             STATUS                             PORTS               NAMES
8c8facd08dc2        container-registry.oracle.com/database/free:latest   "/bin/bash -c $ORACL…"   35 seconds ago      Up 34 seconds (health: starting)   1521/tcp            ORCLCDB$ docker ps
CONTAINER ID        IMAGE                                                COMMAND                  CREATED              STATUS                        PORTS               NAMES
8c8facd08dc2        container-registry.oracle.com/database/free:latest   "/bin/bash -c $ORACL…"   About a minute ago   Up About a minute (healthy)   1521/tcp            ORCLCDB

这一次启动只需不到1分钟：

2023-09-08T09:04:05.032218930Z Starting Oracle Net Listener.
2023-09-08T09:04:05.176991996Z Oracle Net Listener started.
2023-09-08T09:04:05.177014108Z Starting Oracle Database instance FREE.
2023-09-08T09:04:40.229143588Z Oracle Database instance FREE started.
2023-09-08T09:04:40.229164627Z
2023-09-08T09:04:40.273314674Z The Oracle base remains unchanged with value /opt/oracle
2023-09-08T09:04:40.458092335Z #########################
2023-09-08T09:04:40.458114517Z DATABASE IS READY TO USE!
2023-09-08T09:04:40.458119405Z #########################

登录数据库：

$ docker exec -it ORCLCDB sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - Developer-Release on Fri Sep 8 09:09:14 2023
Version 23.2.0.0.0Copyright (c) 1982, 2023, Oracle.  All rights reserved.Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0SQL> show pdbsCON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED                       READ ONLY  NO3 FREEPDB1                       READ WRITE NO
SQL> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

Vagrant Box

如果要离线用，Vagrant Box是一个不错的选择。

简介看这里。

和其它版本的Oracle不同，开发者版不需要预先下载安装介质，其实也没得可下。因此网速就很重要。

安装日志如下：

$ vagrant up
Bringing machine 'oracle23c-free-vagrant' up with 'virtualbox' provider...
==> oracle23c-free-vagrant: Importing base box 'oraclelinux/8'...
==> oracle23c-free-vagrant: Matching MAC address for NAT networking...
==> oracle23c-free-vagrant: Checking if box 'oraclelinux/8' version '8.8.485' is up to date...
==> oracle23c-free-vagrant: Setting the name of the VM: oracle23c-free-vagrant
==> oracle23c-free-vagrant: Clearing any previously set network interfaces...
==> oracle23c-free-vagrant: Preparing network interfaces based on configuration...oracle23c-free-vagrant: Adapter 1: nat
==> oracle23c-free-vagrant: Forwarding ports...oracle23c-free-vagrant: 1522 (guest) => 1522 (host) (adapter 1)oracle23c-free-vagrant: 22 (guest) => 2222 (host) (adapter 1)
==> oracle23c-free-vagrant: Running 'pre-boot' VM customizations...
==> oracle23c-free-vagrant: Booting VM...
==> oracle23c-free-vagrant: Waiting for machine to boot. This may take a few minutes...oracle23c-free-vagrant: SSH address: 127.0.0.1:2222oracle23c-free-vagrant: SSH username: vagrantoracle23c-free-vagrant: SSH auth method: private keyoracle23c-free-vagrant:oracle23c-free-vagrant: Vagrant insecure key detected. Vagrant will automatically replaceoracle23c-free-vagrant: this with a newly generated keypair for better security.
...
==> oracle23c-free-vagrant: Machine booted and ready!
==> oracle23c-free-vagrant: Checking for guest additions in VM...
==> oracle23c-free-vagrant: Setting hostname...
==> oracle23c-free-vagrant: Mounting shared folders...
...oracle23c-free-vagrant: INSTALLER: Started uporacle23c-free-vagrant: Oracle Linux 8 BaseOS Latest (x86_64)           9.1 MB/s |  62 MB     00:06oracle23c-free-vagrant: Oracle Linux 8 Application Stream (x86_64)       10 MB/s |  48 MB     00:04oracle23c-free-vagrant: Latest Unbreakable Enterprise Kernel Release 7  7.5 MB/s |  19 MB     00:02oracle23c-free-vagrant: Last metadata expiration check: 0:00:04 ago on Fri 08 Sep 2023 09:26:17 AM UTC.oracle23c-free-vagrant: Dependencies resolved.oracle23c-free-vagrant: =========================================================================================================oracle23c-free-vagrant:  Package                    Arch    Version                                      Repository          Sizeoracle23c-free-vagrant: =========================================================================================================oracle23c-free-vagrant: Installing:oracle23c-free-vagrant:  kernel-uek-core            x86_64  5.15.0-104.119.4.2.el8uek                    ol8_UEKR7           54 Moracle23c-free-vagrant:  kernel-uek-devel           x86_64  5.15.0-104.119.4.2.el8uek                    ol8_UEKR7           20 Moracle23c-free-vagrant: Upgrading:oracle23c-free-vagrant:  NetworkManager             x86_64  1:1.40.16-4.0.1.el8_8                        ol8_baseos_latest  2.3 Moracle23c-free-vagrant:  NetworkManager-libnm       x86_64  1:1.40.16-4.0.1.el8_8                        ol8_baseos_latest  1.9 Moracle23c-free-vagrant:  binutils                   x86_64  2.30-119.0.2.el8                             ol8_baseos_latest  5.9 M
...oracle23c-free-vagrant: Downloading Packages:oracle23c-free-vagrant: (1/68): grub2-tools-efi-2.02-148.0.3.el8_8.1.x8 465 kB/s | 481 kB     00:01oracle23c-free-vagrant: (2/68): NetworkManager-1.40.16-4.0.1.el8_8.x86_ 2.3 MB/s | 2.3 MB     00:00oracle23c-free-vagrant: (3/68): NetworkManager-libnm-1.40.16-4.0.1.el8_ 6.1 MB/s | 1.9 MB     00:00oracle23c-free-vagrant: (4/68): binutils-2.30-119.0.2.el8.x86_64.rpm    4.0 MB/s | 5.9 MB     00:01oracle23c-free-vagrant: (5/68): kernel-uek-devel-5.15.0-104.119.4.2.el8 4.7 MB/s |  20 MB     00:04
...oracle23c-free-vagrant: Complete!oracle23c-free-vagrant: INSTALLER: System updated
...oracle23c-free-vagrant: Installed:oracle23c-free-vagrant:   oraclelinux-developer-release-el8-1.0-7.el8.x86_64oracle23c-free-vagrant:oracle23c-free-vagrant: Complete!
...oracle23c-free-vagrant: Complete!oracle23c-free-vagrant: INSTALLER: Oracle preinstall and openssl completeoracle23c-free-vagrant: INSTALLER: Environment variables setoracle23c-free-vagrant: INSTALLER: Downloading Oracle Database softwareoracle23c-free-vagrant: Last metadata expiration check: 0:03:36 ago on Fri 08 Sep 2023 05:30:37 PM +08.oracle23c-free-vagrant: Dependencies resolved.oracle23c-free-vagrant: ================================================================================oracle23c-free-vagrant:  Package                       Arch        Version      Repository         Sizeoracle23c-free-vagrant: ================================================================================oracle23c-free-vagrant: Installing:oracle23c-free-vagrant:  oracle-database-free-23c      x86_64      1.0-1        @commandline      1.6 Goracle23c-free-vagrant:oracle23c-free-vagrant: Transaction Summaryoracle23c-free-vagrant: ================================================================================oracle23c-free-vagrant: Install  1 Packageoracle23c-free-vagrant:oracle23c-free-vagrant: Total size: 1.6 Goracle23c-free-vagrant: Installed size: 5.2 Goracle23c-free-vagrant: Downloading Packages:oracle23c-free-vagrant: Running transaction checkoracle23c-free-vagrant: Transaction check succeeded.oracle23c-free-vagrant: Running transaction testoracle23c-free-vagrant: Transaction test succeeded.oracle23c-free-vagrant: Running transactionoracle23c-free-vagrant:   Preparing        :                                                        1/1oracle23c-free-vagrant:   Running scriptlet: oracle-database-free-23c-1.0-1.x86_64                  1/1oracle23c-free-vagrant:   Installing       : oracle-database-free-23c-1.0-1.x86_64                  1/1oracle23c-free-vagrant:   Running scriptlet: oracle-database-free-23c-1.0-1.x86_64                  1/1oracle23c-free-vagrant: [INFO] Executing post installation scripts...oracle23c-free-vagrant: [INFO] Oracle home installed successfully and ready to be configured.oracle23c-free-vagrant: To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23c.conf' and then run '/etc/init.d/oracle-free-23c configure' as root.oracle23c-free-vagrant:oracle23c-free-vagrant:   Verifying        : oracle-database-free-23c-1.0-1.x86_64                  1/1oracle23c-free-vagrant:oracle23c-free-vagrant: Installed:oracle23c-free-vagrant:   oracle-database-free-23c-1.0-1.x86_64oracle23c-free-vagrant:oracle23c-free-vagrant: Complete!oracle23c-free-vagrant: INSTALLER: Oracle software installedoracle23c-free-vagrant: Configuring Oracle Listener.oracle23c-free-vagrant: Listener configuration succeeded.oracle23c-free-vagrant: Configuring Oracle Database FREE.oracle23c-free-vagrant: Enter SYS user password:oracle23c-free-vagrant: ***************oracle23c-free-vagrant: Enter SYSTEM user password:oracle23c-free-vagrant: **************oracle23c-free-vagrant: Enter PDBADMIN User Password:oracle23c-free-vagrant: ***************oracle23c-free-vagrant: Prepare for db operationoracle23c-free-vagrant: 7% completeoracle23c-free-vagrant: Copying database filesoracle23c-free-vagrant: 29% completeoracle23c-free-vagrant: Creating and starting Oracle instanceoracle23c-free-vagrant: 30% completeoracle23c-free-vagrant: 33% completeoracle23c-free-vagrant: 36% completeoracle23c-free-vagrant: 39% completeoracle23c-free-vagrant: 43% completeoracle23c-free-vagrant: Completing Database Creationoracle23c-free-vagrant: 47% completeoracle23c-free-vagrant: 49% completeoracle23c-free-vagrant: 50% completeoracle23c-free-vagrant: Creating Pluggable Databasesoracle23c-free-vagrant: 54% completeoracle23c-free-vagrant: 71% completeoracle23c-free-vagrant: Executing Post Configuration Actionsoracle23c-free-vagrant: 93% completeoracle23c-free-vagrant: Running Custom Scriptsoracle23c-free-vagrant: 100% completeoracle23c-free-vagrant: Database creation complete. For details check the logfiles at:oracle23c-free-vagrant:  /opt/oracle/cfgtoollogs/dbca/FREE.oracle23c-free-vagrant: Database Information:oracle23c-free-vagrant: Global Database Name:FREEoracle23c-free-vagrant: System Identifier(SID):FREEoracle23c-free-vagrant: Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.oracle23c-free-vagrant:oracle23c-free-vagrant: Connect to Oracle Database using one of the connect strings:oracle23c-free-vagrant:      Pluggable database: localhost.localdomain:1522/FREEPDB1oracle23c-free-vagrant:      Multitenant container database: localhost.localdomain:1522oracle23c-free-vagrant: INSTALLER: Database createdoracle23c-free-vagrant: oracle-free-23c.service is not a native service, redirecting to systemd-sysv-install.oracle23c-free-vagrant: Executing: /usr/lib/systemd/systemd-sysv-install enable oracle-free-23coracle23c-free-vagrant: INSTALLER: Created and enabled oracle-free-23c systemd serviceoracle23c-free-vagrant: INSTALLER: setPassword.sh file set uporacle23c-free-vagrant: INSTALLER: Running user-defined post-setup scriptsoracle23c-free-vagrant: INSTALLER: Done running user-defined post-setup scriptsoracle23c-free-vagrant: ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: uqNAuvC8dPI=1oracle23c-free-vagrant: INSTALLER: Installation complete, database ready to use!

耗时半小时：

real    29m36.329s
user    0m0.015s
sys     0m0.016s

初始安装11.1GB，比企业版小一些。

留个影：
在这里插入图片描述

登录正常：

[oracle@localhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - Developer-Release on Fri Sep 8 17:57:12 2023
Version 23.2.0.0.0Copyright (c) 1982, 2023, Oracle.  All rights reserved.Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0SQL> show pdbsCON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED                       READ ONLY  NO3 FREEPDB1                       READ WRITE NO
SQL> exit
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

VM Image

需要安装Virtual Box，其实上一个Vagrant Box也是需要的。下载页面见这里。

大小约7G，因为是图形界面的，可能会比Vagrant Box要慢一点点。

如何获得一个Oracle 23c免费开发者版

获取23c开发者版简单介绍可参考这里。获取数据库可以参考这篇文章Introducing Oracle Database 23c Free – Developer Release或这里。 Docker Image 这是最快的方法。在OCI上创建一个计算实例，然后就可以拉取image使用了。 docker的安装和配置不赘述了。 …...

编程日记 2023/9/12 5:11:27

机器学习策略二——优化深度学习系统

进行误差分析 (Carrying out error analysis) 如果你希望让学习算法能够胜任人类能做的任务，但你的学习算法还没有达到人类的表现，那么人工检查一下你的算法犯的错误也许可以让你了解接下来应该做什么。这个过程称为错误分析。假设你正在调试猫分类器…...

编程日记 2023/9/12 5:10:26

Pytorch Advanced(三) Neural Style Transfer

神经风格迁移在之前的博客中已经用keras实现过了，比较复杂，keras版本。这里用pytorch重新实现一次，原理图如下： from __future__ import division from torchvision import models from torchvision import transforms from PIL…...

编程日记 2023/9/12 5:08:24

英飞凌TC3xx--深度手撕HSM安全启动(三)--TC3xx HSM系统架构

今天聊TC3xx HSM系统，包括所用内核、UCB相关信息、Host和HSM交互方式。 1、HSM系统架构下图来源于英飞凌官网培训材料。 TC3xx的HSM内核是一颗32位的ARM Cortex M3，主频可达100MHz，支持对称算法AES128、非对称算法PKC(Public Key Crypto) ECC256、Hash SHA2，以及T…...

编程日记 2023/9/12 5:07:23

黑马JVM总结（五）

（1）方法区它是所有java虚拟机线程共享的区，存储着跟类的结构相关的信息，类的成员变量，方法数据，成员方法，构造器方法，特殊方法（类的构造器） 方法区在虚拟机…...

编程日记 2023/9/12 5:06:22

C语言入门Day_18 判断和循坏的小结

目录前言： 1.判断 2.循环 3.课堂笔记 4.思维导图前言： 判断语句和循环语句都可以大致分为三个部分，第一个部分是固定的语法格式；第二部分是代码的执行顺序，第三部分是判断和循环成立与否的判断条件。 1.判断 1…...

编程日记 2023/9/12 5:05:21

mac 好用的工具推荐

mac 好用的工具推荐落雪：全网的音乐畅听，下载地址：https://github.com/lyswhut/lx-music-desktopMotrix: 免费下载工具，下载地址：https://xclient.info/s/motrix.html#versionsDownie：视频下载工具&#x…...

编程日记 2023/9/12 5:04:19

星际争霸之小霸王之小蜜蜂（十二）--猫有九条命

系列文章目录星际争霸之小霸王之小蜜蜂（十一）--杀杀杀星际争霸之小霸王之小蜜蜂（十）--鼠道星际争霸之小霸王之小蜜蜂（九）--狂鼠之灾星际争霸之小霸王之小蜜蜂（八）--蓝皮鼠和大…...

编程日记 2023/9/12 5:03:19

【软件分析/静态分析】chapter8 课程11/12 指针分析—上下文敏感（Pointer Analysis - Context Sensitivity）

🔗 课程链接：李樾老师和谭天老师的： 南京大学《软件分析》课程11（Pointer Analysis - Context Sensitivity I）_哔哩哔哩_bilibili 南京大学《软件分析》课程12（Pointer Analysis - Context Sensitivity II&…...

编程日记 2023/9/12 5:02:17

时间复杂度与空间复杂度详解

时间复杂度与空间复杂度详解🦖 一、算法效率1.1 如何衡量一个算法的好坏1.2 算法的复杂度二、时间复杂度2.1 时间复杂度的定义2.2 大O的渐进表示法2.3 如何记录表示算法复杂度三、空间复杂度3.1 空间复杂度的定义3.2 小试牛刀一、算法效率 1.1 如何衡量一个算法…...

编程日记 2023/9/12 5:01:15

目录操作函数

mkdir函数 rmdir函数删除空目录 rename函数换名 chdir函数修改当前的工作目录 getcwd函数获取当前工作的路径...

编程日记 2023/9/12 5:00:15

PlantUML入门教程：画时序图

软件工程中会用到各种UML图，例如用例图、时序图等。那我们能不能像写代码一样去画图呢？ 今天推荐一款软件工程师的作图利器--PlantUML，它能让你用写代码的方式快速画出UML图。一、什么是PlantUML？ PlantUML是一个允许你快速作出…...

编程日记 2023/9/12 4:59:14

C#范围运算符

C#8.0语法中，范围运算符是一种用于快速截取序列的运算符，其语法为 “start…end”，表示从序列的 “start” 索引处开始，一直截取到"end" 索引处为止（包括 “end” 索引处的元素）。范围运算符主要…...

编程日记 2023/9/12 4:58:13

云数据库知识学习——云数据库产品、云数据库系统架构

一、云数据库产品 1.1、云数据库厂商概述云数据库供应商主要分为三类。 ① 传统的数据库厂商，如 Teradata、Oracle、IBM DB2 和 Microsoft SQL Server 等。 ② 涉足数据库市场的云供应商，如 Amazon、Google、Yahoo!、阿里、百度、腾讯…...

编程日记 2023/9/12 4:57:10

C++中引用详解！

前言： 本文旨在讲解C中引用的相关操作，以及引用的一些注意事项！搬好小板凳，干货来了！ 引用的概念何谓引用呢？引用其实很容易理解，比如李华这个同学，他因为很调皮，所以…...

编程日记 2023/9/12 4:56:09

VUE3+TS项目无法找到模块“../version/version.js”的声明文件

问题描述在导入 ../version/version.js 文件时，提示无法找到模块解决方法将version.js改为version.ts可以正常导入注意，因为version.js是我自己写的模块，我可以直接该没有关系，但是如果是引入的其他的第三方包&#xff0c…...

编程日记 2023/9/12 4:55:05

数据结构-堆的实现及应用(堆排序和TOP-K问题)

数据结构-堆的实现及应用[堆排序和TOP-K问题] 一.堆的基本知识点1.知识点二.堆的实现1.堆的结构2.向上调整算法与堆的插入2.向下调整算法与堆的删除三.整体代码四.利用回调函数避免对向上和向下调整算法的修改1.向上调整算法的修改2.向下调整算法的修改3.插入元素和删除元素函…...

编程日记 2023/9/12 4:54:04

Spring 条件注解没生效？咋回事

条件注解相信各位小伙伴都用过，Spring 中的多环境配置 profile 底层就是通过条件注解来实现的，松哥在之前的 Spring 视频中也有和大家详细介绍过条件注解的使用，感兴趣的小伙伴戳这里：Spring源码应该怎么学？。从 Spr…...

编程日记 2023/9/12 4:53:01

class Solution { public:int numTrees(int n) {if (n0) {return 1;}vector<int> dp(n1, 0);dp[0] 1;dp[1] 0;for (int i 1; i < n; i) {for (int j 0; j < i; j) {dp[i] dp[j] * dp[i - 1 - j];}}return dp[n];} };...

编程日记 2023/9/12 4:52:00

Android Jetpack 中Hilt的使用

Hilt 是 Android 的依赖项注入库，可减少在项目中执行手动依赖项注入的样板代码。执行手动依赖项注入要求您手动构造每个类及其依赖项，并借助容器重复使用和管理依赖项。 Hilt 通过为项目中的每个 Android 类提供容器并自动管理其生命周期，…...

编程日记 2023/9/12 4:50:58

Docker 离线安装指南

参考文章 1、确认操作系统类型及内核版本 Docker依赖于Linux内核的一些特性，不同版本的Docker对内核版本有不同要求。例如，Docker 17.06及之后的版本通常需要Linux内核3.10及以上版本，Docker17.09及更高版本对应Linux内核4.9.x及更高版本。…...

编程新知 2025/12/22 10:49:27

多种风格导航菜单 HTML 实现（附源码）

下面我将为您展示 6 种不同风格的导航菜单实现，每种都包含完整 HTML、CSS 和 JavaScript 代码。 1. 简约水平导航栏 <!DOCTYPE html> <html lang"zh-CN"> <head><meta charset"UTF-8"><meta name"viewport&qu…...

编程新知 2025/12/17 14:12:41

Kafka入门-生产者

生产者生产者发送流程： 延迟时间为0ms时，也就意味着每当有数据就会直接发送异步发送API 异步发送和同步发送的不同在于：异步发送不需要等待结果，同步发送必须等待结果才能进行下一步发送。普通异步发送首先导入所需的k…...

编程新知 2025/12/19 0:25:02

MySQL JOIN 表过多的优化思路

当 MySQL 查询涉及大量表 JOIN 时，性能会显著下降。以下是优化思路和简易实现方法： 一、核心优化思路减少 JOIN 数量数据冗余：添加必要的冗余字段（如订单表直接存储用户名）合并表：将频繁关联的小表合并成…...

编程新知 2025/10/17 22:08:13

Caliper 配置文件解析：fisco-bcos.json

config.yaml 文件 config.yaml 是 Caliper 的主配置文件，通常包含以下内容： test:name: fisco-bcos-test # 测试名称description: Performance test of FISCO-BCOS # 测试描述workers:type: local # 工作进程类型number: 5 # 工作进程数量monitor:type: - docker- pro…...

编程新知 2025/10/24 15:14:02