- docs - lists.mariadb.org

NewCommer
by Miirza Baig 28 Sep '24

28 Sep '24

List

1 0

Contributing to MariaDB Community Server
by Kerin Khan 09 Sep '24

09 Sep '24

Hello, My name is Kerin Khan. I was a technical writer at MariaDB. I want to contribute to MariaDB Foundation documentation. I would love to get started soon. Thank you for your time, Kerin

2 2

mariadb kb on hyperthreading
by Federico Razzoli 13 May '24

13 May '24

I've just noticed this paragraph: https://mariadb.com/kb/en/mariadb-memory-allocation/#hyperthreading-and-mul… 1) "HyperThreading is great for marketing, lousy for performance. It involves having two processing units sharing a single hardware cache. If both units are doing the same thing, the cache will be reasonably useful. If the units are doing different things, they will be clobbering each other's cache entries." I believe it is entirely based on a misconception: HTT has nothing to do with threads "doing the same thing". 2) About the part that warns us from using too many cores: I believe it was correct some years ago, but not today, or at least not for just 8 cores. * I don't feel comfortable deleting what others wrote, so I'll just raise the problems here. Federico -- Federico Razzoli Vettabase Ltd director & founder, Database Consultant https://vettabase.com federico.razzoli(a)vettabase.com +44 7739 427279 Telegram: federico_razzoli Skype: fede.razzoli The information in this e-mail and any attachments may be confidential. If you received it by mistake, please inform the sender. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.

2 1

[Maria-docs] 10.6 ALTER TABLE ... ADD/ALTER INDEX ... [NOT] IGNORED
by Andre Vergison (avergiso) 04 Mar '22

04 Mar '22

Hello, About https://mariadb.com/kb/en/alter-table/ , the 10.6 [NOT] IGNORED index option: It looks as if [NOT] IGNORED was not documented in the ALTER {INDEX|KEY} subclause: ALTER TABLE <name> ALTER INDEX name IGNORED which works fine too. This syntax was shown on https://mariadb.com/kb/en/ignored-indexes/ though. The documented syntax ALTER TABLE <name> ADD INDEX (<columns>) IGNORED seems to work fine. Thanks, Andre

1 0

[Maria-docs] [DISCUSS] Don't see ARM release information in MariaDB download page
by bo zhaobo 02 Jan '20

02 Jan '20

Hi Team, I want to make clear a thing about the Mariadb download page. Hope team could give some advices or help. When I want to download a aarch64 mariadb package, I'm failed to search any information in the content of page [1]. But I tried to search the RPM/DEB package, such as in '*Red Hat, Fedora, and CentOS Packages*' and '*Debian and Ubuntu Packages*', and I can see there are ARM(aarch64/arm64) specific packages in these linked pages [2]. And documentation in [1] just say OS/CPU with "*RedHat/CentOS/Fedora (x86, x86_64, ppc64, ppc64le)*". It seems that there is difference between the documentation with real released packages. That's why I'm here to want to make it clear and discuss with team. *How about add 'aarch64' in the OS/CPU description?* I think that would be great if community could fix that, because it is good for users. They could get what they want from MariaDB download page(MariaDB docs related). Thanks very much. BR ZhaoBo [1] https://downloads.mariadb.org/mariadb/10.5.0/ [2] http://ftp.igh.cnrs.fr/pub/mariadb//mariadb-10.5.0/yum/ http://ftp.igh.cnrs.fr/pub/mariadb//mariadb-10.5.0/repo/

1 0

[Maria-docs] --apply-log-only option is missing
by Thomas Janssens 29 Mar '19

29 Mar '19

On the following page https://mariadb.com/kb/en/library/mariabackup-options the --apply-log-only option is missing. For example, on this page: https://mariadb.com/kb/en/library/incremental-backup-and-restore-with-maria… we can find a link to: https://mariadb.com/kb/en/mariabackup-options/#-apply-log-only which doesn't show the desired content as the option is not mentioned. Thomas

1 0

[Maria-docs] Restoring backup: instructions
by Thomas Janssens 29 Mar '19

29 Mar '19

Hello, This page contains instructions on how to restore a backup: https://mariadb.com/kb/en/library/full-backup-and-restore-with-mariabackup/… 1. stop MariaDB: # systemctl stop mariadb.service 2. datadir must be empty: # rm -rf /var/lib/mysql/ 3. run mariabackup: #mariabackup --copy-back --target-dir=/var/mariadb/backup/ 4. fix permissions: # chown -R mysql:mysql /var/lib/mysql/ 5. start MariaDB: # systemctl start mariadb.service mariabackup said "completed OK!" and I see that datadir contains the restored data. However, when following these instructions, I can't start MariaDB anymore. I have the following error: mar 29 07:06:49 myhostname mysqld[11359]: 2019-03-29 7:06:49 0 [ERROR] Plugin 'InnoDB' init function returned error. mar 29 07:06:49 myhostname mysqld[11359]: 2019-03-29 7:06:49 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mar 29 07:06:49 myhostname mysqld[11359]: 2019-03-29 7:06:49 0 [Note] Plugin 'FEEDBACK' is disabled. mar 29 07:06:49 myhostname mysqld[11359]: 2019-03-29 7:06:49 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded mar 29 07:06:49 myhostname mysqld[11359]: 2019-03-29 7:06:49 0 [ERROR] Unknown/unsupported storage engine: InnoDB mar 29 07:06:49 myhostname mysqld[11359]: 2019-03-29 7:06:49 0 [ERROR] Aborting mar 29 07:06:49 myhostname systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE mar 29 07:06:49 myhostname systemd[1]: Failed to start MariaDB 10.3.13 database server. mar 29 07:06:49 myhostname systemd[1]: Unit mariadb.service entered failed state. mar 29 07:06:49 myhostname systemd[1]: mariadb.service failed. Is there something missing in the documentation? Thomas

1 1

[Maria-docs] Obsolete TokuDB page?
by Federico Razzoli 08 Mar '19

08 Mar '19

Hi list, This page:https://mariadb.com/kb/en/library/tokudb-differences/ looks quite obsolete. If nothing else, because there is no version distributed by TokuTek, because there is no TokuTek anymore. Percona and Percona Server are not even mentioned in the page. I have no idea if the listed differences are up to date, but I guess it would be worth a check... Cheers,Federico

1 0

[Maria-docs] Obsolete pages
by Federico Razzoli 04 Dec '18

04 Dec '18

There is this Old Plans category:https://mariadb.com/kb/en/library/old-plans/ If you navigate to the leaf pages, you find things like this:https://mariadb.com/kb/en/library/mariadb-plans-gis/ If you look at the page without following any link, nothing makes you think that it is an old list. The main category has nothing to do with "old plans", but even where it was the case, the category list is not prominent enough. If those pages still make sense, I think that something should be done to clarify that they are there for historical purpose. In this particular page, I also notice something curious. AddGeometryColumn was never implemented for the users, but it is in the source code (and unused, according to GitHub limited search capabilities):https://github.com/MariaDB/server/blob/5abc79dd7ab2fccb4b05ca… Cheers,Federico

1 1

[Maria-docs] temporal tables and indexes
by Federico Razzoli 06 Nov '18

06 Nov '18

Please document how temporal columns (ROW START and ROW END) are indexed in system-versioned tables. Anyone can write some documentation based on EXPLAIN output, but only MariaDB can write complete and reliable information. Cheers,Federico Razzoli

1 0