Hi Roughnecks,

Just curious but how much RAM does your VPS have? 190MB is not much but if you haven't got a lot of RAM you may want to lower some buffers... doesn't look like a bug to me.

Can you also post the output of
 ps -o pid,vsz,rss,comm `pgrep mariadb`

Because imho VSZ alone is not really relevant

Also if you could post the output of following SQL queries:

show variables like 'innodb_buffer_pool_size';
show global status like 'Innodb_buffer_pool_bytes_data';

Best
GL



Le lun. 11 sept. 2023 à 17:04, roughnecks via discuss <discuss@lists.mariadb.org> a écrit :
Il 10/09/2023 19:58, roughnecks via discuss ha scritto:

> Also, running the following command to check swap:
>
> for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{
> print ""}' $file; done | sort -k 2 -n -r | less
>
> mariadbd is currently the first entry:
>
> mariadbd 90624 kB

Just now:

mariadbd 190124 kB

I think it's normal that it swaps because my vps is a bit overloaded,
but that also implies a high memory usage by mariadb.

Do you still want me to open a bug report?

_______________________________________________
discuss mailing list -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-leave@lists.mariadb.org