- docs - lists.mariadb.org

[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

[Maria-docs] CVE list for connectors
by Michal Schorm 22 Aug '18

22 Aug '18

Hello, On this page: https://mariadb.com/kb/en/library/security/ I can find CVEs that affect MariaDB server and releases they were fixed in. Other useful page is this one: https://mariadb.com/kb/en/library/security-vulnerabilities-in-oracle-mysql-… -- I'd like to ask you to also list CVEs applicable for connectors and versions of connectors (CONC, CONJ, ODBC) they were fixed in, since there is not direct relationship between: 1) server nad CONC 2) ODBC and CONC Server is (or atleast should be) built on top of released version of the CONC, not the latest Git content. Atleast downstreams starts to use this scheme (separate server and client library - the CONC), so they depend only on the released versions of the CONC. -- For example CVE-2018-3081 should be fixed in CONC 3.0.5, however since nor git commit, nor CONC release notes says it explicitly, I can only guess. -- Michal Schorm Associate Software Engineer Core Services - Databases Team Red Hat

2 2

[Maria-docs] Questions About Lifetime Cycles of MariaDB for Ubuntu
by Mpingu 04 Jun '18

04 Jun '18

Hello Everyone, i found an unclear information in the MariaDB Documentation. I hope this is the right way to help getting it improved. On the Download Site for Ubuntu 18.04 and MariaDB 10.1. Link https://downloads.mariadb.org/mariadb/repositories/#version=10.1&distro=Ubu… The Website says: Ubuntu includes MariaDB 10.1 in its main repositories, so for general use of MariaDB 10.1 we recommend using the Ubuntu provided MariaDB 10.1 packages for general use. But in the Packages List of Ubuntu it is stated as universe, not Main. That means no official support from Ubuntu/Canonical. https://packages.ubuntu.com/bionic/mariadb-server-10.1 For me the Question is what is the guaranteed support life time of MariaDB 10.1 in Ubuntu 18.04? -- Carsten Bohuslav Metalpinguin(a)gmail.com

3 2

[Maria-docs] GA should also mean "documented" :)
by Federico Razzoli 23 May '17

23 May '17

It's great to see that 10.2 is now GA. But from a quick look, I've seen that documentation is incomplete: * Recursive CTE not documented: https://mariadb.com/kb/en/mariadb/common-table-expressions/ * Window functions: "this article is currently incomplete" https://mariadb.com/kb/en/mariadb/window-functions-overview/ There could be other undocumented features, these are the ones I've found immediately. Please, fill those gaps so we can test the features. Regards, Federico

2 1