Hello, first time here :) I've got a single db for roundcube and yet after every couple days my swap for mariadb reaches 200MB and over. To be noted that I'm the sole roundcube's user and that even myself prefer using thunderbird, so I only access roundcube from time to time. Is this normal? I'm running debian stable, upgraded from oldstable when it came out and I remember that in bullseye ram usage was just 50MB or so. Thanks, have a nice day. -- roughnecks
Hi, roughnecks, What MariaDB version is it? there were few bugs like that fixed recently. On Sep 08, roughnecks via discuss wrote:
Hello,
first time here :)
I've got a single db for roundcube and yet after every couple days my swap for mariadb reaches 200MB and over.
To be noted that I'm the sole roundcube's user and that even myself prefer using thunderbird, so I only access roundcube from time to time.
Is this normal?
I'm running debian stable, upgraded from oldstable when it came out and I remember that in bullseye ram usage was just 50MB or so.
Thanks, have a nice day.
-- roughnecks
Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
Il 08/09/2023 17:50, Sergei Golubchik via discuss ha scritto:
Hi, roughnecks,
What MariaDB version is it? there were few bugs like that fixed recently.
As I said I'm on Debian stable, so: ii libdbd-mariadb-perl 1.22-1+b1 ii libmariadb3:amd64 1:10.11.3-1 ii mariadb-client 1:10.11.3-1 ii mariadb-client-core 1:10.11.3-1 ii mariadb-common 1:10.11.3-1 ii mariadb-plugin-provider-bzip2 1:10.11.3-1 ii mariadb-plugin-provider-lz4 1:10.11.3-1 ii mariadb-plugin-provider-lzma 1:10.11.3-1 ii mariadb-plugin-provider-lzo 1:10.11.3-1 ii mariadb-plugin-provider-snappy 1:10.11.3-1 ii mariadb-server 1:10.11.3-1 ii mariadb-server-core 1:10.11.3-1 Thanks
Hi, roughnecks, On Sep 08, roughnecks via discuss wrote:
Il 08/09/2023 17:50, Sergei Golubchik via discuss ha scritto:
Hi, roughnecks,
What MariaDB version is it? there were few bugs like that fixed recently.
As I said I'm on Debian stable, so:
ii libdbd-mariadb-perl 1.22-1+b1 ii libmariadb3:amd64 1:10.11.3-1 ii mariadb-client 1:10.11.3-1 ii mariadb-client-core 1:10.11.3-1 ii mariadb-common 1:10.11.3-1 ii mariadb-plugin-provider-bzip2 1:10.11.3-1 ii mariadb-plugin-provider-lz4 1:10.11.3-1 ii mariadb-plugin-provider-lzma 1:10.11.3-1 ii mariadb-plugin-provider-lzo 1:10.11.3-1 ii mariadb-plugin-provider-snappy 1:10.11.3-1 ii mariadb-server 1:10.11.3-1 ii mariadb-server-core 1:10.11.3-1
that's recent enough, should have everything fixed already. May be a new bug. Could you please report it at jira.mariadb.com? Few questions to cover there (someone will ask them, so you might as well know what's coming and may be even answer in advance). So, process size is growing? Like ps -o pid,vsz,comm `pgrep mysqld` is growing? What does show global status like 'memory%' select id,memory_used from information_schema.processlist; show? Do you have long-running connections? If you disconnect them all, how the above will change? Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
Il 10/09/2023 13:56, Sergei Golubchik ha scritto:
that's recent enough, should have everything fixed already. May be a new bug. Could you please report it at jira.mariadb.com?
Few questions to cover there (someone will ask them, so you might as well know what's coming and may be even answer in advance).
So, process size is growing? Like
ps -o pid,vsz,comm `pgrep mysqld`
I have rebooted my vps for a linux upgrade just 5 hours ago and I haven't even used roundcube yet. the command you posted isn't right for me, "pgrep mysqld" returns nothing. But this work: ps -o pid,vsz,comm `pgrep mariadb` PID VSZ COMMAND 832 1073640 mariadbd 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
is growing? What does
show global status like 'memory%' select id,memory_used from information_schema.processlist;
show? Do you have long-running connections? If you disconnect them all, how the above will change?
+---------------------+----------+ | Variable_name | Value | +---------------------+----------+ | Memory_used | 37291824 | | Memory_used_initial | 35240160 | +---------------------+----------+ 2 rows in set (0.018 sec) +----+-------------+ | id | memory_used | +----+-------------+ | 31 | 78096 | +----+-------------+ 1 row in set (0.013 sec) Maybe I will wait a couple days and check the differences, too early to say I think. Thanks
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?
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
Il 11/09/2023 17:15, Guillaume Lefranc via discuss ha scritto:
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.
2GB
Can you also post the output of ps -o pid,vsz,rss,comm `pgrep mariadb`
PID VSZ RSS COMMAND 832 1073640 31996 mariadbd
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';
+-------------------------+-----------+ | Variable_name | Value | +-------------------------+-----------+ | innodb_buffer_pool_size | 134217728 | +-------------------------+-----------+ 1 row in set (0.014 sec) +-------------------------------+---------+ | Variable_name | Value | +-------------------------------+---------+ | Innodb_buffer_pool_bytes_data | 6832128 | +-------------------------------+---------+ 1 row in set (0.001 sec) There you go. Thanks
Lower it to 128MB. 1Gb is too much especially for a 2gb VPs that is hosting other services. Le lun. 11 sept. 2023, 19:03, roughnecks via discuss < discuss@lists.mariadb.org> a écrit :
Il 11/09/2023 17:54, roughnecks via discuss ha scritto:
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.
I lowered the innodb buffer pool size to 768MB. _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
Il 11/09/2023 19:03, roughnecks ha scritto:
Il 11/09/2023 17:54, roughnecks via discuss ha scritto:
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.
I lowered the innodb buffer pool size to 768MB.
Then again to 256MB.. Not sure if I did it right but ram usage is again at 220MB. Followed here: https://mariadb.com/docs/server/storage-engines/innodb/operations/configure-... Please advice if this isn't correct, thanks.
Teilnehmer (3)
-
Guillaume Lefranc -
roughnecks -
Sergei Golubchik