本帖最后由 lvhejin 于 2026-1-13 16:00 编辑
二进制包安装 :
我们用天翼云主机,系统是:CTyunOS 23.01 64 位 ARM 版 鲲鹏通用型ks1
安装包是: GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64.tar.xz


服务文件:
- [root@GreatSQL-01 lib]# ll /etc/systemd/system/greatsql.service
- -rw-r--r-- 1 root root 893 Jan 12 16:30 /etc/systemd/system/greatsql.service
- [root@GreatSQL-01 lib]# cat /etc/systemd/system/greatsql.service
- [Unit]
- Description=GreatSQL Server
- Documentation=man:mysqld(8)
- Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
- After=network.target
- After=syslog.target
- [Install]
- WantedBy=multi-user.target
- [Service]
- # some limits
- # file size
- LimitFSIZE=infinity
- # cpu time
- LimitCPU=infinity
- # virtual memory size
- LimitAS=infinity
- # open files
- LimitNOFILE=65535
- # processes/threads
- LimitNPROC=65535
- # locked memory
- LimitMEMLOCK=infinity
- # total threads (user+kernel)
- TasksMax=infinity
- TasksAccounting=false
- User=mysql
- Group=mysql
- Type=simple
- TimeoutSec=0
- PermissionsStartOnly=true
- ExecStartPre=/usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/bin/mysqld_pre_systemd
- ExecStart=/usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/bin/mysqld $MYSQLD_OPTS
- EnvironmentFile=-/etc/sysconfig/mysql
- Restart=on-failure
- RestartPreventExitStatus=1
- Environment=MYSQLD_PARENT_PID=1
- PrivateTmp=false
复制代码
error.log
- [root@GreatSQL-01 GreatSQL]# cat error.log
- 2026-01-13T11:09:58.711670+08:00 0 [System] [MY-015015] [Server] MySQL Server - start.
- 2026-01-13T11:09:58.925252+08:00 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
- 2026-01-13T11:09:58.925316+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
- 2026-01-13T11:09:58.926745+08:00 0 [Warning] [MY-010099] [Server] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
- 2026-01-13T11:09:58.926759+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
- 2026-01-13T11:09:58.926834+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=ba303d5357affecb6d9d28c2a9f1e4d8c2cb10ee
- 2026-01-13T11:09:58.926844+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/.
- 2026-01-13T11:09:58.926856+08:00 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/bin/mysqld (mysqld 8.4.4-4) starting as process 24014
- 2026-01-13T11:09:58.938863+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
- 2026-01-13T11:09:58.939407+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
- 2026-01-13T11:09:58.939528+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
- 2026-01-13T11:09:58.939559+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
- 2026-01-13T11:09:58.939577+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
- 2026-01-13T11:09:58.939700+08:00 0 [Note] [MY-010747] [Server] Plugin 'mysql_native_password' is disabled.
- 2026-01-13T11:09:58.941695+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
- 2026-01-13T11:09:58.941739+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
- 2026-01-13T11:09:58.941780+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
- 2026-01-13T11:09:58.941801+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
- 2026-01-13T11:09:58.941813+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
- 2026-01-13T11:09:58.941824+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1
- 2026-01-13T11:09:58.944146+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/GreatSQL/#file_purge
- 2026-01-13T11:09:58.944273+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
- 2026-01-13T11:09:58.944746+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
- 2026-01-13T11:09:58.944867+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
- 2026-01-13T11:09:58.951545+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 8 files.
- 2026-01-13T11:09:58.953730+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 5.000000G, instances = 8, chunk size =128.000000M
- 2026-01-13T11:09:59.182935+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
- 2026-01-13T11:09:59.199207+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
- 2026-01-13T11:09:59.214082+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
- 2026-01-13T11:09:59.242812+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
- 2026-01-13T11:09:59.242869+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128
- 2026-01-13T11:09:59.242903+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
- 2026-01-13T11:09:59.293719+08:00 1 [Note] [MY-013549] [InnoDB] ./#ib_16384_0.dblwr size increased to 18874368 bytes from 6291456 bytes
- 2026-01-13T11:09:59.293814+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
- 2026-01-13T11:09:59.340575+08:00 1 [Note] [MY-013549] [InnoDB] ./#ib_16384_1.dblwr size increased to 27262976 bytes from 14680064 bytes
- 2026-01-13T11:09:59.459711+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 19734831 in redo log file ./#innodb_redo/#ib_redo6.
- 2026-01-13T11:09:59.459960+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 19734552, whereas checkpoint_lsn = 19734831 and start_lsn = 19734528
- 2026-01-13T11:09:59.469335+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
- 2026-01-13T11:09:59.470241+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
- 2026-01-13T11:09:59.470269+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
- 2026-01-13T11:09:59.471398+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
- 2026-01-13T11:09:59.472875+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
- 2026-01-13T11:09:59.474144+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
- 2026-01-13T11:09:59.474207+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1038
- 2026-01-13T11:09:59.539756+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
- 2026-01-13T11:09:59.539838+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 65 ms.
- 2026-01-13T11:09:59.539946+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
- 2026-01-13T11:09:59.542047+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
- 2026-01-13T11:09:59.589329+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
- 2026-01-13T11:09:59.589785+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
- 2026-01-13T11:09:59.661603+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
- 2026-01-13T11:09:59.662678+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.4.4-8.4.4 started; log sequence number 19734841
- 2026-01-13T11:09:59.664620+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
- 2026-01-13T11:09:59.678560+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80300'.
- 2026-01-13T11:09:59.858945+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
- 2026-01-13T11:09:59.860271+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 10 tablespaces. Validated 10.
- 2026-01-13T11:09:59.887295+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80300'.
- 2026-01-13T11:09:59.917793+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
- 2026-01-13T11:09:59.917968+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
- 2026-01-13T11:09:59.917993+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysqlx.sock''
- 2026-01-13T11:10:00.092422+08:00 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
- 2026-01-13T11:10:00.104051+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
- 2026-01-13T11:10:00.104106+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
- 2026-01-13T11:10:00.107621+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
- 2026-01-13T11:10:00.108237+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
- 2026-01-13T11:10:00.108537+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/GreatSQL/ib_buffer_pool
- 2026-01-13T11:10:00.109840+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 260113 11:10:00
- 2026-01-13T11:10:00.116145+08:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
- 2026-01-13T11:10:00.185774+08:00 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
- 2026-01-13T11:10:00.186056+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
- 2026-01-13T11:10:00.186779+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2026-01-13T11:10:00.186820+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
- 2026-01-13T11:10:00.186910+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
- 2026-01-13T11:10:00.186982+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
- 2026-01-13T11:10:00.187126+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 2026-01-13T11:10:00.187146+08:00 0 [Note] [MY-010264] [Server] - '0.0.0.0' resolves to '0.0.0.0';
- 2026-01-13T11:10:00.187167+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '0.0.0.0'.
- 2026-01-13T11:10:00.192752+08:00 0 [ERROR] [MY-000067] [Server] unknown variable 'binlog_transaction_dependency_tracking=WRITESET'.
- 2026-01-13T11:10:00.193994+08:00 0 [ERROR] [MY-010119] [Server] Aborting
- 2026-01-13T11:10:00.195215+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
- 2026-01-13T11:10:01.119956+08:00 0 [Note] [MY-010120] [Server] Binlog end
- 2026-01-13T11:10:01.124144+08:00 0 [Note] [MY-015019] [Server] MySQL Server: Plugins Shutdown - start.
- 2026-01-13T11:10:01.124190+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'group_replication'
- 2026-01-13T11:10:01.124290+08:00 0 [Note] [MY-011665] [Repl] Plugin group_replication reported: 'All Group Replication server observers have been successfully unregistered'
- 2026-01-13T11:10:01.124969+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'clone'
- 2026-01-13T11:10:01.125005+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
- 2026-01-13T11:10:01.125643+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
- 2026-01-13T11:10:01.125667+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
- 2026-01-13T11:10:01.125678+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
- 2026-01-13T11:10:01.125689+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
- 2026-01-13T11:10:01.125698+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
- 2026-01-13T11:10:01.125707+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
- 2026-01-13T11:10:01.125716+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
- 2026-01-13T11:10:01.125739+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_ASYNC_PURGE_FILES'
- 2026-01-13T11:10:01.125749+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
- 2026-01-13T11:10:01.125757+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
- 2026-01-13T11:10:01.125765+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
- 2026-01-13T11:10:01.125773+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
- 2026-01-13T11:10:01.125781+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
- 2026-01-13T11:10:01.125789+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
- 2026-01-13T11:10:01.125797+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
- 2026-01-13T11:10:01.125806+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
- 2026-01-13T11:10:01.125813+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
- 2026-01-13T11:10:01.125821+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
- 2026-01-13T11:10:01.125829+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
- 2026-01-13T11:10:01.125837+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
- 2026-01-13T11:10:01.125858+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
- 2026-01-13T11:10:01.125867+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
- 2026-01-13T11:10:01.125875+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
- 2026-01-13T11:10:01.125883+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
- 2026-01-13T11:10:01.125894+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
- 2026-01-13T11:10:01.125903+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
- 2026-01-13T11:10:01.125910+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
- 2026-01-13T11:10:01.125918+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
- 2026-01-13T11:10:01.125926+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
- 2026-01-13T11:10:01.125933+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
- 2026-01-13T11:10:01.125941+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
- 2026-01-13T11:10:01.125949+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
- 2026-01-13T11:10:01.125957+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
- 2026-01-13T11:10:01.125965+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
- 2026-01-13T11:10:01.125973+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
- 2026-01-13T11:10:01.126015+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
- 2026-01-13T11:10:01.127684+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /data/GreatSQL/ib_buffer_pool
- 2026-01-13T11:10:01.127967+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 260113 11:10:01
- 2026-01-13T11:10:01.137886+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
- 2026-01-13T11:10:01.951523+08:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 1540096
- 2026-01-13T11:10:01.952102+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20089776
- 2026-01-13T11:10:01.954957+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
- 2026-01-13T11:10:01.955052+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
- 2026-01-13T11:10:01.955076+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'dlk'
- 2026-01-13T11:10:01.955089+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
- 2026-01-13T11:10:01.955100+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
- 2026-01-13T11:10:01.955161+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
- 2026-01-13T11:10:01.955185+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
- 2026-01-13T11:10:01.955196+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
- 2026-01-13T11:10:01.955206+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
- 2026-01-13T11:10:01.956127+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
- 2026-01-13T11:10:01.956206+08:00 0 [Note] [MY-015020] [Server] MySQL Server: Plugins Shutdown - end.
- 2026-01-13T11:10:01.960558+08:00 0 [Note] [MY-015021] [Server] MySQL Server: Components Shutdown - start.
- 2026-01-13T11:10:01.961357+08:00 0 [Note] [MY-015022] [Server] MySQL Server: Components Shutdown - end (with return value = 0).
- 2026-01-13T11:10:01.961567+08:00 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/bin/mysqld: Shutdown complete (mysqld 8.4.4-4) GreatSQL, Release 4, Revision d73de75905d-gmssl.
- 2026-01-13T11:10:01.961583+08:00 0 [System] [MY-015016] [Server] MySQL Server - end.
- 2026-01-13T11:30:44.821466+08:00 0 [System] [MY-015015] [Server] MySQL Server - start.
- 2026-01-13T11:30:45.034584+08:00 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
- 2026-01-13T11:30:45.034637+08:00 0 [Warning] [MY-011069] [Server] The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
- 2026-01-13T11:30:45.035996+08:00 0 [Warning] [MY-010099] [Server] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
- 2026-01-13T11:30:45.036010+08:00 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-log-path: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
- 2026-01-13T11:30:45.036081+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=ba303d5357affecb6d9d28c2a9f1e4d8c2cb10ee
- 2026-01-13T11:30:45.036091+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/.
- 2026-01-13T11:30:45.036103+08:00 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/bin/mysqld (mysqld 8.4.4-4) starting as process 24435
- 2026-01-13T11:30:45.043003+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
- 2026-01-13T11:30:45.043524+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
- 2026-01-13T11:30:45.043628+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
- 2026-01-13T11:30:45.043655+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
- 2026-01-13T11:30:45.043672+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
- 2026-01-13T11:30:45.043792+08:00 0 [Note] [MY-010747] [Server] Plugin 'mysql_native_password' is disabled.
- 2026-01-13T11:30:45.045720+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
- 2026-01-13T11:30:45.045796+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
- 2026-01-13T11:30:45.045857+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
- 2026-01-13T11:30:45.045879+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
- 2026-01-13T11:30:45.045890+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
- 2026-01-13T11:30:45.045901+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1
- 2026-01-13T11:30:45.048320+08:00 1 [Note] [MY-011066] [InnoDB] File purge : set file purge path : /data/GreatSQL/#file_purge
- 2026-01-13T11:30:45.048451+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
- 2026-01-13T11:30:45.048945+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
- 2026-01-13T11:30:45.049027+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
- 2026-01-13T11:30:45.055498+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 8 files.
- 2026-01-13T11:30:45.057501+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 5.000000G, instances = 8, chunk size =128.000000M
- 2026-01-13T11:30:45.311271+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
- 2026-01-13T11:30:45.327891+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
- 2026-01-13T11:30:45.360367+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
- 2026-01-13T11:30:45.401565+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
- 2026-01-13T11:30:45.401630+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128
- 2026-01-13T11:30:45.401664+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
- 2026-01-13T11:30:45.401700+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
- 2026-01-13T11:30:45.519123+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 20089776 in redo log file ./#innodb_redo/#ib_redo6.
- 2026-01-13T11:30:45.519301+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 20089528, whereas checkpoint_lsn = 20089776 and start_lsn = 20089344
- 2026-01-13T11:30:45.530106+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
- 2026-01-13T11:30:45.530907+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
- 2026-01-13T11:30:45.532024+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
- 2026-01-13T11:30:45.533582+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
- 2026-01-13T11:30:45.535748+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
- 2026-01-13T11:30:45.537148+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
- 2026-01-13T11:30:45.537211+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1548
- 2026-01-13T11:30:45.616115+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
- 2026-01-13T11:30:45.616201+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 78 ms.
- 2026-01-13T11:30:45.616317+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
- 2026-01-13T11:30:45.618347+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
- 2026-01-13T11:30:45.676319+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
- 2026-01-13T11:30:45.676536+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
- 2026-01-13T11:30:45.751323+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
- 2026-01-13T11:30:45.752263+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.4.4-8.4.4 started; log sequence number 20089786
- 2026-01-13T11:30:45.753202+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
- 2026-01-13T11:30:45.768996+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80300'.
- 2026-01-13T11:30:45.960975+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
- 2026-01-13T11:30:45.962364+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 10 tablespaces. Validated 10.
- 2026-01-13T11:30:45.991547+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80300'.
- 2026-01-13T11:30:46.022394+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
- 2026-01-13T11:30:46.022579+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060'
- 2026-01-13T11:30:46.022604+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysqlx.sock''
- 2026-01-13T11:30:46.085313+08:00 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
- 2026-01-13T11:30:46.090133+08:00 0 [Note] [MY-010856] [Server] Failed to open the crashed binlog file when source server is recovering it.
- 2026-01-13T11:30:46.094584+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
- 2026-01-13T11:30:46.094649+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
- 2026-01-13T11:30:46.098289+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
- 2026-01-13T11:30:46.099238+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
- 2026-01-13T11:30:46.099577+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /data/GreatSQL/ib_buffer_pool
- 2026-01-13T11:30:46.107107+08:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start
- 2026-01-13T11:30:46.131517+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 260113 11:30:46
- 2026-01-13T11:30:46.178013+08:00 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
- 2026-01-13T11:30:46.178276+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
- 2026-01-13T11:30:46.178984+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
- 2026-01-13T11:30:46.179017+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
- 2026-01-13T11:30:46.179111+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
- 2026-01-13T11:30:46.179172+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
- 2026-01-13T11:30:46.179312+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 2026-01-13T11:30:46.179332+08:00 0 [Note] [MY-010264] [Server] - '0.0.0.0' resolves to '0.0.0.0';
- 2026-01-13T11:30:46.179355+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '0.0.0.0'.
- 2026-01-13T11:30:46.184913+08:00 0 [ERROR] [MY-000067] [Server] unknown variable 'binlog_transaction_dependency_tracking=WRITESET'.
- 2026-01-13T11:30:46.186137+08:00 0 [ERROR] [MY-010119] [Server] Aborting
- 2026-01-13T11:30:46.187371+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
- 2026-01-13T11:30:47.108922+08:00 0 [Note] [MY-010120] [Server] Binlog end
- 2026-01-13T11:30:47.113096+08:00 0 [Note] [MY-015019] [Server] MySQL Server: Plugins Shutdown - start.
- 2026-01-13T11:30:47.113144+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'group_replication'
- 2026-01-13T11:30:47.113244+08:00 0 [Note] [MY-011665] [Repl] Plugin group_replication reported: 'All Group Replication server observers have been successfully unregistered'
- 2026-01-13T11:30:47.113889+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'clone'
- 2026-01-13T11:30:47.113917+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
- 2026-01-13T11:30:47.114336+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
- 2026-01-13T11:30:47.114357+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
- 2026-01-13T11:30:47.114368+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
- 2026-01-13T11:30:47.114379+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
- 2026-01-13T11:30:47.114389+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
- 2026-01-13T11:30:47.114397+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
- 2026-01-13T11:30:47.114406+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
- 2026-01-13T11:30:47.114429+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_ASYNC_PURGE_FILES'
- 2026-01-13T11:30:47.114440+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
- 2026-01-13T11:30:47.114448+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
- 2026-01-13T11:30:47.114456+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
- 2026-01-13T11:30:47.114464+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
- 2026-01-13T11:30:47.114472+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
- 2026-01-13T11:30:47.114480+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
- 2026-01-13T11:30:47.114488+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
- 2026-01-13T11:30:47.114496+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
- 2026-01-13T11:30:47.114503+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
- 2026-01-13T11:30:47.114511+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
- 2026-01-13T11:30:47.114519+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
- 2026-01-13T11:30:47.114527+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
- 2026-01-13T11:30:47.114535+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
- 2026-01-13T11:30:47.114542+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
- 2026-01-13T11:30:47.114550+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
- 2026-01-13T11:30:47.114574+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
- 2026-01-13T11:30:47.114582+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
- 2026-01-13T11:30:47.114590+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
- 2026-01-13T11:30:47.114598+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
- 2026-01-13T11:30:47.114606+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
- 2026-01-13T11:30:47.114614+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
- 2026-01-13T11:30:47.114622+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
- 2026-01-13T11:30:47.114629+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
- 2026-01-13T11:30:47.114637+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
- 2026-01-13T11:30:47.114649+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
- 2026-01-13T11:30:47.114658+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
- 2026-01-13T11:30:47.114665+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
- 2026-01-13T11:30:47.114706+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
- 2026-01-13T11:30:47.116043+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /data/GreatSQL/ib_buffer_pool
- 2026-01-13T11:30:47.116341+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 260113 11:30:47
- 2026-01-13T11:30:47.125481+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
- 2026-01-13T11:30:47.806510+08:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 933888
- 2026-01-13T11:30:47.807007+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 20167728
- 2026-01-13T11:30:47.809816+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
- 2026-01-13T11:30:47.809891+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
- 2026-01-13T11:30:47.809909+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'dlk'
- 2026-01-13T11:30:47.809921+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
- 2026-01-13T11:30:47.809932+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
- 2026-01-13T11:30:47.810003+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
- 2026-01-13T11:30:47.810028+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
- 2026-01-13T11:30:47.810038+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
- 2026-01-13T11:30:47.810049+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
- 2026-01-13T11:30:47.810925+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
- 2026-01-13T11:30:47.810987+08:00 0 [Note] [MY-015020] [Server] MySQL Server: Plugins Shutdown - end.
- 2026-01-13T11:30:47.813278+08:00 0 [Note] [MY-015021] [Server] MySQL Server: Components Shutdown - start.
- 2026-01-13T11:30:47.814070+08:00 0 [Note] [MY-015022] [Server] MySQL Server: Components Shutdown - end (with return value = 0).
- 2026-01-13T11:30:47.814283+08:00 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.4.4-4-Linux-glibc2.28-aarch64/bin/mysqld: Shutdown complete (mysqld 8.4.4-4) GreatSQL, Release 4, Revision d73de75905d-gmssl.
- 2026-01-13T11:30:47.814298+08:00 0 [System] [MY-015016] [Server] MySQL Server - end.
- [root@GreatSQL-01 GreatSQL]#
复制代码
解决方法:
binlog_transaction_dependency_tracking
该参数在8.0.35就被弃用,844版本删除即可
启动成功

|