Oracle Linux8 安裝 MySQL 8.4.3,搭建一主一從

文章目錄

  • 安裝依賴
  • 獲取安裝包
  • 解壓
  • 準備相關目錄
  • 設置配置文件
  • 啟動數據庫
  • 連接數據庫
  • socket 文件優化
  • 同樣方法準備 3307 數據庫實例
  • 設置配置文件
  • 啟動 3307 實例數據庫
  • 連接并查看 3307 數據庫實例
  • 基于 bin log 搭建主從模式

安裝依賴

yum install -y numactl libaio ncurses-compat-libs

獲取安裝包

[root@oracleLinux8 mysql]# ll /root/mysql-8.4.3-linux-glibc2.17-aarch64.tar.xz
-rw-r--r-- 1 root root 896423176 Apr 20 21:40 /root/mysql-8.4.3-linux-glibc2.17-aarch64.tar.xz

解壓

cd /root
tar xf mysql*xz -C /usr/local/
ln -s /usr/local/mysql-8.4.3-linux-glibc2.17-aarch64 /usr/local/mysql

準備相關目錄

cd /usr/local/mysql
mkdir -p 3306/{data,socket,error_log,slow_error_log,pid_log,file}
/usr/local/mysql/bin/mysqld --initialize --user=mysql  --datadir=/usr/local/mysql/3306/data2025-04-20T14:08:36.281629Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2025-04-20T14:08:36.283506Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.4.3) initializing of server in progress as process 2983
2025-04-20T14:08:36.296320Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
get_mempolicy: Function not implemented
2025-04-20T14:08:36.299476Z 1 [Warning] [MY-011873] [InnoDB] Failed to set NUMA memory policy to MPOL_INTERLEAVE: Function not implemented
get_mempolicy: Function not implemented
2025-04-20T14:08:36.299650Z 0 [Warning] [MY-011879] [InnoDB] Failed to set NUMA memory policy of buffer pool page frames with mbind(0xffff77d10000,137297920,MPOL_INTERLEAVE,...,...,MPOL_MF_MOVE) failed with Function not implemented
2025-04-20T14:08:36.303475Z 1 [Warning] [MY-011875] [InnoDB] Failed to set NUMA memory policy to MPOL_DEFAULT: Function not implemented
2025-04-20T14:08:36.564595Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-20T14:08:37.648592Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: !s:Cll=ey4Wz
2025-04-20T14:08:39.366449Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

設置配置文件

cat > /usr/local/mysql/3306/data/my.cnf <<"EOF"
[mysqld]
# Basic Settings
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/3306/data
socket = /usr/local/mysql/3306/socket/mysql.sock
pid-file = /usr/local/mysql/3306/pid_log/mysql.pid
secure_file_priv = /usr/local/mysql/3306/file
log-bin=mysql-bin
server_id=1
mysql_native_password=ON
innodb_flush_log_at_trx_commit=1
sync_binlog=1# Network
port = 3306
bind-address = 0.0.0.0# Logging
log_error = /usr/local/mysql/3306/error_log/mysql-error.log
slow_query_log = 1
slow_query_log_file = /usr/local/mysql/3306/slow_error_log/mysql-slow.log
long_query_time = 2# InnoDB Settings
innodb_buffer_pool_size = 128M
innodb_log_file_size = 64M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1# Security
skip-name-resolve
local-infile = 0# Performance
max_connections = 100
thread_cache_size = 8
table_open_cache = 1000[client]
socket = /usr/local/mysql/3306/socket/mysql.sock
port = 3306[mysql]
socket = /usr/local/mysql/3306/socket/mysql.sock
auto-rehash
EOF

啟動數據庫

touch /usr/local/mysql/3306/error_log/mysql-error.log
mkdir -p /usr/local/mysql/file
chown mysql:mysql -R /usr/local/mysql/
chown mysql:mysql -R /usr/local/mysql/3306/*/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/3306/data/my.cnf &[root@oracleLinux8 mysql]#  /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/3306/data/my.cnf &
[1] 5743
[root@oracleLinux8 mysql]# 2025-04-20T14:21:31.458910Z mysqld_safe Logging to '/usr/local/mysql/3306/error_log/mysql-error.log'.
2025-04-20T14:21:31.468890Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/3306/data[root@oracleLinux8 mysql]#
[root@oracleLinux8 mysql]# ps -ef |grep mysql
root        5743    2266  0 22:21 pts/1    00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/3306/data/my.cnf
mysql       6093    5743 11 22:21 pts/1    00:00:00 /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/3306/data/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/3306/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/3306/error_log/mysql-error.log --pid-file=/usr/local/mysql/3306/pid_log/mysql.pid --socket=/usr/local/mysql/3306/socket/mysql.sock --port=3306
root        6138    2266  0 22:21 pts/1    00:00:00 grep --color=auto mysql
[root@oracleLinux8 mysql]#
[root@oracleLinux8 mysql]#
[root@oracleLinux8 mysql]# ss -tunlp | grep mysql
tcp   LISTEN 0      100          0.0.0.0:3306       0.0.0.0:*    users:(("mysqld",pid=6093,fd=22))
tcp   LISTEN 0      70                 *:33060            *:*    users:(("mysqld",pid=6093,fd=18))

連接數據庫

/usr/local/mysql/bin/mysql -u root -p  -S /usr/local/mysql/3306/socket/mysql.sock
密碼在前面日志中有 !s:Cll=ey4Wzmysql> alter user user() identified by 'root';
Query OK, 0 rows affected (0.02 sec)mysql> select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

socket 文件優化

每次登錄, 輸入 socket 文件過長,比較麻煩

cat >> ~/.bash_profile <<"EOF"
export MYSQL_UNIX_PORT=/usr/local/mysql/3306/socket/mysql.sock
export PATH=/usr/local/mysql/bin:$PATH
EOF
. ~/.bash_profile再次登錄
[root@oracleLinux8 mysql]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.4.3 MySQL Community Server - GPLCopyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>查看狀態
[root@oracleLinux8 mysql]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.4.3 MySQL Community Server - GPLCopyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>  select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.02 sec)mysql> select version();
+-----------+
| version() |
+-----------+
| 8.4.3     |
+-----------+
1 row in set (0.00 sec)mysql> status;
--------------
mysql  Ver 8.4.3 for Linux on aarch64 (MySQL Community Server - GPL)Connection id:		13
Current database:
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.4.3 MySQL Community Server - GPL
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/usr/local/mysql/3306/socket/mysql.sock
Binary data as:		Hexadecimal
Uptime:			7 min 35 secThreads: 2  Questions: 21  Slow queries: 0  Opens: 130  Flush tables: 3  Open tables: 46  Queries per second avg: 0.046
--------------

同樣方法準備 3307 數據庫實例

mkdir -p 3307/{data,error_log,slow_error_log,socket,pid_log,file}
chown -R  mysql:mysql 3307[root@oracleLinux8 3307]# /usr/local/mysql/bin/mysqld --initialize --user=mysql  --datadir=/usr/local/mysql/3307/data
2025-04-20T14:52:26.584588Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2025-04-20T14:52:26.586051Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.4.3) initializing of server in progress as process 7278
2025-04-20T14:52:26.611537Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
get_mempolicy: Function not implemented
2025-04-20T14:52:26.615731Z 1 [Warning] [MY-011873] [InnoDB] Failed to set NUMA memory policy to MPOL_INTERLEAVE: Function not implemented
get_mempolicy: Function not implemented
2025-04-20T14:52:26.616091Z 0 [Warning] [MY-011879] [InnoDB] Failed to set NUMA memory policy of buffer pool page frames with mbind(0xffff67d10000,137297920,MPOL_INTERLEAVE,...,...,MPOL_MF_MOVE) failed with Function not implemented
2025-04-20T14:52:26.622379Z 1 [Warning] [MY-011875] [InnoDB] Failed to set NUMA memory policy to MPOL_DEFAULT: Function not implemented
2025-04-20T14:52:26.808322Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-20T14:52:28.185961Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: BwtrQvcy-0_q
2025-04-20T14:52:29.564978Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

設置配置文件

cat > /usr/local/mysql/3307/data/my.cnf <<"EOF"
[mysqld]
# Basic Settings
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/3307/data
socket = /usr/local/mysql/3307/socket/mysql.sock
pid-file = /usr/local/mysql/3307/pid_log/mysql.pid
secure_file_priv = /usr/local/mysql/3307/file
log-bin=mysql-bin
server_id=2
mysql_native_password=ON
innodb_flush_log_at_trx_commit=1
sync_binlog=1# Network
port = 3307
bind-address = 0.0.0.0# 調整X插件配置（避免端口和socket沖突）
mysqlx_port = 33070
mysqlx_socket = /tmp/mysqlx3307.sock# Logging
log_error = /usr/local/mysql/3307/error_log/mysql-error.log
slow_query_log = 1
slow_query_log_file = /usr/local/mysql/3307/slow_error_log/mysql-slow.log
long_query_time = 2# InnoDB Settings
innodb_buffer_pool_size = 128M
innodb_log_file_size = 64M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 1# Security
skip-name-resolve
local-infile = 0# Performance
max_connections = 100
thread_cache_size = 8
table_open_cache = 1000[client]
socket = /usr/local/mysql/3307/socket/mysql.sock
port = 3307[mysql]
socket = /usr/local/mysql/3307/socket/mysql.sock
auto-rehash
EOF

主要修改 server_id 與如下兩個配置
mysqlx_port = 33070
mysqlx_socket = /tmp/mysqlx3307.sock

啟動 3307 實例數據庫

[root@oracleLinux8 3307]# /usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/3307/data/my.cnf &
2025-04-20T14:56:00.541265Z mysqld_safe Logging to '/usr/local/mysql/3307/error_log/mysql-error.log'.
2025-04-20T14:56:00.551499Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/3307/data[root@oracleLinux8 3307]# ss -tunlp |grep mysql
tcp   LISTEN 0      100          0.0.0.0:3306       0.0.0.0:*    users:(("mysqld",pid=6093,fd=22))
tcp   LISTEN 0      100          0.0.0.0:3307       0.0.0.0:*    users:(("mysqld",pid=7700,fd=22))
tcp   LISTEN 0      70                 *:33060            *:*    users:(("mysqld",pid=6093,fd=18))
tcp   LISTEN 0      70                 *:33070            *:*    users:(("mysqld",pid=7700,fd=18))

連接并查看 3307 數據庫實例

密碼在之前初始化的打印中

[root@oracleLinux8 3307]# mysql -p -S /usr/local/mysql/3307/socket/mysql.sock
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.4.3Copyright (c) 2000, 2024, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> select version();
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user user() identified by 'root';
Query OK, 0 rows affected (0.05 sec)mysql> select version();
+-----------+
| version() |
+-----------+
| 8.4.3     |
+-----------+
1 row in set (0.00 sec)mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)mysql> select user,host from mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)mysql> status;
--------------
mysql  Ver 8.4.3 for Linux on aarch64 (MySQL Community Server - GPL)Connection id:		11
Current database:
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.4.3
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/usr/local/mysql/3307/socket/mysql.sock
Binary data as:		Hexadecimal
Uptime:			4 min 20 secThreads: 2  Questions: 11  Slow queries: 0  Opens: 130  Flush tables: 3  Open tables: 46  Queries per second avg: 0.042
--------------

基于 bin log 搭建主從模式

規劃: 3306 是主庫; 3307 實例是從庫

  • 主庫
create USER 'repuser'@'%' IDENTIFIED WITH mysql_native_password BY 'repuser' ;
GRANT REPLICATION SLAVE ON *.* TO 'repuser'@'%';
FLUSH PRIVILEGES;SHOW BINARY LOG STATUS
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000008 |      443 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
  • 從庫
stop replica;
change replication source to source_host='127.0.0.1', source_port=3306, source_user='repuser', source_password='repuser', source_log_file='mysql-bin.000008', source_log_pos=443;
show replica status\G第一次報錯如下:Last_IO_Errno: 2061Last_IO_Error: Error connecting to source 'repuser@127.0.0.1:3306'. This was attempt 6/10, with a delay of 60 seconds between attempts. Message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.然后在主庫與從庫配置文件的 mysqld 中 , 都啟用了 mysql_native_password=on, 然后重啟了數據庫服務
然后同步狀態正常如下;
mysql> show replica status\G
*************************** 1. row ***************************Replica_IO_State: Waiting for source to send eventSource_Host: 127.0.0.1Source_User: repuserSource_Port: 3306Connect_Retry: 60Source_Log_File: mysql-bin.000009Read_Source_Log_Pos: 158Relay_Log_File: oracleLinux8-relay-bin.000002Relay_Log_Pos: 328Relay_Source_Log_File: mysql-bin.000009Replica_IO_Running: YesReplica_SQL_Running: YesReplicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno: 0Last_Error:Skip_Counter: 0Exec_Source_Log_Pos: 158Relay_Log_Space: 546Until_Condition: NoneUntil_Log_File:Until_Log_Pos: 0Source_SSL_Allowed: NoSource_SSL_CA_File:Source_SSL_CA_Path:Source_SSL_Cert:Source_SSL_Cipher:Source_SSL_Key:Seconds_Behind_Source: 0
Source_SSL_Verify_Server_Cert: NoLast_IO_Errno: 0Last_IO_Error:Last_SQL_Errno: 0Last_SQL_Error:Replicate_Ignore_Server_Ids:Source_Server_Id: 1Source_UUID: f37cc1a2-1df0-11f0-a107-92faf2fcb2f7Source_Info_File: mysql.slave_master_infoSQL_Delay: 0SQL_Remaining_Delay: NULLReplica_SQL_Running_State: Replica has read all relay log; waiting for more updatesSource_Retry_Count: 10Source_Bind:Last_IO_Error_Timestamp:Last_SQL_Error_Timestamp:Source_SSL_Crl:Source_SSL_Crlpath:Retrieved_Gtid_Set:Executed_Gtid_Set:Auto_Position: 0Replicate_Rewrite_DB:Channel_Name:Source_TLS_Version:Source_public_key_path:Get_Source_public_key: 0Network_Namespace:
1 row in set (0.00 sec)-- 主庫
mysql>  create database test2;
mysql> use test2;
Database changed
mysql> show tables;
Empty set (0.00 sec)mysql> create table test(id int );
Query OK, 0 rows affected (0.06 sec)mysql> insert into test values(1),(2);
Query OK, 2 rows affected (0.02 sec)
Records: 2  Duplicates: 0  Warnings: 0-- 從庫
mysql> use test2;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_test2 |
+-----------------+
| test            |
+-----------------+
1 row in set (0.00 sec)mysql> select * from test;
+------+
| id   |
+------+
|    1 |
|    2 |
+------+
2 rows in set (0.00 sec)mysql>

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/diannao/80009.shtml
繁體地址，請注明出處：http://hk.pswp.cn/diannao/80009.shtml
英文地址，請注明出處：http://en.pswp.cn/diannao/80009.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

Dataway在Spring Boot中的引入以及使用教程

Dataway在Spring Boot中的引入以及使用教程

Dataway是Hasor生態中的接口配置工具&#xff0c;能幫助開發者快速配置數據接口。它支持DataQL和SQL兩種語言模式&#xff0c;可將SQL轉換為DataQL執行&#xff0c;簡化數據查詢與交互&#xff0c;無需編寫大量代碼。接口配置完成后&#xff0c;可進行自測、冒煙測試&#xff0…
閱讀更多...
進程互斥的軟件實現方法

進程互斥的軟件實現方法

單標志法 算法思想&#xff1a;兩個進程在訪問完臨界區后會把使用臨界區的權限轉交給另一個進程。也就是說每個進程進入臨界區的權限只能被另一個進程賦予 int turn 0; //turn 表示當前允許進入臨界區的進程號P0 進程&#xff1a; while (turn ! 0); ① //進入區 critical …
閱讀更多...
力扣150題-- 匯總區間和合并區間

力扣150題-- 匯總區間和合并區間

Day 27 題目描述 思路 做法&#xff1a; 特殊處理空數組和數組只有一個元素的情況設置beg&#xff0c;end標記范圍的起始和結束&#xff0c;x用來比較元素是否有序&#xff08;初始end和beg都指向nums[0[,x為nums[0]1&#xff09;遍歷數組如果當前元素等于x&#xff0c;說明…
閱讀更多...
【c++深入系列】：萬字string詳解（附有sso優化版本的string模擬實現源碼）

【c++深入系列】：萬字string詳解（附有sso優化版本的string模擬實現源碼）

&#x1f525; 本文專欄&#xff1a;c &#x1f338;作者主頁&#xff1a;努力努力再努力wz &#x1f4aa; 今日博客勵志語錄&#xff1a; 當你想放棄時&#xff0c;想想為什么當初堅持走到了這里 ★★★ 本文前置知識&#xff1a; 類和對象&#xff08;上&#xff09; 類和對…
閱讀更多...
Spark-Streaming簡介和核心編程

Spark-Streaming簡介和核心編程

Spark-Streaming簡介 概述&#xff1a;用于流式數據處理&#xff0c;支持Kafka、Flume等多種數據輸入源&#xff0c;可使用Spark原語運算&#xff0c;結果能保存到HDFS、數據庫等。它以DStream&#xff08;離散化流&#xff09;為抽象表示&#xff0c;是RDD在實時場景的封裝&am…
閱讀更多...
verilog中的約束信息

verilog中的約束信息

1、保持約束 keep&#xff1a;當編譯器在對FPGA設計進行映射時&#xff0c;一些線網將會被吸收到邏輯塊中。 (* KEEP "{TRUE | FALSE}" *) keep_hierarchy:vivado默認會把設計變成一級一級模塊化的調用轉換為一個沒有子模塊的超大模塊。這個約束會保留部分層級關系…
閱讀更多...
Missashe考研日記-day24

Missashe考研日記-day24

Missashe考研日記-day24 1 專業課408 學習時間&#xff1a;2h30min學習內容&#xff1a; 今天把剩下的兩個經典同步問題和管程部分的課看了&#xff0c;然后做課后習題。這部分的重點在PV大題&#xff0c;很多很經典&#xff0c;不過第一輪不打算做大題&#xff0c;把選擇題做…
閱讀更多...
力扣每日打卡17 49. 字母異位詞分組 (中等)

力扣每日打卡17 49. 字母異位詞分組 (中等)

力扣 49. 字母異位詞分組 中等 前言一、題目內容二、解題方法1. 哈希函數2.官方題解2.1 前言2.2 方法一&#xff1a;排序2.2 方法二&#xff1a;計數 前言 這是刷算法題的第十七天&#xff0c;用到的語言是JS 題目&#xff1a;力扣 49. 字母異位詞分組 (中等) 一、題目內容 給…
閱讀更多...
C#抽象類和虛方法的作用是什么？

C#抽象類和虛方法的作用是什么？

抽象類 (abstract class)&#xff1a; 不能直接實例化&#xff0c;只能被繼承。 用來定義一套基礎框架和規范&#xff0c;強制子類必須實現某些方法&#xff08;抽象方法&#xff09;。 可用來封裝一些共通的邏輯&#xff0c;減少代碼重復。 虛方法 (virtual)&#xff1a; …
閱讀更多...
PowerBi中ALLEXCEPT怎么使用？

PowerBi中ALLEXCEPT怎么使用？

在 Power BI 的 DAX 中&#xff0c;ALLEXCEPT() 是一個非常重要的函數&#xff0c;用來實現**“在保留部分篩選條件的前提下&#xff0c;移除其他所有篩選器”**&#xff0c;它常用于 同比、占比、累計匯總 等分析中。 ? 一、ALLEXCEPT 是什么意思&#xff1f; 函數全稱&…
閱讀更多...
IQ信號和實信號的關系與轉換的matlab實現

IQ信號和實信號的關系與轉換的matlab實現

IQ信號 IQ信號通常是指兩路正交的信號（I路和Q路），在實際信號采樣中，通常會進行IQ采樣，將實信號轉換為復基帶信號進行存儲。 IQ信號轉實信號 IQ信號轉為實信號，其實就是將IQ兩路正交信號通過上變頻合并為一個實數的帶通信號，這通常在通信系統中用于將基帶信號調制到載…
閱讀更多...
【鋰電池剩余壽命預測】LSTM長短期記憶神經網絡鋰電池剩余壽命預測（Matlab源碼）

【鋰電池剩余壽命預測】LSTM長短期記憶神經網絡鋰電池剩余壽命預測（Matlab源碼）

目錄 效果一覽程序獲取程序內容代碼分享研究內容基于LSTM長短期記憶神經網絡的鋰電池剩余壽命預測摘要關鍵詞1. 引言1.1 研究背景1.2 研究現狀與問題1.3 研究目的與意義2. 文獻綜述2.1 鋰電池剩余壽命預測方法概述2.2 傳統預測方法的優勢與不足2.3 LSTM在鋰電池壽命預測中的應用…
閱讀更多...
具身智能的理論基礎

具身智能的理論基礎

引言 在人工智能與認知科學快速發展的背景下&#xff0c;“具身智能”&#xff08;Embodied Intelligence&#xff09;這一概念日益受到重視。具身智能是指智能體的認知能力不僅源于其大腦&#xff08;或中央處理單元&#xff09;&#xff0c;更根植于其身體的結構、感官與其所…
閱讀更多...
【數據結構】勵志大廠版·初級（二刷復習）雙鏈表

【數據結構】勵志大廠版·初級（二刷復習）雙鏈表

前引&#xff1a;今天學習的雙鏈表屬于鏈表結構中最復雜的一種&#xff08;帶頭雙向循環鏈表&#xff09;&#xff0c;按照安排&#xff0c;我們會先進行復習&#xff0c;如何實現雙鏈表&#xff0c;如基本的頭插、頭刪、尾刪、尾插&#xff0c;掌握每個細節&#xff0c;隨后進…
閱讀更多...
CSS `display` 屬性詳解（完整版）

CSS `display` 屬性詳解（完整版）

CSS display 屬性詳解&#xff08;完整版&#xff09; 1. 屬性值及特性詳解 display 屬性控制元素的布局類型和生成的框類型&#xff0c;以下是 所有有效值 及其特性&#xff1a; 1.1 基礎類型 值描述布局行為是否生成塊級框典型用途block元素獨占一行&#xff0c;寬度自動撐…
閱讀更多...
【數據結構 · 初階】- 堆的實現

【數據結構 · 初階】- 堆的實現

目錄 一.初始化 二.插入 三.刪除&#xff08;堆頂、根&#xff09; 四.整體代碼 Heap.h Test.c Heap.c 我們使用順序結構實現完全二叉樹&#xff0c;也就是堆的實現 以前學的數據結構只是單純的存儲數據。堆除了存儲數據&#xff0c;還有其他的價值——排序。是一個功能…
閱讀更多...
qt.tlsbackend.ossl: Failed to load libssl/libcrypto.

qt.tlsbackend.ossl: Failed to load libssl/libcrypto.

我的環境是windows&#xff0c;QT6.3.2&#xff08;msvc2019_64/mingw_64&#xff09; 出錯原因 QT沒有正確加載OpenSSL。 解決過程 1、確保安裝的有openssl。 文章結尾有個注意&#xff0c;是其他方式安裝過openssl&#xff0c;環境變量有&#xff0c;但是QT找不到的問題。…
閱讀更多...
【Linux】用戶權限

【Linux】用戶權限

shell命令 1. Linux本質上是一個操作系統&#xff0c;但是一般的用戶不能直接使用它&#xff0c;而是需要通過外殼程序shell&#xff0c;來與Linux內核進行溝通。 2. shell的簡單定義&#xff1a;命令行解釋器。主要包含以下作用&#xff1a; 將使用者的命令翻譯給核心處理。將…
閱讀更多...
賽靈思 XC7K325T-2FFG900I FPGA Xilinx Kintex?7

賽靈思 XC7K325T-2FFG900I FPGA Xilinx Kintex?7

XC7K325T-2FFG900I 是 Xilinx Kintex?7 系列中一款工業級 (I) 高性能 FPGA&#xff0c;基于 28 nm HKMG HPL 工藝制程&#xff0c;核心電壓標稱 1.0 V&#xff0c;I/O 電壓可在 0.97 V–1.03 V 之間靈活配置&#xff0c;并可在 –40 C 至 100 C 溫度范圍內穩定運行。該器件提供…
閱讀更多...
【題解-Acwing】847. 圖中點的層次

【題解-Acwing】847. 圖中點的層次

題目：847. 圖中點的層次 題目描述 給定一個 n 個點 m 條邊的有向圖，圖中可能存在重邊和自環。 所有邊的長度都是 1，點的編號為 1～n。 請你求出 1 號點到 n 號點的最短距離，如果從 1 號點無法走到 n 號點，輸出 ?1 。 輸入 第一行包含兩個整數 n 和 m。 接下來 m 行…
閱讀更多...
最新文章

Copyright @ 2022~2023