|
二进制包安装 ： 系统是统信uos ，uniontech os server 20，majorversion=20,minorversion =1050,osbuild = 1202.101. greatsql 版本是：GreatSQL-8.0.32.24-uos-glibc2.2-aarch64.tar.xz error.log是 2026-02-02T17:34:49.295250+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-02-02T17:34:49.295261+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-02-02T17:34:49.295313+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=8b4baa37f838ef99e3ef020b362fcc140a5d5431 2026-02-02T17:34:49.295320+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64/. 2026-02-02T17:34:49.295330+08:00 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64/bin/mysqld (mysqld 8.0.32-24) starting as process 75477 2026-02-02T17:34:49.299556+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2026-02-02T17:34:49.299741+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2026-02-02T17:34:49.299805+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2026-02-02T17:34:49.299823+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2026-02-02T17:34:49.299833+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2026-02-02T17:34:49.301370+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-02-02T17:34:49.301420+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2026-02-02T17:34:49.301457+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2026-02-02T17:34:49.301476+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2026-02-02T17:34:49.301486+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2026-02-02T17:34:49.301497+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13 2026-02-02T17:34:49.302741+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2026-02-02T17:34:49.303093+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2026-02-02T17:34:49.303147+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './' 2026-02-02T17:34:49.304487+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 3 files. 2026-02-02T17:34:49.305262+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 5.000000G, instances = 4, chunk size =128.000000M 2026-02-02T17:34:49.482396+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2026-02-02T17:34:49.491941+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority(). 2026-02-02T17:34:49.492737+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2026-02-02T17:34:49.501214+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2026-02-02T17:34:49.516909+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2026-02-02T17:34:49.516959+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128 2026-02-02T17:34:49.516988+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2026-02-02T17:34:49.517010+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2026-02-02T17:34:49.563950+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 9333212 in redo log file ./#innodb_redo/#ib_redo0. 2026-02-02T17:34:49.564058+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 9332788, whereas checkpoint_lsn = 9333212 and start_lsn = 9332736 2026-02-02T17:34:49.568786+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2026-02-02T17:34:49.569156+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2026-02-02T17:34:49.569178+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2026-02-02T17:34:49.569578+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2026-02-02T17:34:49.569972+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2026-02-02T17:34:49.570450+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2026-02-02T17:34:49.570488+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 9230 2026-02-02T17:34:49.593591+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2026-02-02T17:34:49.593634+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 23148 ms. 2026-02-02T17:34:49.593721+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2026-02-02T17:34:49.593782+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2026-02-02T17:34:49.597744+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2026-02-02T17:34:49.597870+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2026-02-02T17:34:49.604398+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-02-02T17:34:49.604735+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-23 started; log sequence number 9333222 2026-02-02T17:34:49.604934+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-02-02T17:34:49.610026+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'. 2026-02-02T17:34:49.707079+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2026-02-02T17:34:49.707821+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 5 tablespaces. Validated 5. 2026-02-02T17:34:49.722870+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'. mysqld: Table 'mysql.plugin' doesn't exist 2026-02-02T17:34:49.725116+08:00 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2026-02-02T17:34:49.725399+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.725732+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.725962+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.726191+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.726392+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.726602+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.726804+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.727167+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2026-02-02T17:34:49.727811+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060' 2026-02-02T17:34:49.727844+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysqlx.sock'' 2026-02-02T17:34:49.747479+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-02-02T17:34:49.752416+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions. 2026-02-02T17:34:49.752463+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions. 2026-02-02T17:34:49.754858+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2026-02-02T17:34:49.755092+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2026-02-02T17:34:49.755253+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /sfj_data/GreatSQL/ib_buffer_pool 2026-02-02T17:34:49.758376+08:00 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2026-02-02T17:34:49.761259+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 260202 17:34:49 2026-02-02T17:34:49.762627+08:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2026-02-02T17:34:49.819693+08:00 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2026-02-02T17:34:49.820246+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-02-02T17:34:49.820275+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2026-02-02T17:34:49.821178+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-02-02T17:34:49.821215+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-02-02T17:34:49.821243+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-02-02T17:34:49.821255+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-02-02T17:34:49.821414+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '0.0.0.0'; port: 3306 2026-02-02T17:34:49.821434+08:00 0 [Note] [MY-010264] [Server] - '0.0.0.0' resolves to '0.0.0.0'; 2026-02-02T17:34:49.821456+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '0.0.0.0'. 2026-02-02T17:34:49.822224+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:34:49.822449+08:00 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2026-02-02T17:34:49.822483+08:00 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2026-02-02T17:34:49.823353+08:00 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2026-02-02T17:34:49.823421+08:00 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2026-02-02T17:34:49.823516+08:00 0 [ERROR] [MY-010119] [Server] Aborting 2026-02-02T17:34:49.824702+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting. 2026-02-02T17:34:50.825018+08:00 0 [Note] [MY-010120] [Server] Binlog end 2026-02-02T17:34:50.826161+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx' 2026-02-02T17:34:50.826673+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner' 2026-02-02T17:34:50.826696+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram' 2026-02-02T17:34:50.826706+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE' 2026-02-02T17:34:50.826716+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE' 2026-02-02T17:34:50.826724+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable' 2026-02-02T17:34:50.826731+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM' 2026-02-02T17:34:50.826739+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' 2026-02-02T17:34:50.826756+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES' 2026-02-02T17:34:50.826764+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES' 2026-02-02T17:34:50.826771+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL' 2026-02-02T17:34:50.826781+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS' 2026-02-02T17:34:50.826788+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES' 2026-02-02T17:34:50.826795+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES' 2026-02-02T17:34:50.826801+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS' 2026-02-02T17:34:50.826808+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES' 2026-02-02T17:34:50.826815+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2026-02-02T17:34:50.826821+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2026-02-02T17:34:50.826828+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG' 2026-02-02T17:34:50.826834+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2026-02-02T17:34:50.826841+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED' 2026-02-02T17:34:50.826847+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2026-02-02T17:34:50.826854+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS' 2026-02-02T17:34:50.826860+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2026-02-02T17:34:50.826867+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2026-02-02T17:34:50.826873+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2026-02-02T17:34:50.826880+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE' 2026-02-02T17:34:50.826886+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2026-02-02T17:34:50.826892+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2026-02-02T17:34:50.826899+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET' 2026-02-02T17:34:50.826905+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM' 2026-02-02T17:34:50.826911+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET' 2026-02-02T17:34:50.826918+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP' 2026-02-02T17:34:50.826924+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX' 2026-02-02T17:34:50.826930+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' 2026-02-02T17:34:50.826965+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown... 2026-02-02T17:34:50.827434+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /sfj_data/GreatSQL/ib_buffer_pool 2026-02-02T17:34:50.827712+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 260202 17:34:50 2026-02-02T17:34:50.830432+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed... 2026-02-02T17:34:51.544295+08:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 737280 2026-02-02T17:34:51.544558+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 9379517 2026-02-02T17:34:51.544698+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2026-02-02T17:34:51.544727+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY' 2026-02-02T17:34:51.544739+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV' 2026-02-02T17:34:51.544749+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA' 2026-02-02T17:34:51.544807+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin' 2026-02-02T17:34:51.544832+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner' 2026-02-02T17:34:51.544842+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password' 2026-02-02T17:34:51.544851+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password' 2026-02-02T17:34:51.544858+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password' 2026-02-02T17:34:51.545042+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog' 2026-02-02T17:34:51.546244+08:00 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64/bin/mysqld: Shutdown complete (mysqld 8.0.32-24) GreatSQL, Release 24, Revision 3714067bc8c. 2026-02-02T17:38:47.287308+08:00 0 [Note] [MY-010098] [Server] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2026-02-02T17:38:47.287317+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-02-02T17:38:47.287365+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=8b4baa37f838ef99e3ef020b362fcc140a5d5431 2026-02-02T17:38:47.287373+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64/. 2026-02-02T17:38:47.287383+08:00 0 [System] [MY-010116] [Server] /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64/bin/mysqld (mysqld 8.0.32-24) starting as process 75699 2026-02-02T17:38:47.292097+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2026-02-02T17:38:47.292283+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2026-02-02T17:38:47.292347+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2026-02-02T17:38:47.292364+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2026-02-02T17:38:47.292374+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2026-02-02T17:38:47.293879+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2026-02-02T17:38:47.293933+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2026-02-02T17:38:47.293969+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2026-02-02T17:38:47.293989+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2026-02-02T17:38:47.293998+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2026-02-02T17:38:47.294010+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13 2026-02-02T17:38:47.295233+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2026-02-02T17:38:47.295585+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2026-02-02T17:38:47.295639+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './' 2026-02-02T17:38:47.296932+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 3 files. 2026-02-02T17:38:47.297726+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 5.000000G, instances = 4, chunk size =128.000000M 2026-02-02T17:38:47.475387+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2026-02-02T17:38:47.498609+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority(). 2026-02-02T17:38:47.499453+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2026-02-02T17:38:47.517709+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2026-02-02T17:38:47.570516+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2026-02-02T17:38:47.570568+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128 2026-02-02T17:38:47.570596+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2026-02-02T17:38:47.570618+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2026-02-02T17:38:47.627135+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 9379517 in redo log file ./#innodb_redo/#ib_redo0. 2026-02-02T17:38:47.627233+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 9379373, whereas checkpoint_lsn = 9379517 and start_lsn = 9379328 2026-02-02T17:38:47.633670+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2026-02-02T17:38:47.634125+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2026-02-02T17:38:47.634151+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2026-02-02T17:38:47.634564+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2026-02-02T17:38:47.634941+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2026-02-02T17:38:47.635432+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2026-02-02T17:38:47.635471+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 9742 2026-02-02T17:38:47.784024+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2026-02-02T17:38:47.784110+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 148639 ms. 2026-02-02T17:38:47.784223+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2026-02-02T17:38:47.784313+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2026-02-02T17:38:47.788969+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2026-02-02T17:38:47.789087+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2026-02-02T17:38:47.795778+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-02-02T17:38:47.796120+08:00 1 [Note] [MY-012976] [InnoDB] Percona XtraDB (http://www.percona.com) 8.0.32-23 started; log sequence number 9379527 2026-02-02T17:38:47.796309+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2026-02-02T17:38:47.802161+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'. 2026-02-02T17:38:47.912763+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2026-02-02T17:38:47.913532+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 5 tablespaces. Validated 5. 2026-02-02T17:38:47.929130+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'. mysqld: Table 'mysql.plugin' doesn't exist 2026-02-02T17:38:47.931378+08:00 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2026-02-02T17:38:47.931673+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.932096+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.932333+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.932569+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.932776+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.932983+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.933179+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:47.933587+08:00 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available' 2026-02-02T17:38:47.934266+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33060' 2026-02-02T17:38:47.934305+08:00 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysqlx.sock'' 2026-02-02T17:38:47.955339+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-02-02T17:38:47.972429+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions. 2026-02-02T17:38:47.972482+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions. 2026-02-02T17:38:47.975291+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin 2026-02-02T17:38:47.975508+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end 2026-02-02T17:38:47.975680+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /sfj_data/GreatSQL/ib_buffer_pool 2026-02-02T17:38:47.978914+08:00 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2026-02-02T17:38:47.981241+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 260202 17:38:47 2026-02-02T17:38:47.983073+08:00 0 [Note] [MY-012922] [InnoDB] Waiting for purge to start 2026-02-02T17:38:48.039979+08:00 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2026-02-02T17:38:48.040512+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-02-02T17:38:48.040542+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory. 2026-02-02T17:38:48.041456+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2026-02-02T17:38:48.041493+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2026-02-02T17:38:48.041524+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-02-02T17:38:48.041536+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-02-02T17:38:48.041673+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3306 2026-02-02T17:38:48.041721+08:00 0 [Note] [MY-010253] [Server] IPv6 is available. 2026-02-02T17:38:48.041735+08:00 0 [Note] [MY-010264] [Server] - '::' resolves to '::'; 2026-02-02T17:38:48.041747+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'. 2026-02-02T17:38:48.042565+08:00 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2026-02-02T17:38:48.042776+08:00 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2026-02-02T17:38:48.042811+08:00 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2026-02-02T17:38:48.043364+08:00 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2026-02-02T17:38:48.043429+08:00 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2026-02-02T17:38:48.043521+08:00 0 [ERROR] [MY-010119] [Server] Aborting 2026-02-02T17:38:48.044703+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting. 2026-02-02T17:38:49.045016+08:00 0 [Note] [MY-010120] [Server] Binlog end 2026-02-02T17:38:49.046317+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx' 2026-02-02T17:38:49.046945+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner' 2026-02-02T17:38:49.046974+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram' 2026-02-02T17:38:49.046985+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE' 2026-02-02T17:38:49.046995+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE' 2026-02-02T17:38:49.047003+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable' 2026-02-02T17:38:49.047010+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM' 2026-02-02T17:38:49.047017+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' 2026-02-02T17:38:49.047038+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES' 2026-02-02T17:38:49.047047+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES' 2026-02-02T17:38:49.047054+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL' 2026-02-02T17:38:49.047061+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS' 2026-02-02T17:38:49.047068+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES' 2026-02-02T17:38:49.047075+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES' 2026-02-02T17:38:49.047081+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS' 2026-02-02T17:38:49.047088+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES' 2026-02-02T17:38:49.047095+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2026-02-02T17:38:49.047101+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2026-02-02T17:38:49.047108+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG' 2026-02-02T17:38:49.047114+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2026-02-02T17:38:49.047121+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED' 2026-02-02T17:38:49.047127+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2026-02-02T17:38:49.047134+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS' 2026-02-02T17:38:49.047141+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2026-02-02T17:38:49.047148+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2026-02-02T17:38:49.047154+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2026-02-02T17:38:49.047161+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE' 2026-02-02T17:38:49.047167+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2026-02-02T17:38:49.047174+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2026-02-02T17:38:49.047181+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET' 2026-02-02T17:38:49.047187+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM' 2026-02-02T17:38:49.047194+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET' 2026-02-02T17:38:49.047200+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP' 2026-02-02T17:38:49.047207+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX' 2026-02-02T17:38:49.047214+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' 2026-02-02T17:38:49.047248+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown... 2026-02-02T17:38:49.047706+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /sfj_data/GreatSQL/ib_buffer_pool 2026-02-02T17:38:49.047993+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 260202 17:38:49 2026-02-02T17:38:49.051023+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed... 2026-02-02T17:38:49.734425+08:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 720896 2026-02-02T17:38:49.734673+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 9426086 2026-02-02T17:38:49.734805+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2026-02-02T17:38:49.734836+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY' 2026-02-02T17:38:49.734850+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV' 2026-02-02T17:38:49.734860+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA' 2026-02-02T17:38:49.734917+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin' 2026-02-02T17:38:49.734943+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner' 2026-02-02T17:38:49.734955+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password' 2026-02-02T17:38:49.734965+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password' 2026-02-02T17:38:49.734972+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password' 2026-02-02T17:38:49.735148+08:00 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog' 2026-02-02T17:38:49.736402+08:00 0 [System] [MY-010910] [Server] /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64/bin/mysqld: Shutdown complete (mysqld 8.0.32-24) GreatSQL, Release 24, Revision 3714067bc8c. my.cnf 是 [client] socket = /sfj_data/GreatSQL/mysql.sock [mysqld] user = mysql port = 3306 server_id = 3306 basedir = /usr/local/GreatSQL-8.0.32-24-uos-glibc2.28-aarch64 datadir = /sfj_data/GreatSQL socket = /sfj_data/GreatSQL/mysql.sock pid-file = mysql.pid character-set-server = UTF8MB4 skip_name_resolve = ON default_time_zone = "+8:00" #bind_address = "0.0.0.0" #secure_file_priv = /sfj_data/GreatSQL # Performance lock_wait_timeout = 3600 open_files_limit = 65535 back_log = 1024 max_connections = 1024 max_connect_errors = 1000000 table_open_cache = 4096 table_definition_cache = 2048 thread_stack = 512K sort_buffer_size = 4M join_buffer_size = 4M read_buffer_size = 8M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 64M thread_cache_size = 768 interactive_timeout = 600 wait_timeout = 600 tmp_table_size = 96M max_heap_table_size = 96M max_allowed_packet = 64M net_buffer_shrink_interval = 180 sql_generate_invisible_primary_key = ON # Logs log_timestamps = SYSTEM log_error = error.log log_error_verbosity = 3 slow_query_log = ON log_slow_extra = ON slow_query_log_file = slow.log long_query_time = 0.01 log_queries_not_using_indexes = ON log_throttle_queries_not_using_indexes = 60 min_examined_row_limit = 100 log_slow_admin_statements = ON log_slow_replica_statements = ON log_slow_verbosity = FULL log_bin = binlog binlog_format = ROW sync_binlog = 1 binlog_cache_size = 4M max_binlog_cache_size = 6G max_binlog_size = 1G binlog_space_limit = 500G binlog_rows_query_log_events = ON binlog_expire_logs_seconds = 604800 binlog_checksum = CRC32 binlog_order_commits = OFF gtid_mode = ON enforce_gtid_consistency = ON # InnoDB innodb_buffer_pool_size = 5G #如果是专用的数据库服务器，则可以设置为物理内存的50%-70%，视实际情况而定 innodb_buffer_pool_instances = 4 innodb_data_file_path = ibdata1:12M:autoextend innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 64M innodb_redo_log_capacity = 6G innodb_doublewrite_files = 2 innodb_doublewrite_pages = 128 innodb_max_undo_log_size = 4G innodb_io_capacity = 10000 innodb_io_capacity_max = 20000 innodb_open_files = 65535 innodb_flush_method = O_DIRECT innodb_use_fdatasync = ON innodb_lru_scan_depth = 4000 innodb_lock_wait_timeout = 10 innodb_rollback_on_timeout = ON innodb_print_all_deadlocks = ON innodb_online_alter_log_max_size = 4G innodb_print_ddl_logs = ON innodb_status_file = ON innodb_status_output = OFF innodb_status_output_locks = ON innodb_sort_buffer_size = 64M innodb_adaptive_hash_index = OFF innodb_numa_interleave = OFF innodb_spin_wait_delay = 20 innodb_print_lock_wait_timeout_info = ON innodb_change_buffering = none kill_idle_transaction = 300 #innodb_data_file_async_purge = ON #pfs settings performance_schema = 1 #performance_schema_instrument = '%memory%=on' performance_schema_instrument = '%lock%=on' |
|
|
GreatSQL社区
3 天前
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
