March 2025 - discuss - lists.mariadb.org

Allocate CPU, RAM to a MariaDB instance
by jaswanth.at.work＠gmail.com 21 Mar '25

21 Mar '25

We are running multiple instances of mariadb using mysqld_multi on RHEL Server. We want to allocate CPU, RAM based on their individual instance workloads. We had seen that configuring innnodb parameters will do that, but what are the exact parameters we need to configure to allocate CPU Cores, RAM to the specific instance. We want to do it at database level not at OS level. What is the way to do this ?

3 5

Maxscale CLI
by Richard Reina 20 Mar '25

20 Mar '25

I am experimenting with maxscale and have set up a test cluster with a master and three slaves. I have successfully tested automatic failover and everything seems to work fine. However, I will need to run occasional direct read and write SQL queries which in the past have done in a non-maxscale/proxy environment by simply logging into the master and doing select and update queries. Since with Maxscale the master can change I believe I cannot do that. Can someone tell me how I can do SQL queries on the maxscale proxy? How can I get a CLI like: maxscale> UPDATE contact SET inactive='Y' WHERE ID =923;

2 1

Issue with MariaDB eating all the server memory
by Derick Turner 19 Mar '25

19 Mar '25

Hi all, I was pointed to this list from a question I raised on StackExchange (https://dba.stackexchange.com/questions/345743/why-does-my-mariadb-applicat…) I have a cluster of MariaDB (11.4.5) primary/primary servers running on Ubuntu. I updated the OS on Saturday to 24.04 from 22.04 (and patched the DB to the 11.4.5 noble version) as we were occasionally hitting an OOM event which was causing the database process to be killed. Since then, the DB process takes all of the available server memory before being killed by the OOM killer. DB is configured to use about 15GB of RAM (from config calculations) Servers currently have 50GB of RAM and 95% of this is used within about an hour an a half. Link to document with configuration settings, global status, mariadb.service override and InnoDB status is here - https://docs.google.com/spreadsheets/d/1ev9KRWP8l54FpRrhFeX4uxFhJnOlFkV4_vT… Any help would be gratefully received. Thanks in advance. Derick -- Derick Turner - He/Him

6 9

Prevent avalanche of NOTES when importing InnoDB tablespace
by mariadb＠Biblestuph.com 14 Mar '25

14 Mar '25

Greetings, I'm running some tests on MariaDB 11.4.5. When importing table spaces I'm getting a huge number of notifications in the log as follows: 2025-03-14 16:42:57 33 [Note] InnoDB: trying to read page [page id: space=2502, page number=78266] in nonexisting or being-dropped tablespace 2025-03-14 16:42:57 33 [Note] InnoDB: trying to read page [page id: space=2502, page number=78267] in nonexisting or being-dropped tablespace 2025-03-14 16:42:57 33 [Note] InnoDB: trying to read page [page id: space=2502, page number=78268] in nonexisting or being-dropped tablespace The bigger the table, the more messages. Other than taking space they seem harmless, in that the table import appears to work correctly. Is there any way to avoid them? Note that as part of my normal process the table that I'm importing typically exists in the DB prior to the import; if so I drop it (that's the case with the example above). I.E.: DROP TABLE IF EXISTS mydb.t1; (move the remote .frm, .cfg, and .ibd files into the data dir, per https://mariadb.com/kb/en/innodb-file-per-table-tablespaces/) ALTER TABLE mydb.t1 IMPORT TABLESPACE; And the above stream of NOTES appears. I've tried shutting down the DB in-between the DROP and ALTER (with innodb_fastshutdown=0), same result. Am I missing a step somehow? Thanks for any assistance! Dan

1 0

Re: Mariadb-dump, backing up single partition
by pslawek83 13 Mar '25

13 Mar '25

Hi Sergei, thanks for the comment. Currently tried to just add very simple change which will allow the user to specify partition name using comma separated list and a separator in table's name. For example ./mariadb-dump -umyuser -pmypass -h127.0.0.1 mydatabase _test1@p0,p1 _test2@p0 --partition-separator=@, not sure if I should parse the partition string to ensure there's no syntax error in generated query and partition names are escaped? Maybe will add ability to do that in parallel, automatically when i'll become more familiar with the framework. Thanks, Slawomir. Dnia 12 marca 2025 13:11 Sergei Golubchik <serg(a)mariadb.org> napisał(a): Hi, pslawek83, Note that mariadb-dump already supports --parallel option that can dump many tables in parallel. Depending on your use case you might want to extend --parallel to automatically dump individual partitions in parallel, instead of extending mariadb-dump to allow to specify what partition to dump. Depends on what you need, of course, I'm just listing the options so that you could choose what works better for you. On Mar 12, pslawek83 via discuss wrote: Hi Everyone, I want to add the ability to backup a single partition using mysqldump. I have some large (500GB+) partitioned tables I want to backup fast. So the idea is to run each partition in parallel using mariadb-dump but AFAIK there&#39;s no option for specifying the partition yet. Will you merge my code if I add that to mariadb-dump ? I assume MariaDB/server/blob/main/client/mysqldump.cc is where dev for that happens? Thanks Regards, Sergei Chief Architect, MariaDB Server and security(a)mariadb.org

1 0

Mariadb-dump, backing up single partition
by pslawek83 12 Mar '25

12 Mar '25

Hi Everyone, I want to add the ability to backup a single partition using mysqldump. I have some large (500GB+) partitioned tables I want to backup fast. So the idea is to run each partition in parallel using mariadb-dump but AFAIK there's no option for specifying the partition yet. Will you merge my code if I add that to mariadb-dump ? I assume MariaDB/server/blob/main/client/mysqldump.cc is where dev for that happens? Thanks

3 2

For 10.4.x holdouts - 10.4.34.1
by Gordan Bobic 09 Mar '25

09 Mar '25

For anyone else here who doesn't particularly want to move to 10.5 or 10.6 quite yet, here's a build for el8 and el9 that includes a backport of fix for CVE-2025-21490 https://dl.shatteredsilicon.net/MariaDB/ -- Gordan Bobic Database Specialist, Shattered Silicon Ltd. https://shatteredsilicon.net

1 0