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

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

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: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.

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.