2

The MySQL 8.0.15 the server runs after a while [~1 week] out of memory.

  • SLES 12.4
  • MySQL 8.0.15
  • 5 GB RAM [before the VM ran with 3 GB for months without any problem].
  • 24 cores

Running

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(event_name, '/', 2), '/', -1 )  AS Type,
   ROUND(SUM(CURRENT_NUMBER_OF_BYTES_USED)/1024/1024, 2) as MB_CURRENTLY_USED
FROM performance_schema.memory_summary_global_by_event_name
GROUP BY Type 
HAVING MB_CURRENTLY_USED > 0;

returns

Type                MB_CURRENTLY_USED
-------------------------------------
innodb              2232.21
myisam              1.35
mysys               257.04
performance_schema  442.11
sql                 24.17
temptable           96.00
vio                 0.05

Full dump of /etc/my.cnf:

default-storage-engine  = InnoDB
interactive_timeout     = 31536000
key_buffer_size         = 256M
log_timestamps          = SYSTEM
max_allowed_packet      = 10M
max_connections         = 500
myisam_sort_buffer_size = 128M
net_buffer_length       = 8K
read_buffer_size        = 32M
read_rnd_buffer_size    = 32M
sort_buffer_size        = 256M
sql_mode                = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
table_open_cache        = 1k
thread_cache_size       = 500
tmp_table_size          = 128M
wait_timeout            = 31536000
innodb_lock_wait_timeout = 10
disable_log_bin
innodb_thread_concurrency = 64
innodb_buffer_pool_size = 2088996864
character-set-server          = UTF8MB4
default_authentication_plugin = mysql_native_password
init_file = /application/scripts/LogServerStart.sql
skip-federated
server-id = 1
general-log = false
general_log_file = /var/log/mysql/mysqld.general.log
long_query_time = 1
slow_query_log = true
slow_query_log_file = /var/log/mysql/mysqld.slow.query.log

What changed:

  • Update to MySQL 8.0.15.
  • Converted an ~800MB database from MyISAM to InnoDB.
  • Added innodb_buffer_pool_size = 2088996864 to /etc/my.cnf. Before this setting didn't exist.
  • Increased the core count from 8 to 24.

Any idea what the problem can be?


Important:

According to top the occupied memory by MySQL increases from hour to hour until it crashes.


Should you need further data please request them in the comment.


This is from /var/log/messages:

kernel:  mysqld invoked oom-killer: gfp_mask=0x14200ca(GFP_HIGHUSER_MOVABLE), nodemask=(null),  order=0, oom_score_adj=0
kernel:  mysqld cpuset=/ mems_allowed=0
kernel:  CPU: 3 PID: 2223 Comm: mysqld Not tainted 4.12.14-95.6-default #1 SLE12-SP4 (unreleased)
kernel:  Call Trace:
kernel:   dump_stack+0x5a/0x75
kernel:   dump_header+0x9c/0x238
kernel:   ? _raw_spin_unlock_irqrestore+0x14/0x20
kernel:   ? do_try_to_free_pages+0x2bf/0x350
kernel:   oom_kill_process+0x228/0x3f0
kernel:   ? has_capability_noaudit+0x1a/0x20
kernel:   ? oom_badness+0xf0/0x170
kernel:   out_of_memory+0x100/0x490
kernel:   __alloc_pages_slowpath+0x7e5/0xa0d
kernel:   __alloc_pages_nodemask+0x1e9/0x210
kernel:   alloc_pages_current+0x70/0xf0
kernel:   filemap_fault+0x2b0/0x600
kernel:   ? filemap_map_pages+0x180/0x3f0
kernel:   ext4_filemap_fault+0x2c/0x40 [ext4]
kernel:   __do_fault+0x20/0x80
kernel:   __handle_mm_fault+0xc3e/0xef0
kernel:   handle_mm_fault+0xc4/0x1d0
kernel:   __do_page_fault+0x1f3/0x4c0
kernel:   do_page_fault+0x2b/0x70
kernel:   ? do_syscall_64+0x9a/0x150
kernel:   ? page_fault+0x2f/0x50
kernel:   page_fault+0x45/0x50
kernel:  RIP: 5000:0x100
kernel:  RSP: fc31e860:00007f68c6bbd9b0 EFLAGS: 00000000
kernel:  Mem-Info:
kernel:  active_anon:814380 inactive_anon:162908 isolated_anon:0
kernel:   active_file:194 inactive_file:224 isolated_file:0
kernel:   unevictable:20 dirty:0 writeback:0 unstable:0
kernel:   slab_reclaimable:3990 slab_unreclaimable:8429
kernel:   mapped:366 shmem:831 pagetables:3690 bounce:0
kernel:   free:5915 free_pcp:3490 free_cma:0
kernel:  Node 0 active_anon:3257520kB inactive_anon:651632kB active_file:776kB inactive_file:896kB unevictable:80kB isolated(anon):0kB isolated(file):0kB mapped:1464kB dirty:0kB writeback:0kB shmem:3324kB shmem_thp: 0kB shmem_pmdmapped: 0kB anon_thp: 0kB writeback_tmp:0kB unstable:0kB all_unreclaimable? no
kernel:  Node 0 DMA free:15812kB min:28kB low:40kB high:52kB active_anon:36kB inactive_anon:56kB active_file:0kB inactive_file:0kB unevictable:0kB writepending:0kB present:15996kB managed:15912kB mlocked:0kB slab_reclaimable:0kB slab_unreclaimable:0kB kernel_stack:0kB pagetables:0kB bounce:0kB free_pcp:0kB local_pcp:

kernel:  lowmem_reserve[]: 0 3946 3946 3946 3946
kernel:  Node 0 DMA32 free:7848kB min:8024kB low:12064kB high:16104kB active_anon:3257484kB inactive_anon:651576kB active_file:744kB inactive_file:644kB unevictable:80kB writepending:0kB present:4177920kB managed:4061140kB mlocked:80kB slab_reclaimable:15960kB slab_unreclaimable:33716kB kernel_stack:10608kB pagetable
:1296kB free_cma:0kB
kernel:  lowmem_reserve[]: 0 0 0 0 0
kernel:  Node 0 DMA: 3*4kB (M) 1*8kB (M) 1*16kB (M) 1*32kB (U) 2*64kB (U) 2*128kB (UM) 2*256kB (UM) 1*512kB (M) 2*1024kB (UM) 0*2048kB 3*4096kB (M) = 15812kB
kernel:  Node 0 DMA32: 1530*4kB (UMH) 10*8kB (UH) 2*16kB (H) 6*32kB (H) 4*64kB (H) 1*128kB (H) 1*256kB (H) 2*512kB (H) 0*1024kB 0*2048kB 0*4096kB = 8088kB
kernel:  3756 total pagecache pages
kernel:  2379 pages in swap cache
kernel:  Swap cache stats: add 612001, delete 609619, find 5078185/5164442
kernel:  Free swap  = 0kB
kernel:  Total swap = 1058812kB
kernel:  1048479 pages RAM
kernel:  0 pages HighMem/MovableOnly
kernel:  29216 pages reserved
kernel:  0 pages hwpoisoned
kernel:  [ pid ]   uid  tgid total_vm      rss nr_ptes nr_pmds swapents oom_score_adj name
....
kernel:  [ 1853]    60  1853  4026772   934170    2705      18   247870             0 mysqld
kernel:  Out of memory: Kill process 1853 (mysqld) score 922 or sacrifice child
kernel:  Killed process 1853 (mysqld) total-vm:16107088kB, anon-rss:3736676kB, file-rss:0kB, shmem-rss:4kB
kernel:  oom_reaper: reaped process 1853 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB
systemd: mysql.service: Main process exited, code=killed, status=9/KILL
systemd: mysql.service: Unit entered failed state.
systemd: mysql.service: Failed with result 'signal'.
systemd: mysql.service: Service RestartSec=100ms expired, scheduling restart.
systemd: Stopped MySQL Server.
systemd: Starting MySQL Server... 

Updated with requested output:

SHOW GLOBAL STATUS LIKE '%opened%'

Opened_files              22667 
Opened_table_definitions  260   
Opened_tables             129187    

ulimit -a

core file size          (blocks, -c) unlimited
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 19864
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 19864
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

SHOW GLOBAL STATUS LIKE '%open%';

Variable_name               Value
Com_ha_open                 0
Com_show_open_tables        0
Innodb_num_open_files       99
Mysqlx_cursor_open          0
Mysqlx_expect_open          0
Open_files                  411
Open_streams                0
Open_table_definitions      199
Open_tables                 1024
Opened_files                26137
Opened_table_definitions    265
Opened_tables               148476
Slave_open_temp_tables      0
Table_open_cache_hits       3256299
Table_open_cache_misses     148473
Table_open_cache_overflows  147262

SELECT @@thread_handling;

returns

one-thread-per-connection

As requested the dump from the 2nd crash - mysqld was occupying more than 92% from 5GB memory. It grew again constantly within 18 days from 20%.

Mar 19 20:00:51 kernel: memcached invoked oom-killer: gfp_mask=0x14200ca(GFP_HIGHUSER_MOVABLE), nodemask=(null),  order=0, oom_score_adj=0
Mar 19 20:00:51 kernel: memcached cpuset=/ mems_allowed=0
Mar 19 20:00:51 kernel: CPU: 0 PID: 1523 Comm: memcached Not tainted 4.12.14-95.6-default #1 SLE12-SP4 (unreleased)
Mar 19 20:00:51 kernel: Call Trace:
Mar 19 20:00:51 kernel:  dump_stack+0x5a/0x75
Mar 19 20:00:51 kernel:  dump_header+0x9c/0x238
Mar 19 20:00:51 kernel:  ? _raw_spin_unlock_irqrestore+0x14/0x20
Mar 19 20:00:51 kernel:  ? do_try_to_free_pages+0x2bf/0x350
Mar 19 20:00:51 kernel:  oom_kill_process+0x228/0x3f0
Mar 19 20:00:51 kernel:  ? has_capability_noaudit+0x1a/0x20
Mar 19 20:00:51 kernel:  ? oom_badness+0xf0/0x170
Mar 19 20:00:51 kernel:  out_of_memory+0x100/0x490
Mar 19 20:00:51 kernel:  __alloc_pages_slowpath+0x7e5/0xa0d
Mar 19 20:00:51 kernel:  __alloc_pages_nodemask+0x1e9/0x210
Mar 19 20:00:51 kernel:  alloc_pages_current+0x70/0xf0
Mar 19 20:00:51 kernel:  filemap_fault+0x2b0/0x600
Mar 19 20:00:51 kernel:  ? filemap_map_pages+0xfb/0x3f0
Mar 19 20:00:51 kernel:  ext4_filemap_fault+0x2c/0x40 [ext4]
Mar 19 20:00:51 kernel:  __do_fault+0x20/0x80
Mar 19 20:00:51 kernel:  __handle_mm_fault+0xc3e/0xef0
Mar 19 20:00:51 kernel:  handle_mm_fault+0xc4/0x1d0
Mar 19 20:00:51 kernel:  __do_page_fault+0x1f3/0x4c0
Mar 19 20:00:51 kernel:  do_page_fault+0x2b/0x70
Mar 19 20:00:51 kernel:  ? do_syscall_64+0x9a/0x150
Mar 19 20:00:51 kernel:  ? page_fault+0x2f/0x50
Mar 19 20:00:51 kernel:  page_fault+0x45/0x50
Mar 19 20:00:51 kernel: RIP: db6f:0x7f930bd03f20
Mar 19 20:00:51 kernel: RSP: 08d0:0000000000000000 EFLAGS: 000186a0
Mar 19 20:00:51 kernel: Mem-Info:
Mar 19 20:00:51 kernel: active_anon:1049428 inactive_anon:174901 isolated_anon:0
                                       active_file:95 inactive_file:80 isolated_file:0
                                       unevictable:20 dirty:7 writeback:0 unstable:0
                                       slab_reclaimable:4009 slab_unreclaimable:8939
                                       mapped:14 shmem:40 pagetables:4623 bounce:0
                                       free:7196 free_pcp:9020 free_cma:0
Mar 19 20:00:51 kernel: Node 0 active_anon:4197712kB inactive_anon:699604kB active_file:380kB inactive_file:320kB unevictable:80kB isolated(anon):0kB isolated(file):0kB mapped:56kB dirty:28kB writeback:0kB shmem:160kB shmem_thp: 0kB shmem_pmdmapped: 0kB anon_thp: 0kB writeback_tmp:0kB unstable:0kB all_unreclaimable? no
Mar 19 20:00:51 kernel: Node 0 DMA free:15912kB min:28kB low:40kB high:52kB active_anon:0kB inactive_anon:0kB active_file:0kB inactive_file:0kB unevictable:0kB writepending:0kB present:15996kB managed:15912kB mlocked:0kB slab_reclaimable:0kB slab_unreclaimable:0kB kernel_stack:0kB pagetables:0kB bounce:0kB free_pcp:0kB local_pcp:0kB free_cma:0kB
Mar 19 20:00:51 kernel: lowmem_reserve[]: 0 4031 4950 4950 4950
Mar 19 20:00:51 kernel: Node 0 DMA32 free:10896kB min:7320kB low:11448kB high:15576kB active_anon:3411768kB inactive_anon:649512kB active_file:32kB inactive_file:376kB unevictable:0kB writepending:20kB present:4177920kB managed:4147876kB mlocked:0kB slab_reclaimable:2544kB slab_unreclaimable:10912kB kernel_stack:5856kB pagetables:13608kB bounce:0kB free_pcp:21796k
Mar 19 20:00:51 kernel: lowmem_reserve[]: 0 0 919 919 919
Mar 19 20:00:51 kernel: Node 0 Normal free:1976kB min:1668kB low:2608kB high:3548kB active_anon:785904kB inactive_anon:50092kB active_file:256kB inactive_file:340kB unevictable:80kB writepending:8kB present:1048576kB managed:941316kB mlocked:80kB slab_reclaimable:13492kB slab_unreclaimable:24844kB kernel_stack:4856kB pagetables:4884kB bounce:0kB free_pcp:14284kB l
Mar 19 20:00:51 kernel: lowmem_reserve[]: 0 0 0 0 0
Mar 19 20:00:51 kernel: Node 0 DMA: 0*4kB 1*8kB (U) 0*16kB 1*32kB (U) 2*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15912kB
Mar 19 20:00:51 kernel: Node 0 DMA32: 2316*4kB (UMEH) 191*8kB (UH) 7*16kB (H) 1*32kB (H) 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 10936kB
Mar 19 20:00:51 kernel: Node 0 Normal: 8*4kB (H) 9*8kB (H) 9*16kB (H) 6*32kB (H) 6*64kB (H) 5*128kB (H) 2*256kB (H) 0*512kB 0*1024kB 0*2048kB 0*4096kB = 1976kB
Mar 19 20:00:51 kernel: 6161 total pagecache pages
Mar 19 20:00:51 kernel: 5693 pages in swap cache
Mar 19 20:00:51 kernel: Swap cache stats: add 546240, delete 540547, find 3966912/4032930
Mar 19 20:00:51 kernel: Free swap  = 0kB
Mar 19 20:00:51 kernel: Total swap = 1058812kB
Mar 19 20:00:51 kernel: 1310623 pages RAM
Mar 19 20:00:51 kernel: 0 pages HighMem/MovableOnly
Mar 19 20:00:51 kernel: 34347 pages reserved
Mar 19 20:00:51 kernel: 0 pages hwpoisoned
Mar 19 20:00:51 kernel: [ pid ]   uid  tgid total_vm      rss nr_ptes nr_pmds swapents oom_score_adj name
Mar 19 20:00:51 kernel: [  574]     0   574     3008        2      11       3      780             0 haveged
Mar 19 20:00:51 kernel: [  925]   499   925    12037      173      27       3       52          -900 dbus-daemon
Mar 19 20:00:51 kernel: [  954]     0   954     4912       82      15       3       76             0 irqbalance
Mar 19 20:00:51 kernel: [  958]     0   958     7469        0      21       3      268             0 wickedd-auto4
Mar 19 20:00:51 kernel: [  962]     0   962     7469        0      19       3      268             0 wickedd-dhcp6
Mar 19 20:00:51 kernel: [  964]     0   964     7470        0      20       3      267             0 wickedd-dhcp4
Mar 19 20:00:51 kernel: [  968]     0   968     5271      186      15       3       49             0 xe-daemon
Mar 19 20:00:51 kernel: [  970]     0   970    83945      118      37       4      183             0 rsyslogd
Mar 19 20:00:51 kernel: [  971]   496   971   201189      111      44       4       27             0 nscd
Mar 19 20:00:51 kernel: [  986]     0   986     7503        1      21       3      296             0 wickedd
Mar 19 20:00:51 kernel: [  996]     0   996     7476        0      20       3      273             0 wickedd-nanny
Mar 19 20:00:51 kernel: [ 1511]     0  1511     6158        2      17       3      100             0 rsyncd
Mar 19 20:00:51 kernel: [ 1517]     0  1517   120941    36016      99       4     5382             0 memcached
Mar 19 20:00:51 kernel: [ 1551]     0  1551    16177       39      35       3      143         -1000 sshd
Mar 19 20:00:51 kernel: [ 1561]    74  1561     5043       38      13       3      105             0 ntpd
Mar 19 20:00:51 kernel: [ 1563]    74  1563     5042        6      12       3      135             0 ntpd
Mar 19 20:00:51 kernel: [ 1581]     0  1581     1214        1       8       3       24             0 agetty
Mar 19 20:00:51 kernel: [ 1583]     0  1583     1214        2       8       3       24             0 agetty
Mar 19 20:00:51 kernel: [ 1605]     0  1605    51031       94      35       3       88             0 gdm
Mar 19 20:00:51 kernel: [ 1615]     0  1615    67993      127      35       3       67             0 accounts-daemon
Mar 19 20:00:51 kernel: [ 1619]   497  1619   129210      108      49       4      836             0 polkitd
Mar 19 20:00:51 kernel: [ 1842]     0  1842     8545       32      18       3       75             0 master
Mar 19 20:00:51 kernel: [ 1844]    51  1844     9111       28      22       3      139             0 qmgr
Mar 19 20:00:51 kernel: [ 1857]     0  1857     4753       87      14       3       72             0 cron
Mar 19 20:00:51 kernel: [ 1861]     0  1861    26782       41      55       4      237             0 sshd
Mar 19 20:00:51 kernel: [ 1864]     0  1864    10284       80      25       3      115             0 systemd
Mar 19 20:00:51 kernel: [ 1865]     0  1865    22560       41      46       3      383             0 (sd-pam)
Mar 19 20:00:51 kernel: [ 1868]     0  1868     3789      156      13       3      339             0 bash
Mar 19 20:00:51 kernel: [ 2003]     0  2003    26782       38      56       3      238             0 sshd
Mar 19 20:00:51 kernel: [ 2006]     0  2006     3789      201      12       3      299             0 bash
Mar 19 20:00:51 kernel: [ 2980]     0  2980    26782       38      54       3      236             0 sshd
Mar 19 20:00:51 kernel: [ 2983]     0  2983     3846      326      11       3      234             0 bash
Mar 19 20:00:51 kernel: [ 3037]    60  3037  4032849  1169400    3459      18   252088             0 mysqld
Mar 19 20:00:51 kernel: [ 3511]     0  3511    14949       40      33       3       39             0 systemd-journal
Mar 19 20:00:51 kernel: [24899]     0 24899    19216     1907      41       3     3829             0 miniserv.pl
Mar 19 20:00:51 kernel: [23754]     0 23754     5567       69      16       3        1             0 systemd-logind
Mar 19 20:00:51 kernel: [23837]     0 23837     9978      175      20       3        5         -1000 systemd-udevd
Mar 19 20:00:51 kernel: [17661]     0 17661     1162       24       7       3        0             0 tail
Mar 19 20:00:51 kernel: [32114]     0 32114     1162       25       7       3        0             0 tail
Mar 19 20:00:51 kernel: [ 6873]    51  6873     9008      105      21       3        0             0 pickup
Mar 19 20:00:51 kernel: [ 9938]     0  9938     1153       20       8       3        0             0 sleep
Mar 19 20:00:51 kernel: [ 9939]     0  9939    21793     5703      46       3     2617             0 /usr/libexec/we
Mar 19 20:00:51 kernel: Out of memory: Kill process 3037 (mysqld) score 924 or sacrifice child
Mar 19 20:00:51 kernel: Killed process 3037 (mysqld) total-vm:16131396kB, anon-rss:4677700kB, file-rss:0kB, shmem-rss:4kB
Mar 19 20:00:55 kernel: oom_reaper: reaped process 3037 (mysqld), now anon-rss:0kB, file-rss:0kB, shmem-rss:0kB
Mar 19 20:00:55 systemd[1]: mysql.service: Main process exited, code=killed, status=9/KILL
Mar 19 20:00:55 systemd[1]: mysql.service: Unit entered failed state.
Mar 19 20:00:55 systemd[1]: mysql.service: Failed with result 'signal'.
Mar 19 20:00:55 systemd[1]: mysql.service: Service RestartSec=100ms expired, scheduling restart.
  • Could your post from OS command line TEXT results of ulimit -a so we know how many Open File handles are tolerated? Thanks – Wilson Hauck Mar 3 at 0:22
  • Please post results of SHOW GLOBAL STATUS LIKE '%open%'; also. We can see that Open files is causing thrashing of reopening tables, definitions, files. With this requested info, will be better able to advise to reduce thrashing. Have any of earlier suggestions been applied? Thanks – Wilson Hauck Mar 4 at 10:34
  • With read_rnd_buffer_size at 32M, the server is being asked to work 120 times harder to deliver data than necessary. Are you familar with SET GLOBAL variable_name=value for DYNAMIC GLOBAL variables? If so, you could relive this server stress NOW and not be required to stop/start anything. All of my suggestions are Dynamic variables at this time. – Wilson Hauck Mar 4 at 10:46
  • Wonderful. Test your app and confirm response time is better, please. After SET GLOBAL, the new values are applied to CONNECTIONS made AFTER the SET GLOBAL is in place. Depending on your user connection cycles, it may be a few minutes before CONNECTIONS have rotated to new connections and the improvement will likely be observed. – Wilson Hauck Mar 4 at 11:00
  • 1
    Let us continue this discussion in chat. – Al Bundy Mar 4 at 11:21
0

Rate Per Second=RPS - Suggestions for your my.cnf [mysqld] section

read_buffer_size=512K  # from 32M for this per connection RAM request
read_rnd_buffer_size=256K  # from 32M to reduce handler_read_rnd_next RPS
sort_buffer_size=4M  # from 256M for this per connection RAM request
thread_cache_size=100  # from 500 to follow advice of 8.0 refman to cap at 100
# innodb_lock_wait_timeout=10  lead with # to allow default of 50 seconds
innodb_thread_concurrency=20  # from 64 to limit and allow 4 cores to be used by other apps per refman v 8.0

Please view my profile, Network profile.

  • 1
    Somehow I suspect MySQL is having a bug. I am running each hour a cron job which gets the occupied memory by MySQL in percent. It grows. Only now over the weekend, when the application is in standby mode, it doesn't. I bet Sunday night [CET] - when the program starts to run again - the percentage will also start to increase and I expect it to crash this week. I am already at 83% on a 5GB VM where nothing else is running [apart from memcached with 256 MB RAM. – Al Bundy Mar 3 at 12:19
  • 1
    I am studying carefully each of your suggestion before I apply them. For example innodb_lock_wait_timeout I set by purpose to 10 seconds in order to see immediately a wrong designed command. I had these massive problems which I could have fixed earlier when I had since the beginning 10 seconds. Also, innodb_thread_concurrency I tested extensively. The best performance I achieve with 64 - there is no need for keeping cores for other programs. – Al Bundy Mar 3 at 20:47
  • 1
    The occupied memory is growing and growing. When it continues like this [at the moment ~88%] then till end of the week the server should crash again. I think your suggestion definitely make sense and I will implement them but my feeling is that they cannot prevent the growing memory demand. I am living with the old settings for years with less server memory. I never ran into this issue and the server was running for months - since I updated to 8.0.15 it immediately started. I am convinced there is a bug in the version. – Al Bundy Mar 5 at 11:32
  • 1
    I could but I don't bother. Your suggestions should relax the situation. Once the next expected crash requires a MySQL Server start the new settings [while I keep almost the default settings] become active. Did you check the change log? 8.0.15 was released few days after 8.0.14 due to a problem :-) – Al Bundy Mar 5 at 11:43
  • 1
    The MySQL server was running in this constellation for more than 5 [in words FIVE] years even with LESS memory. Since I upgraded to MySQL 8.0.15 the problems immediately started. I do NOT consider my settings wrong. MySQL 8.0.15 has definitely somewhere a memory leak and I hope it gets fixed with one of the next updates. I am not going to change/touch the server when it worked for 60 months. I am now only patient and it will be fixed for sure. See this - Now, it is fixed – Al Bundy Mar 19 at 20:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.