- discuss - lists.mariadb.org

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

This month in the MariaDB Foundation
by Anna Widenius 21 Feb '25

21 Feb '25

"Focus, focus, focus! That’s the mantra of any successful organisation. With great input from our Board, we’ve managed to condense our strategic planning for 2025 into six goals." Read Kaj Arnö’s blog about the MariaDB Foundation’s goals for 2025 - https://mariadb.org/this-month-2025-jan/ Anna Widenius Chief of Staff, MariaDB Foundation

1 0

Vector indexing questions for deep-image-96-angular dataset
by shiyer22＠gmail.com 19 Feb '25

19 Feb '25

Greetings! I am doing some benchmarking on MariaDB and got to the deep-image-96-angular dataset from https://github.com/erikbern/ann-benchmarks. This dataset has 9.99 million vectors of dimension 96. I am running the vector index create with M=24,ef_construction = 200 (similar parameters as pgvector in ANN-Benchmark). I wanted to check and confirm a couple of observations based on the progress of the index create at present - MariaDB [(none)]> show processlist; +----+--------+-----------+------+---------+------+-------------------+----------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+--------+-----------+------+---------+------+-------------------+----------------------------------------------------------+----------+ | 4 | ubuntu | localhost | ann | Query | 4092 | copy to tmp table | ALTER TABLE t1 ADD VECTOR INDEX (v) M=24 DISTANCE=cosine | 9.636 | MariaDB [(none)]> select trx_rows_modified from information_schema.innodb_trx; +-------------------+ | trx_rows_modified | +-------------------+ | 125215100 | +-------------------+ 1 row in set (0.004 sec) -rw-rw---- 1 ubuntu ubuntu 40420507648 Feb 19 06:20 undo002 Can you please confirm that the undo log reaching 40GB+ is expected for a progress of 9%? Did I miss something? I have configured the hnsw cache size and buffer pool to 16GB each. Should I increase them further? I want to benchmark for "hnsw index fits in memory" use-case. MariaDB [(none)]> show variables like '%hnsw%'; +------------------------+-------------+ | Variable_name | Value | +------------------------+-------------+ | mhnsw_default_distance | euclidean | | mhnsw_default_m | 24 | | mhnsw_ef_search | 200 | | mhnsw_max_cache_size | 17179869184 | +------------------------+-------------+ 4 rows in set (0.001 sec) Just to let know, I am working on the vector plugin for MySQL (MyVector) Thanks!

3 4

Fixing typos
by qobood＠gmail.com 15 Feb '25

15 Feb '25

Greetings! I've made a simple patch with some corrected typos, is there an interest for this initiative? If so, I can continue doing this thing, requesting approval for this patch and next ones.

1 0

Rebuild repodata for EL7 repo
by Software Mirror Team 05 Feb '25

05 Feb '25

Hi, Would it be possible to rebuild repodata for https://mirror.mariadb.org/yum/10.11/rhel/7/x86_64/? We are using Foreman (https://theforeman.org/) to mirror different software in our network. All other MariaDB repos are fine, but for 10.11/rhel/7 we are getting "404, message='Not Found', url=URL('https://mirror.mariadb.org/yum/10.11/rhel/7/x86_64/srpms/MariaDB-10.11.7-1.…')" It looks like the repodata still contains references to removed files. Our apologies if this list is not appropriate. Thank you in advance. Best regards, IIS Mirror team

2 2

Are the mariadb repos working?
by Simon Avery 04 Feb '25

04 Feb '25

Hi Struggling to install mariadb-server 11.10 onto a new Rocky9 vm today. I've previously used a saved repo which has baseurl=https://dlm.mariadb.com/repo/mariadb-server/10.11/yum/rhel/9/x86_64 But that's returning 404 in most of the tree. I followed some other instructions from https://mariadb.com/kb/en/mariadb-package-repository-setup-and-usage/ Which downloaded mariadb_repo_setup which, when run, created a .repo file with baseurl https://dlm.mariadb.com/repo/mariadb-server/11.rolling/yum/rhel/9/x86_64 That url is also returning 404 for me, all the way up the tree to the domain. Is it you guys, or is it me? Thanks, Simon Avery Linux Sysadmin: ATASS Sports Oxygen House | Grenadier Road, Exeter Business Park | EX1 3LH t: 01392 440 400 e: simon.avery(a)atass-sports.co.uk<mailto:simon.avery@atass-sports.co.uk> www.atass-sports.co.uk<http://www.atass-sports.co.uk/> Follow us on X: @atassSports<https://twitter.com/atassSports> NOTICE This email and any attachments confidential and intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. Please notify the sender immediately. ATASS Ltd is incorporated in England and Wales with company number 04807405. See our website for further details and our privacy policy

3 3

Are default_m and ef_search "implementation specific" vector store parameters?
by Vishal Rao 30 Jan '25

30 Jan '25

Hello, I'm replacing the use of Chroma with MariaDB as the vector store and the Chroma code sets the ef_search parameter to a value of 50. My question is, to achieve "similar results" with the MariaDB vector store will setting ef_search to 50 here as well have the intended effect? Or is there no relation between the actual values across implementations and I need to experiment/test to observe how MariaDB performs to arrive at an appropriate value for it? Thank you. -- "The World is a book, and those who do not travel read only a page." - St. Augustine.

2 2

Set vector ef_search value in CREATE TABLE statement?
by Vishal Rao 30 Jan '25

30 Jan '25

Hello! The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value. Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table? Currently I saw this comment here : https://jira.mariadb.org/browse/MDEV-35244?focusedCommentId=293664&page=com… which I can use as a workaround to set session value of ef_search for my needs but wanted to know if I can open a Jira wishlist ticket unless this is already planned? Thanks! -- "The World is a book, and those who do not travel read only a page." - St. Augustine.

3 4