level 3
shangneng77
楼主
MySQL服务用着用着会崩，然后一用mysqldump备份的话也会崩溃,用navicat17新建备份的话也会崩溃。环境win11 24H2,运行内存64G,MySQL8.4.6(原先8.4.3也会崩溃)。检查过表显示无损坏，内存和磁盘也都用windows命令查过了，没问题。
以下是windows的事件查看器相关信息
故障存储段 1280987293198744111，类型 4 事件名称: APPCRASH 响应: 不可用 Cab ID: 0 问题签名: P1: mysqld.exe P2: 8.4.6.0 P3: 686fee22 P4: StackHash_64c3 P5: 10.0.26100.4768 P6: 95c61958 P7: c0000374 P8: PCH_5D_FROM_ntdll+0x0000000000163404 P9: P10: 附加文件: \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.0934017a-238c-49f0-ba7e-b6326deeaecc.tmp.mdmp \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.cb7df394-f04e-483e-8b0b-cf6a57a5ea1b.tmp.WERInternalMetadata.xml WPR_initiated_DiagTrackMiniLogger_OneTrace_User_Logger_20250826_1_EC_0_inject.etl \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.156fe4f0-adf8-48ac-9bfb-5ba077cdb67c.tmp.etl WPR_initiated_DiagTrackMiniLogger_WPR System Collector_inject.etl \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.d843671b-3012-4346-b70e-56d9c056b4e5.tmp.etl \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.7aba7c37-ff80-40b2-959c-43397bd3437b.tmp.csv \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.834fcea7-7d69-4185-b3c2-cbb7ac51ab1d.tmp.txt \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.8bc321b5-a752-47f7-b753-
18305343588
a.tmp.xml 可在此处获取这些文件: \\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_mysqld.exe_6632e89f294ceee7a65e93ed673864f0a286d162_dc26666f_152e7661-f9e1-42ac-83f9-c70fadd14d72 分析符号: 重新检查解决方案: 0 报告 ID: d2264a2e-0def-400b-a9ad-5ca51767f963 报告状态: 268435456 哈希存储段: c761d8616b69900571c6fb27fce67a2f Cab GUID: 0
出错应用程序名称： mysqld.exe，版本： 8.4.6.0，时间戳： 0x686fee22 出错模块名称： ntdll.dll， 版本： 10.0.26100.4768，时间戳： 0x95c61958 异常代码： 0xc0000374 错误偏移： 0x000000000011dc45 出错进程 ID： 0x8494 出错应用程序开始时间： 0x1DC17CFFB03AFB6 Faulting 应用程序路径： D:\snerp\mysql-8.4.6-winx64\bin\mysqld.exe Faulting 模块路径： C:\WINDOWS\SYSTEM32\ntdll.dll Report ID： d2264a2e-0def-400b-a9ad-5ca51767f963 Faulting 包全名： Faulting 程序包相对应用程序 ID： 个
MySQL配置文件如下:
[client]
default-character-set = utf8mb4
port = 3306
[mysqld]
basedir = D:/snerp/mysql-8.4.6-winx64
datadir = D:/snerp/mysql-8.4.6-winx64/Data
tmpdir = D:/mysql_tmp
port = 3306
server_id = 1
# 内存优化
innodb_buffer_pool_size = 10GB
innodb_buffer_pool_chunk_size = 256M
sort_buffer_size = 2M
read_buffer_size = 1M
join_buffer_size = 2M
# 网络与连接
max_connections = 300
thread_cache_size = 50
table_open_cache_instances = 16
max_connect_errors = 100
wait_timeout = 600
interactive_timeout = 600
max_allowed_packet = 256M
skip-name-resolve
# 安全设置
local_infile = OFF
secure_file_priv = "D:/snerp/mysql-8.4.6-winx64/upload"
# InnoDB设置
innodb_redo_log_capacity = 2G
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = ON
innodb_open_files = 4000
innodb_io_capacity = 1000
innodb_io_capacity_max = 2000
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_doublewrite = ON
innodb_checksum_algorithm = crc32
innodb_parallel_read_threads = 4
# 临时表优化
tmp_table_size = 256M
max_heap_table_size = 256M
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:20G
# 文件与表缓存
table_open_cache = 4000
# 二进制日志
log_bin = D:/snerp/mysql-8.4.6-winx64/logs/mysql-bin
binlog_expire_logs_seconds = 604800
# 慢查询日志
slow_query_log = 1
slow_query_log_file = D:/snerp/mysql-8.4.6-winx64/logs/mysql-slow.log
long_query_time = 10
log_queries_not_using_indexes = OFF
log_error = D:/snerp/mysql-8.4.6-winx64/logs/mysql-error.log
log_output = FILE
# Windows特定
named_pipe = ON
shared_memory = ON
# 默认设置
default_storage_engine = INNODB
character_set_server = utf8mb4
collation_server = utf8mb4_0900_ai_ci
transaction_isolation = REPEATABLE-READ
group_concat_max_len = 16M
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
2025年08月28日 10点08分
1
以下是windows的事件查看器相关信息
故障存储段 1280987293198744111，类型 4 事件名称: APPCRASH 响应: 不可用 Cab ID: 0 问题签名: P1: mysqld.exe P2: 8.4.6.0 P3: 686fee22 P4: StackHash_64c3 P5: 10.0.26100.4768 P6: 95c61958 P7: c0000374 P8: PCH_5D_FROM_ntdll+0x0000000000163404 P9: P10: 附加文件: \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.0934017a-238c-49f0-ba7e-b6326deeaecc.tmp.mdmp \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.cb7df394-f04e-483e-8b0b-cf6a57a5ea1b.tmp.WERInternalMetadata.xml WPR_initiated_DiagTrackMiniLogger_OneTrace_User_Logger_20250826_1_EC_0_inject.etl \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.156fe4f0-adf8-48ac-9bfb-5ba077cdb67c.tmp.etl WPR_initiated_DiagTrackMiniLogger_WPR System Collector_inject.etl \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.d843671b-3012-4346-b70e-56d9c056b4e5.tmp.etl \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.7aba7c37-ff80-40b2-959c-43397bd3437b.tmp.csv \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.834fcea7-7d69-4185-b3c2-cbb7ac51ab1d.tmp.txt \\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.8bc321b5-a752-47f7-b753-
18305343588
a.tmp.xml 可在此处获取这些文件: \\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_mysqld.exe_6632e89f294ceee7a65e93ed673864f0a286d162_dc26666f_152e7661-f9e1-42ac-83f9-c70fadd14d72 分析符号: 重新检查解决方案: 0 报告 ID: d2264a2e-0def-400b-a9ad-5ca51767f963 报告状态: 268435456 哈希存储段: c761d8616b69900571c6fb27fce67a2f Cab GUID: 0
出错应用程序名称： mysqld.exe，版本： 8.4.6.0，时间戳： 0x686fee22 出错模块名称： ntdll.dll， 版本： 10.0.26100.4768，时间戳： 0x95c61958 异常代码： 0xc0000374 错误偏移： 0x000000000011dc45 出错进程 ID： 0x8494 出错应用程序开始时间： 0x1DC17CFFB03AFB6 Faulting 应用程序路径： D:\snerp\mysql-8.4.6-winx64\bin\mysqld.exe Faulting 模块路径： C:\WINDOWS\SYSTEM32\ntdll.dll Report ID： d2264a2e-0def-400b-a9ad-5ca51767f963 Faulting 包全名： Faulting 程序包相对应用程序 ID： 个
MySQL配置文件如下:
[client]
default-character-set = utf8mb4
port = 3306
[mysqld]
basedir = D:/snerp/mysql-8.4.6-winx64
datadir = D:/snerp/mysql-8.4.6-winx64/Data
tmpdir = D:/mysql_tmp
port = 3306
server_id = 1
# 内存优化
innodb_buffer_pool_size = 10GB
innodb_buffer_pool_chunk_size = 256M
sort_buffer_size = 2M
read_buffer_size = 1M
join_buffer_size = 2M
# 网络与连接
max_connections = 300
thread_cache_size = 50
table_open_cache_instances = 16
max_connect_errors = 100
wait_timeout = 600
interactive_timeout = 600
max_allowed_packet = 256M
skip-name-resolve
# 安全设置
local_infile = OFF
secure_file_priv = "D:/snerp/mysql-8.4.6-winx64/upload"
# InnoDB设置
innodb_redo_log_capacity = 2G
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = ON
innodb_open_files = 4000
innodb_io_capacity = 1000
innodb_io_capacity_max = 2000
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_doublewrite = ON
innodb_checksum_algorithm = crc32
innodb_parallel_read_threads = 4
# 临时表优化
tmp_table_size = 256M
max_heap_table_size = 256M
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:20G
# 文件与表缓存
table_open_cache = 4000
# 二进制日志
log_bin = D:/snerp/mysql-8.4.6-winx64/logs/mysql-bin
binlog_expire_logs_seconds = 604800
# 慢查询日志
slow_query_log = 1
slow_query_log_file = D:/snerp/mysql-8.4.6-winx64/logs/mysql-slow.log
long_query_time = 10
log_queries_not_using_indexes = OFF
log_error = D:/snerp/mysql-8.4.6-winx64/logs/mysql-error.log
log_output = FILE
# Windows特定
named_pipe = ON
shared_memory = ON
# 默认设置
default_storage_engine = INNODB
character_set_server = utf8mb4
collation_server = utf8mb4_0900_ai_ci
transaction_isolation = REPEATABLE-READ
group_concat_max_len = 16M
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION