Jaspreet

is there a PR for this ?

@arcusfelis Please see below out out from node 1 : ``` (mongooseim@mongooseim-01)1> erlang:memory(). [{total,15377272032}, {processes,420491752}, {processes_used,419461160}, {system,14956780280}, {atom,916433}, {atom_used,888630}, {binary,1481635240}, {code,17795636}, {ets,13434174664}] ``` ``` (mongooseim@mongooseim-01)2> rp(lists:reverse([{Len, case erlang:process_info(TopPid, registered_name) of...

Hi @arcusfelis I further found that pubsub_last_item ets table is taking more then 13 GBS of memory, how can we control it ? I used : `ets:info(pubsub_last_item,memory) * erlang:system_info(wordsize).` Out...

can any buddy help here ?

I was able to reduce the ram by purging pubsub_last_item mnesia data cache (ets storage property) for older then certain days users.

as it create 13 GB of Ram space, do you think shifting it to mysql will slow down mysql ?

Some more details from erlang etop: https://drive.google.com/file/d/1d40FWgw3_wwQjkDYinsNuL5lKoW70Kii/view?usp=sharing

It worked for me in following ways, closing issue. ``` /mongooseim# erl -sname mynod Erlang/OTP 22 [erts-10.4] [source] [64-bit] [smp:2:2] [ds:2:2:10] [async-threads:1] Eshell V10.4 (abort with ^G) (mynod@mongooseim-c01)1> erlang:set_cookie(node(), ejabberd)....

https://drive.google.com/file/d/1d40FWgw3_wwQjkDYinsNuL5lKoW70Kii/view?usp=sharing I found mysql is called more and using more Reds in production and hence more CPU. How can I find out which mod is calling more queries?