Bug #109816 MySQL crashed after Out of memory (Needed 1048528 bytes)
Submitted: 27 Jan 7:15 Modified: 27 Jan 10:32
Reporter: Hardik Shah Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.6.19-log OS:Windows
Assigned to: CPU Architecture:Any

[27 Jan 7:15] Hardik Shah
Description:
We are facing Out of memory issue from last few days. Doing research on that said to update some of the values, but we are not sure what values we should put as per our system configurations.

System Details: 

Windows Server 2012 R2 Standard
64 bit OS, x64 based processor
RAM - 24GB

Let us know how can we get solution on the same? Please find below variables.

log-output=FILE
general-log=0
slow-query-log=1
slow_query_log_file="MySQLSlow.log"
long_query_time=10
log-bin=MySQLBinLog
expire_logs_days=15
max_connections=1000
query_cache_size=350M
table_open_cache=2000
tmp_table_size=205M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=379M
key_buffer_size=256M
read_rnd_buffer_size=256K
sort_buffer_size=1024K
innodb_additional_mem_pool_size=48M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=16M
innodb_buffer_pool_size=2304M
innodb_log_file_size=190M
innodb_thread_concurrency=33
innodb_autoextend_increment=64
innodb_buffer_pool_instances=8
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=4M
max_connect_errors=100
open_files_limit=4161
query_cache_type=0
sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K

Please note that we are using INNODB format to store table data. Also note that this server is dedicated to MySQL Database only, so we can increase the variable if needed.

How to repeat:
Not able to find how to repeat, as it gets memory issue at any time
[27 Jan 10:29] MySQL Verification Team
Thank you for the bug report, 5.6 version isn't more a supported server version, please upgrade.

https://www.mysql.com/support/supportedplatforms/database.html
[27 Jan 10:32] Hardik Shah
Hello Team,

We are with this server from last few years and we cannot upgrade it as there are other challenges with it. Can you please help us with solution with retaining existing version?

Thanks
Hardik