Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11.14
-
None
-
None
Description
OOM from various place but very specific size.
2025-10-30 9:05:52 173558 [ERROR] mysqld.exe: Out of memory (Needed 33554400 bytes)
2025-10-30 9:05:53 209775 [ERROR] mysqld.exe: Out of memory (Needed 33554400 bytes)
2025-10-30 9:05:55 159465 [ERROR] mysqld.exe: Out of memory (Needed 33554400 bytes)
2025-10-30 11:51:23 366044 [ERROR] mysqld.exe: Out of memory (Needed 134217696 bytes)
2025-10-30 11:51:24 366030 [ERROR] mysqld.exe: Out of memory (Needed 67108832 bytes)
this is not only one time, very random but frequent. what is a problem?
- innodb_buffer_pool_size enough to hit rate over 99%
- max_heap_table_size = tmp_table_size = 1G that only less than 0.1% of spill rate.
- but many queries has hint SQL_SMALL_RESULT
- Windows 11
- System has 20 or more free space whihc is not reserved.
- uncommited free paging space still over 80GB.
So non sense memory issue.
why it is not use the huge free spaces?
why it's not automatically turn into disk base temp table?
Any workaround?
Attachments
Issue Links
- is duplicated by
-
MDEV-37999 Misleading ERROR message "[ERROR] mysqld.exe: Out of memory (Needed 134217696 bytes)" - no context of causing
-
- Closed
-