mysqld异常0xc0000005

Question

对不起，我的英语不流利。我是MySQL数据库的新手。我在WindowsServer2022数据中心上使用MySQL 8.0.30。我遇到的问题是，MySQL经常崩溃( MySQL服务停止)，总是有相同的错误日志。我试着找出问题的根源，但没有解决。

有关我在同一设备上使用Grafana Web和MySQL的信息，请注意以下规格:处理器Intel(R) Xeon(R) Silver4208 CPU @ 2.10GHz 2.10 GHz已安装RAM 16.0GB (15.6 GB可用)系统型64位操作系统，基于x64的处理器

请给我一个解决这个麻烦的建议。谢谢你之前

下面是错误MySQL日志详细信息：

10:01:25 UTC - mysqld got exception 0xc0000005 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
7ffa8ac5b496    jemalloc.dll!???
7ffa8ac5b918    jemalloc.dll!???
7ffa8ac5ef91    jemalloc.dll!je_realloc()
7ffa82547ddd    libcrypto-1_1-x64.dll!CRYPTO_memcmp()
7ffa8258bcea    libcrypto-1_1-x64.dll!CRYPTO_memcmp()
7ffa8258e7e3    libcrypto-1_1-x64.dll!CRYPTO_memcmp()
7ffa8255956d    libcrypto-1_1-x64.dll!CRYPTO_memcmp()
7ffa8246263c    libcrypto-1_1-x64.dll!CRYPTO_memcmp()
7ffa826092ff    libcrypto-1_1-x64.dll!CRYPTO_memcmp()
7ffab7d47167    ntdll.dll!RtlActivateActivationContextUnsafeFast()
7ffab7d4848a    ntdll.dll!LdrShutdownThread()
7ffab7d28bae    ntdll.dll!RtlExitUserThread()
7ffab5851b8a    KERNELBASE.dll!FreeLibraryAndExitThread()
7ffab55c6c5d    ucrtbase.dll!_recalloc()
7ffab55f3c19    ucrtbase.dll!_endthreadex()
7ff682fc4605    mysqld.exe!?modify_thread_cache_size@Per_thread_connection_handler@@SAXK@Z()
7ff6844987a9    mysqld.exe!?deallocate@?$allocator@V?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@std@@@std@@QEAAXQEAV?$sub_match@V?$_String_const_iterator@V?$_String_val@U?$_Simple_types@D@std@@@std@@@std@@@2@_K@Z() [truncated, 260 bytes total]
7ff68405139c    mysqld.exe!?my_thread_self_setname@@YAXPEBD@Z()
7ffab55c6b4c    ucrtbase.dll!_recalloc()
7ffab7274ed0    KERNEL32.DLL!BaseThreadInitThunk()
7ffab7d9e44b    ntdll.dll!RtlUserThreadStart()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
 information that should help you find out what is causing the crash.

我尝试减少数据的读写，然后增加客户端连接的限制。

Answer 1

每秒速率= RPS

建议考虑您的my.ini mysqld部分，以避免计划外的关闭。

innodb_thread_concurrency=10  # from 33 for reasonable limit for your 16 available total threads 
innodb_redo_log_capacity=96M  # from innodb_log_file_size name and 48M limit

*这是当前名称，而不是每个错误日志推荐的innodb_log_file_size

innodb_buffer_pool_size=8G  # from 124M for about 1/2 available RAM to reduce innodb_data_reads RPS of 31.
read_rnd_buffer_size=32K  from 256K to reduce handler_read_rnd_next RPS of 63,041
thread_cache_size=128  # from 10 to reduce threads_created RPS of ~ 5

请查看个人资料以获取联系信息。您有许多机会通过其他全局变量更改来提高性能。

想听听你的故事，你是如何在96秒的正常运行时间内得到这么多活动的。:)