重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 152|回复: 0
打印 上一主题 下一主题

[日志类] MYSQL 8.4.8 初始化日志输出

[复制链接]
跳转到指定楼层
楼主
发表于 2026-3-29 15:46:40 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
执行MYSQL初始化
# mysqld  --defaults-file=/etc/my.cnf --initialize --user=mysql

查看日志
cat /data/mysql/logs/error.log
2026-03-29T23:34:27.979714+08:00 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2026-03-29T23:34:27.985149+08:00 0 [Note] [MY-010096] [Server] Ignoring --secure-file-priv value as server is running with --initialize(-insecure).
2026-03-29T23:34:27.985489+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=5a311ce39eb88e3241b4165dfa35b998f62a5753
2026-03-29T23:34:27.985498+08:00 0 [Note] [MY-010949] [Server] Basedir set to /usr/local/mysql/.
2026-03-29T23:34:27.985850+08:00 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.4.8) initializing of server in progress as process 37686
2026-03-29T23:34:27.994917+08:00 0 [Note] [MY-010458] [Server] --initialize specified on an existing data directory.
2026-03-29T23:34:28.011649+08:00 0 [Note] [MY-010938] [Server] Generating a new UUID: c5d77e0b-2b84-11f1-8867-000c29c184b8.
2026-03-29T23:34:28.015595+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2026-03-29T23:34:28.016133+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2026-03-29T23:34:28.016189+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2026-03-29T23:34:28.016202+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2026-03-29T23:34:28.016296+08:00 0 [Note] [MY-010747] [Server] Plugin 'mysql_native_password' is disabled.
2026-03-29T23:34:28.019407+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-03-29T23:34:28.019464+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2026-03-29T23:34:28.019493+08:00 1 [Note] [MY-012274] [InnoDB] The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2026-03-29T23:34:28.020050+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2026-03-29T23:34:28.020079+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2026-03-29T23:34:28.020088+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2026-03-29T23:34:28.020145+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.3.1
2026-03-29T23:34:28.030037+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2026-03-29T23:34:28.031138+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './;/data/mysql/undolog/'
2026-03-29T23:34:28.031879+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2026-03-29T23:34:28.032125+08:00 1 [Note] [MY-012204] [InnoDB] Scanning '/data/mysql/undolog/'
2026-03-29T23:34:28.032322+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 0 files.
2026-03-29T23:34:28.033964+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 2.000000G, instances = 4, chunk size =128.000000M
2026-03-29T23:34:28.263348+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2026-03-29T23:34:28.284008+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2026-03-29T23:34:28.285132+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibdata1' size to 1024 MB. Physically writing the file full; Please wait ...
2026-03-29T23:34:28.348085+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 10%
2026-03-29T23:34:28.381541+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 20%
2026-03-29T23:34:28.409942+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 30%
2026-03-29T23:34:28.437040+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 40%
2026-03-29T23:34:28.463353+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 50%
2026-03-29T23:34:28.489210+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 60%
2026-03-29T23:34:28.515727+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 70%
2026-03-29T23:34:28.542709+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 80%
2026-03-29T23:34:28.569141+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 90%
2026-03-29T23:34:28.595856+08:00 1 [Note] [MY-012887] [InnoDB] Setting file ./ibdata1 size to 1024 MB. Progress : 100%
2026-03-29T23:34:28.596650+08:00 1 [Note] [MY-012266] [InnoDB] File './ibdata1' size is now 1024 MB.
2026-03-29T23:34:28.596751+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2, --innodb-doublewrite-files=2, segments_per_file=4
2026-03-29T23:34:28.596764+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 128
2026-03-29T23:34:28.597976+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2026-03-29T23:34:28.600546+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2026-03-29T23:34:28.683757+08:00 1 [Note] [MY-012893] [InnoDB] New redo log files created, LSN=8204
2026-03-29T23:34:28.684296+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2026-03-29T23:34:28.687181+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace /data/mysql/undolog/undo_001
2026-03-29T23:34:28.687228+08:00 1 [Note] [MY-012897] [InnoDB] Setting file /data/mysql/undolog/undo_001 size to 16 MB
2026-03-29T23:34:28.687240+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2026-03-29T23:34:28.694652+08:00 1 [Note] [MY-012896] [InnoDB] Creating UNDO Tablespace /data/mysql/undolog/undo_002
2026-03-29T23:34:28.694691+08:00 1 [Note] [MY-012897] [InnoDB] Setting file /data/mysql/undolog/undo_002 size to 16 MB
2026-03-29T23:34:28.694699+08:00 1 [Note] [MY-012898] [InnoDB] Physically writing the file full
2026-03-29T23:34:28.699603+08:00 1 [Note] [MY-012915] [InnoDB] Created 2 undo tablespaces.
2026-03-29T23:34:28.700747+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 0
2026-03-29T23:34:28.701192+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2026-03-29T23:34:28.701219+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 0 ms.
2026-03-29T23:34:28.709180+08:00 1 [Note] [MY-011920] [InnoDB] Legacy doublewrite buffer not found: creating new
2026-03-29T23:34:28.712969+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=143] type 20 to 13 when flushing.
2026-03-29T23:34:28.713030+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=142] type 20 to 13 when flushing.
2026-03-29T23:34:28.713052+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=141] type 20 to 13 when flushing.
2026-03-29T23:34:28.713074+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=140] type 20 to 13 when flushing.
2026-03-29T23:34:28.713096+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=139] type 20 to 13 when flushing.
2026-03-29T23:34:28.713148+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=138] type 20 to 13 when flushing.
2026-03-29T23:34:28.713176+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=137] type 20 to 13 when flushing.
2026-03-29T23:34:28.713199+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=136] type 20 to 13 when flushing.
2026-03-29T23:34:28.713220+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=135] type 20 to 13 when flushing.
2026-03-29T23:34:28.713242+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=134] type 20 to 13 when flushing.
2026-03-29T23:34:28.713263+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=133] type 20 to 13 when flushing.
2026-03-29T23:34:28.713285+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=132] type 20 to 13 when flushing.
2026-03-29T23:34:28.713306+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=131] type 20 to 13 when flushing.
2026-03-29T23:34:28.713334+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=130] type 20 to 13 when flushing.
2026-03-29T23:34:28.713358+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=129] type 20 to 13 when flushing.
2026-03-29T23:34:28.713382+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=128] type 20 to 13 when flushing.
2026-03-29T23:34:28.713404+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=159] type 20 to 13 when flushing.
2026-03-29T23:34:28.713425+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=158] type 20 to 13 when flushing.
2026-03-29T23:34:28.713446+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=157] type 20 to 13 when flushing.
2026-03-29T23:34:28.713467+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=156] type 20 to 13 when flushing.
2026-03-29T23:34:28.713489+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=155] type 20 to 13 when flushing.
2026-03-29T23:34:28.713513+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=154] type 20 to 13 when flushing.
2026-03-29T23:34:28.713534+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=153] type 20 to 13 when flushing.
2026-03-29T23:34:28.713555+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=152] type 20 to 13 when flushing.
2026-03-29T23:34:28.713576+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=151] type 20 to 13 when flushing.
2026-03-29T23:34:28.713597+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=150] type 20 to 13 when flushing.
2026-03-29T23:34:28.713618+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=149] type 20 to 13 when flushing.
2026-03-29T23:34:28.713639+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=148] type 20 to 13 when flushing.
2026-03-29T23:34:28.713661+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=147] type 20 to 13 when flushing.
2026-03-29T23:34:28.713684+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=146] type 20 to 13 when flushing.
2026-03-29T23:34:28.713706+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=145] type 20 to 13 when flushing.
2026-03-29T23:34:28.713727+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=144] type 20 to 13 when flushing.
2026-03-29T23:34:28.713748+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=175] type 20 to 13 when flushing.
2026-03-29T23:34:28.713770+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=174] type 20 to 13 when flushing.
2026-03-29T23:34:28.713791+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=173] type 20 to 13 when flushing.
2026-03-29T23:34:28.713812+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=172] type 20 to 13 when flushing.
2026-03-29T23:34:28.713834+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=171] type 20 to 13 when flushing.
2026-03-29T23:34:28.713858+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=170] type 20 to 13 when flushing.
2026-03-29T23:34:28.713879+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=169] type 20 to 13 when flushing.
2026-03-29T23:34:28.713900+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=168] type 20 to 13 when flushing.
2026-03-29T23:34:28.713924+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=167] type 20 to 13 when flushing.
2026-03-29T23:34:28.713945+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=166] type 20 to 13 when flushing.
2026-03-29T23:34:28.713966+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=165] type 20 to 13 when flushing.
2026-03-29T23:34:28.713990+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=164] type 20 to 13 when flushing.
2026-03-29T23:34:28.714014+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=163] type 20 to 13 when flushing.
2026-03-29T23:34:28.714035+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=162] type 20 to 13 when flushing.
2026-03-29T23:34:28.714057+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=161] type 20 to 13 when flushing.
2026-03-29T23:34:28.714152+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=160] type 20 to 13 when flushing.
2026-03-29T23:34:28.714183+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=191] type 20 to 13 when flushing.
2026-03-29T23:34:28.714205+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=190] type 20 to 13 when flushing.
2026-03-29T23:34:28.714227+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=189] type 20 to 13 when flushing.
2026-03-29T23:34:28.714248+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=188] type 20 to 13 when flushing.
2026-03-29T23:34:28.714272+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=187] type 20 to 13 when flushing.
2026-03-29T23:34:28.714293+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=186] type 20 to 13 when flushing.
2026-03-29T23:34:28.714314+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=185] type 20 to 13 when flushing.
2026-03-29T23:34:28.714335+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=184] type 20 to 13 when flushing.
2026-03-29T23:34:28.714356+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=183] type 20 to 13 when flushing.
2026-03-29T23:34:28.714378+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=182] type 20 to 13 when flushing.
2026-03-29T23:34:28.714399+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=181] type 20 to 13 when flushing.
2026-03-29T23:34:28.714423+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=180] type 20 to 13 when flushing.
2026-03-29T23:34:28.714444+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=179] type 20 to 13 when flushing.
2026-03-29T23:34:28.714465+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=178] type 20 to 13 when flushing.
2026-03-29T23:34:28.714506+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=177] type 20 to 13 when flushing.
2026-03-29T23:34:28.714531+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=176] type 20 to 13 when flushing.
2026-03-29T23:34:28.716158+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=79] type 20 to 13 when flushing.
2026-03-29T23:34:28.716246+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=78] type 20 to 13 when flushing.
2026-03-29T23:34:28.716270+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=77] type 20 to 13 when flushing.
2026-03-29T23:34:28.716301+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=76] type 20 to 13 when flushing.
2026-03-29T23:34:28.716323+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=75] type 20 to 13 when flushing.
2026-03-29T23:34:28.716345+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=74] type 20 to 13 when flushing.
2026-03-29T23:34:28.716366+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=73] type 20 to 13 when flushing.
2026-03-29T23:34:28.716387+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=72] type 20 to 13 when flushing.
2026-03-29T23:34:28.716412+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=71] type 20 to 13 when flushing.
2026-03-29T23:34:28.716503+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=70] type 20 to 13 when flushing.
2026-03-29T23:34:28.716533+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=69] type 20 to 13 when flushing.
2026-03-29T23:34:28.716555+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=68] type 20 to 13 when flushing.
2026-03-29T23:34:28.716577+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=67] type 20 to 13 when flushing.
2026-03-29T23:34:28.716598+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=66] type 20 to 13 when flushing.
2026-03-29T23:34:28.716619+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=65] type 20 to 13 when flushing.
2026-03-29T23:34:28.716640+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=64] type 20 to 13 when flushing.
2026-03-29T23:34:28.716664+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=95] type 20 to 13 when flushing.
2026-03-29T23:34:28.716685+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=94] type 20 to 13 when flushing.
2026-03-29T23:34:28.716711+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=93] type 20 to 13 when flushing.
2026-03-29T23:34:28.716732+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=92] type 20 to 13 when flushing.
2026-03-29T23:34:28.716754+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=91] type 20 to 13 when flushing.
2026-03-29T23:34:28.716776+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=90] type 20 to 13 when flushing.
2026-03-29T23:34:28.716797+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=89] type 20 to 13 when flushing.
2026-03-29T23:34:28.716819+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=88] type 20 to 13 when flushing.
2026-03-29T23:34:28.716840+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=87] type 20 to 13 when flushing.
2026-03-29T23:34:28.716861+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=86] type 20 to 13 when flushing.
2026-03-29T23:34:28.716885+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=85] type 20 to 13 when flushing.
2026-03-29T23:34:28.716933+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=84] type 20 to 13 when flushing.
2026-03-29T23:34:28.716981+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=83] type 20 to 13 when flushing.
2026-03-29T23:34:28.717005+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=82] type 20 to 13 when flushing.
2026-03-29T23:34:28.717033+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=81] type 20 to 13 when flushing.
2026-03-29T23:34:28.717055+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=80] type 20 to 13 when flushing.
2026-03-29T23:34:28.717077+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=111] type 20 to 13 when flushing.
2026-03-29T23:34:28.717101+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=110] type 20 to 13 when flushing.
2026-03-29T23:34:28.717140+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=109] type 20 to 13 when flushing.
2026-03-29T23:34:28.717162+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=108] type 20 to 13 when flushing.
2026-03-29T23:34:28.717187+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=107] type 20 to 13 when flushing.
2026-03-29T23:34:28.717209+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=106] type 20 to 13 when flushing.
2026-03-29T23:34:28.717230+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=105] type 20 to 13 when flushing.
2026-03-29T23:34:28.717252+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=104] type 20 to 13 when flushing.
2026-03-29T23:34:28.717272+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=103] type 20 to 13 when flushing.
2026-03-29T23:34:28.717296+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=102] type 20 to 13 when flushing.
2026-03-29T23:34:28.717318+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=101] type 20 to 13 when flushing.
2026-03-29T23:34:28.717339+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=100] type 20 to 13 when flushing.
2026-03-29T23:34:28.717360+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=99] type 20 to 13 when flushing.
2026-03-29T23:34:28.717381+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=98] type 20 to 13 when flushing.
2026-03-29T23:34:28.717402+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=97] type 20 to 13 when flushing.
2026-03-29T23:34:28.717423+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=96] type 20 to 13 when flushing.
2026-03-29T23:34:28.717445+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=127] type 20 to 13 when flushing.
2026-03-29T23:34:28.717469+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=126] type 20 to 13 when flushing.
2026-03-29T23:34:28.717491+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=125] type 20 to 13 when flushing.
2026-03-29T23:34:28.717512+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=124] type 20 to 13 when flushing.
2026-03-29T23:34:28.717533+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=123] type 20 to 13 when flushing.
2026-03-29T23:34:28.717555+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=122] type 20 to 13 when flushing.
2026-03-29T23:34:28.717577+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=121] type 20 to 13 when flushing.
2026-03-29T23:34:28.717598+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=120] type 20 to 13 when flushing.
2026-03-29T23:34:28.717622+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=119] type 20 to 13 when flushing.
2026-03-29T23:34:28.717646+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=118] type 20 to 13 when flushing.
2026-03-29T23:34:28.717667+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=117] type 20 to 13 when flushing.
2026-03-29T23:34:28.717688+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=116] type 20 to 13 when flushing.
2026-03-29T23:34:28.717709+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=115] type 20 to 13 when flushing.
2026-03-29T23:34:28.717730+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=114] type 20 to 13 when flushing.
2026-03-29T23:34:28.717751+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=113] type 20 to 13 when flushing.
2026-03-29T23:34:28.717772+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=112] type 20 to 13 when flushing.
2026-03-29T23:34:28.719528+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=24] type 20 to 13 when flushing.
2026-03-29T23:34:28.719582+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=23] type 20 to 13 when flushing.
2026-03-29T23:34:28.719605+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=22] type 20 to 13 when flushing.
2026-03-29T23:34:28.719627+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=21] type 20 to 13 when flushing.
2026-03-29T23:34:28.719648+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=20] type 20 to 13 when flushing.
2026-03-29T23:34:28.719669+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=19] type 20 to 13 when flushing.
2026-03-29T23:34:28.719693+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=18] type 20 to 13 when flushing.
2026-03-29T23:34:28.719714+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=17] type 20 to 13 when flushing.
2026-03-29T23:34:28.719736+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=16] type 20 to 13 when flushing.
2026-03-29T23:34:28.719758+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=15] type 20 to 13 when flushing.
2026-03-29T23:34:28.719779+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=14] type 20 to 13 when flushing.
2026-03-29T23:34:28.719800+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=13] type 20 to 13 when flushing.
2026-03-29T23:34:28.719821+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=12] type 20 to 13 when flushing.
2026-03-29T23:34:28.719842+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=11] type 20 to 13 when flushing.
2026-03-29T23:34:28.719866+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=10] type 20 to 13 when flushing.
2026-03-29T23:34:28.719887+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=9] type 20 to 13 when flushing.
2026-03-29T23:34:28.719937+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=40] type 20 to 13 when flushing.
2026-03-29T23:34:28.719960+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=39] type 20 to 13 when flushing.
2026-03-29T23:34:28.719982+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=38] type 20 to 13 when flushing.
2026-03-29T23:34:28.720004+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=37] type 20 to 13 when flushing.
2026-03-29T23:34:28.720026+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=36] type 20 to 13 when flushing.
2026-03-29T23:34:28.720055+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=35] type 20 to 13 when flushing.
2026-03-29T23:34:28.720077+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=34] type 20 to 13 when flushing.
2026-03-29T23:34:28.720098+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=33] type 20 to 13 when flushing.
2026-03-29T23:34:28.720139+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=32] type 20 to 13 when flushing.
2026-03-29T23:34:28.720160+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=31] type 20 to 13 when flushing.
2026-03-29T23:34:28.720181+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=30] type 20 to 13 when flushing.
2026-03-29T23:34:28.720203+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=29] type 20 to 13 when flushing.
2026-03-29T23:34:28.720223+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=28] type 20 to 13 when flushing.
2026-03-29T23:34:28.720295+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=27] type 20 to 13 when flushing.
2026-03-29T23:34:28.720321+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=26] type 20 to 13 when flushing.
2026-03-29T23:34:28.720343+08:00 0 [Note] [MY-011950] [InnoDB] Resetting invalid page [page id: space=0, page number=25] type 20 to 13 when flushing.
2026-03-29T23:34:28.735393+08:00 1 [Note] [MY-011924] [InnoDB] Legacy atomic write buffer created
2026-03-29T23:34:28.735446+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2026-03-29T23:34:28.735795+08:00 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2026-03-29T23:34:28.739679+08:00 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2026-03-29T23:34:28.749944+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-03-29T23:34:28.755233+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 1. 128 are now active.
2026-03-29T23:34:28.761722+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in undo tablespace number 2. 128 are now active.
2026-03-29T23:34:28.812079+08:00 1 [Note] [MY-012976] [InnoDB] 8.4.8 started; log sequence number 2399392
2026-03-29T23:34:28.814052+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-03-29T23:34:28.823743+08:00 1 [Note] [MY-011088] [Server] Data dictionary initializing version '80300'.
2026-03-29T23:34:28.992217+08:00 1 [Note] [MY-010007] [Server] Installed data dictionary with version 80300
2026-03-29T23:34:29.081406+08:00 2 [Note] [MY-011019] [Server] Created system views with I_S version 80300.
2026-03-29T23:34:29.509612+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2026-03-29T23:34:29.509675+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2026-03-29T23:34:29.516143+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2026-03-29T23:34:29.516206+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2026-03-29T23:34:29.747678+08:00 0 [Note] [MY-010305] [Server] Auto generated SSL certificates are placed in data directory.
2026-03-29T23:34:29.800503+08:00 0 [Note] [MY-010309] [Server] Auto generated RSA key files through --sha256_password_auto_generate_rsa_keys are placed in data directory.
2026-03-29T23:34:29.801097+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-03-29T23:34:29.801951+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_group_name=cc654ef6-1ec1-11f1-b0af-000c29bb2c79'.
2026-03-29T23:34:29.801972+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_start_on_boot=off'.
2026-03-29T23:34:29.801979+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_local_address=10.10.146.28:33006'.
2026-03-29T23:34:29.801986+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_group_seeds=10.10.146.28:33006,10.10.1.139:33006,10.10.173.84:33006'.
2026-03-29T23:34:29.802046+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_bootstrap_group=off'.
2026-03-29T23:34:29.802058+08:00 0 [Warning] [MY-000067] [Server] unknown variable 'loose-group_replication_member_weight=50'.
2026-03-29T23:34:29.803026+08:00 6 [Note] [MY-011061] [Server] Creating the system database.
2026-03-29T23:34:29.803140+08:00 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: aTko<Zb&h6yy
2026-03-29T23:34:29.803228+08:00 6 [Note] [MY-011061] [Server] Creating the system tables.
2026-03-29T23:34:29.937098+08:00 6 [Note] [MY-011061] [Server] Filling in the system tables, part 1.
2026-03-29T23:34:29.951010+08:00 6 [Note] [MY-011061] [Server] Filling in the system tables, part 2.
2026-03-29T23:34:30.207449+08:00 6 [Note] [MY-011061] [Server] Filling in the mysql.help table.
2026-03-29T23:34:30.323823+08:00 6 [Note] [MY-011061] [Server] Creating the system users for internal usage.
2026-03-29T23:34:30.338219+08:00 6 [Note] [MY-011061] [Server] Creating the sys schema.
2026-03-29T23:34:30.676272+08:00 6 [Note] [MY-010456] [Server] Bootstrapping complete
2026-03-29T23:34:30.696587+08:00 0 [Note] [MY-010067] [Server] Giving 0 client threads a chance to die gracefully
2026-03-29T23:34:30.702789+08:00 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2026-03-29T23:34:30.961610+08:00 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2026-03-29T23:34:30.963071+08:00 0 [Note] [MY-011944] [InnoDB] Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool
2026-03-29T23:34:30.963643+08:00 0 [Note] [MY-011944] [InnoDB] Buffer pool(s) dump completed at 260329 23:34:30
2026-03-29T23:34:31.118005+08:00 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2026-03-29T23:34:31.180489+08:00 0 [Note] [MY-013854] [InnoDB] Bytes written to disk by DBLWR (ON): 36667392
2026-03-29T23:34:31.181446+08:00 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 18919765
2026-03-29T23:34:31.182092+08:00 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2026-03-29T23:34:31.185508+08:00 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
[root@node1 bin]#


分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2026-4-17 19:50 , Processed in 0.251336 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表