Re: [Maria-discuss] “system user” in SHOW PROCESSLIST

Hi, Rhys, Felipe, It's not reserved in any way. If you create a user named "system user", you'll see yet another "system user" row in the SHOW PROCESSLIST, but with non-empty host. That's all. On Feb 15, rhys.campb...@swisscom.com wrote: > The "system user" identifies internal tasks spawned by

Re: [Maria-discuss] will query_response_time be removed?

Hi, Federico! On Jan 02, Federico Razzoli wrote: > I see that Percona has removed query_response_time in version 8.0. > Does this plugin have a future in MariaDB? There are no plans (that I know of) to remove this plugin from MariaDB. Regards, Sergei Chief Architect MariaDB and

Re: [Maria-discuss] account locking?

Hi, Felipe! On Nov 02, Felipe Gasper wrote: > Hello, > > Does the MariaDB development team intend to add account locking? > I don’t see it in the 10.4 roadmap. It's there - https://jira.mariadb.org/browse/MDEV-13095 and has a priority of Critical. but, of course, it still doesn't guarantee

Re: [Maria-discuss] aws key management plugin

Hi, Paul! On Oct 19, Paul Chubb wrote: > Hi, > on the repo there only seems to be copies of this for Ubuntu yacketty > (16.10) and Ubuntu zesty (17.04). Both of these are end of life. Is there > supposed to be support for Bionic (18.04)? Yes. It's a bug, should be fixed in the next

Re: [Maria-discuss] CONC-312; caching_sha2_plugin

Hi, Michal! It was incorrect. I've now reopened CONC-312. Sorry for this. On Sep 25, Michal Schorm wrote: > Hello, > > Can I get some explanation, why was > https://jira.mariadb.org/browse/CONC-312 > closed as WON'T FIX ? > > -- > > MySQL 8.0 implemented "caching_sha2_password" as its default

Re: [Maria-discuss] pam / ldap auth

Hi, mj! On Sep 25, mj wrote: > Hi, > > So, much progression, by using the pam debug flags: > > > auth required pam_winbind.so debug > > account required pam_winbind.so debug > > auth required pam_user_map.so debug > > reveiling this in /var/log/debug: > > > Sep

Re: [Maria-discuss] pam / ldap auth

Hi! On Sep 11, mourik jan c heupink wrote: > Until I found out this works only from the localhost mariadb is running > on. Trying this from a remote mysql client gives: > > > user@e7470 ~ $ mysql -udomain_user -p -h mysqlserver.full.address > > Enter password: ERROR 2059 (HY000):

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

Hi, Reindl! On Aug 13, Reindl Harald wrote: > > > Am 13.08.2018 um 12:22 schrieb Ling, Andy: > >> "The advantage of FLUSH TABLES table_name FOR EXPORT is that the table > >> is read locked until UNLOCK TABLES is executed" is not really true > >> because that's only valid for the running

Re: [Maria-discuss] [EXTERNAL] Re: Copying database files

Hi, Andy! On Aug 13, Ling, Andy wrote: > > The code doing this stops everything talking to the database (Yes, I > know there could be someone fiddling remotely in a shell, but this is > very unlikely). Even tables which are never written to cause this > error > > So if I'm careful, is there a

Re: [Maria-discuss] New testsuite option

Hi, Michal! On Aug 13, Michal Schorm wrote: > > > > What if we just make mtr to do `exit 2` if it exists because of > > --max-test-fail ? > > I'm afraid that won't help me in any way. > In such case, still, no matter how many tests fail (if >0), the > testsuite will fail. With different exit

Re: [Maria-discuss] Best way to fetch user’s password hash?

Hi, Felipe! On Aug 10, Felipe Gasper wrote: > Hi all, > > What is the best way to fetch a user’s password hash? I’d ideally like > something that works in both MySQL and MariaDB, as many versions as > possible. > > Thank you! You can select from mysql.user. You can use IF() function to create

Re: [Maria-discuss] community contribution measurement page

Hi, Daniel! Wow, this is very informative. Thanks a lot! It's nice to see how "First PR response" time got improved (in 2015?) after Svoj started handling PRs. Recent increase in PRs can, perhaps, be partially attributed to Tempesta and Codership? And, perhaps, partially because we're getting

Re: [Maria-discuss] New testsuite option

Hi, Michal! On Jul 17, Michal Schorm wrote: > Hello, > > I take care of MariaDB in Fedora & RHEL. > > We run the testsuite there. Every time, in every build, with --big-test. > Time to time it happens that some of the tests fail. For example during a > rebuild. > > For such cases, I'd use a

Re: [Maria-discuss] [MariaDB Announce] MariaDB 10.2.16 now available

Hi, Reindl! On Jun 26, Reindl Harald wrote: > is there any QA on your side? > > mysql-test-run: *** ERROR: Could not find any of > /usr/sql/mysql_tzinfo_to_sql /usr/bin/mysql_tzinfo_to_sql > /usr/sql/mysql_tzinfo_to_sql > > where the hell is "mysql_tzinfo_to_sql" gone? > that it's here in

Re: [Maria-discuss] Timezones Table

Hi, Kurniadi! On Jun 12, Kurniadi Asrigo wrote: > Hi, > > I am following the instruction to update the timezone table from MySQL: > https://mariadb.com/kb/en/library/time-zones/ > > And the file is downloaded from MySQL page. I got MariaDB from XAMPP, running > on Window10. I downloaded the >

Re: [Maria-discuss] MariaDB Compile Size

Hi, Reindl! On May 19, Reindl Harald wrote: > Am 19.05.2018 um 07:33 schrieb Tom Jay: > > > > Has anyone got any idea how to reduce the MariaDB install size, when > > compiling from source? I've had multiple attempts, all with > > different options such as 'WITHOUT_EXAMPLE_STORAGE_ENGINE=1' and

Re: [Maria-discuss] SQL_MODE=ORACLE documentation

Hi, Alexander! On Mar 05, Alexander Barkov wrote: > For example, for the WHILE loop syntax, > do we need an new PL/SQL article similar to > https://mariadb.com/kb/en/library/while/ , > or should we put the PL/SQL WHILE syntax directly > on this page. > > What do you think would be more readable?

Re: [Maria-discuss] procedure to change database encryption with file_key_management plugin?

Hi, obsa! On Feb 22, o...@mm.st wrote: > > Encryption key management > > MariaDB encryption supports multiple encryption keys, they are > identified by a key identifier — a 32-bit integer. To support > automatic key rotation every key additionally might have different > versions. XtraDB

Re: [Maria-discuss] JSON column type

Hi, Brent! On Feb 21, Brent Clark wrote: > Good day Guys > > I have a client that is looking for JSON support, or better 'JSON column > type'. > > He is asking for MySQL/5.7.8 (Currently on MySQL 5.6). > > And his comment is : "/This is so that we can use the JSON column type > introduced in

Re: [Maria-discuss] build broken again -> Fwd: [MariaDB Announce] MariaDB 10.2.13, MariaDB Connector/ODBC 3.0.3 and MariaDB Connector/ODBC 2.0.16 now available

Hi, Reindl! On Feb 13, Reindl Harald wrote: > can we have a release which simply builds? > see my complaint about 10.2.12 > 10.2.13 is also broken > different place > > would you guys mind sent out a link to the users list *before* GA > annoucements so that such likely easy to fix bugs can be

Re: [Maria-discuss] mariadb-backup meta deb package

Hi, Reindl! On Feb 14, Reindl Harald wrote: > Am 14.02.2018 um 10:51 schrieb Florent B: > > Wouldn't be nice to have a metapackage mariadb-backup in Debian > > repository, that depends on the current best version > > (mariadb-backup-10.2, etc..) ? > > > > Like "mariadb-server" package in fact >

Re: [Maria-discuss] mariadb-backup meta deb package

Hi, Florent! On Feb 14, Florent B wrote: > Hi, > > Wouldn't be nice to have a metapackage mariadb-backup in Debian > repository, that depends on the current best version > (mariadb-backup-10.2, etc..) ? > > Like "mariadb-server" package in fact. Yes, I guess. It'll be consistent with what we

Re: [Maria-discuss] [MARIADB 5.5] Profiling truncated

Hi, Fabien! On Feb 08, Fabien CLERC wrote: > Hello, I'm trying to profile a very long query in production (MariaDB 5.5) > using "set session profiling = 1" but when I run the command "show profile > for query 1", there is only the only 100 last steps of the query. > It's the same checking in

Re: [Maria-discuss] Clarification about have_ssl and have_openssl variables

Hi, Peter! On Feb 08, Peter Laursen wrote: > MySQL documentation states > https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_have_openssl > simply states "This variable is an alias for have_ssl.". I checked with a > few Oracle/MySQL installations that the two variables

Re: [Maria-discuss] Fwd: mysql_insert_id() for INSERT...SELECT statement

Hi, Yuki! On Jan 30, Yuki . wrote: > Hi Sergei, > > Thank you very much for the help. > > You suggest to check `mysql_affected_rows` first and if it is `1`, get > id from `mysql_insert_id`, is it right? Because my goal is to get an > ID in case of a successful insertion. Yes Regards, Sergei

Re: [Maria-discuss] Fwd: mysql_insert_id() for INSERT...SELECT statement

Hi, Yuki! On Jan 22, Yuki . wrote: > > I made a post at > https://stackoverflow.com/questions/48306962/mysql-insert-id-for-insert-select-statement > but have not received any helpful answer, may be you could help me. I > am using MaridDB but I read MySQL documentation because it has much more >

Re: [Maria-discuss] OpenLDAP & PAM authentication

Hi, Adam! On Jan 19, Adam Balgach wrote: > Hello – > > I am having an issue configuring openLDAP to authenticate users on an > instance in RHEL (CentOS 7) > > MariaDB server > > configured with plugin-load=auth_pam.so > > in my /etc/pam.d/mysql: > auth required pam_ldap.so > account required

Re: [Maria-discuss] Problem with bit operations in certain expressions

Hi, Mats! On Jan 09, Ian Gilfillan wrote: > On 09/01/2018 01:14, Mats Eklund wrote: > > Need some help here. I have the following expression: > > > > SELECT IF(1=1, 0x2, 0x4) | 0x1 > > > > which in MySQL evaluates to: 3 > > > > but in MariaDB it evaluates to: 1 > > > > MySQL's result seems 

Re: [Maria-discuss] WSREP: BF lock wait long

Hi, Jesus! On Dec 22, Jesus wrote: > Hi > > Thanks for the help, but the workaround didn't help... > > When will the new version be available on the centos repo? Our release schedule is public, on jira.mariadb.org. 10.2.12 is planned to be released on 2017-12-29 Regards, Sergei Chief

Re: [Maria-discuss] WSREP: BF lock wait long

Hi, Jesus! On Dec 18, Jesus wrote: > Hi > > I'm getting this message almost daily or even more and I must restart > the server that generates it: > > WSREP: BF lock wait long > > How can I solve this? This is bug https://jira.mariadb.org/browse/MDEV-12837 Fixed in 10.2.12. As a workaround

Re: [Maria-discuss] About data encryption

Hi, Cesar! On Dec 14, Cesar Hernandez wrote: > Hi > > Can someone tell me which algorithm uses MariaDB when using table > encryption? Looking at > https://mariadb.com/kb/en/library/data-at-rest-encryption/ Seems to > talk only about encryption of the key file, but not on the database > data.

Re: [Maria-discuss] Mariadb-10.2.11 missing tokudb rpm

Hi, Reinis! On Nov 29, Reinis Rozitis wrote: > Hi, > the mariadb-10.2.11 release (all distros) is missing *-tokudb-engine.rpm > package. > > Is this a build/packaging error or something more (though nothing in the > Release notes)? build/packaging error. missing packages are already built,

Re: [Maria-discuss] ALTER TABLE removes check constraint

Hi, Peter! On Nov 22, Peter Laursen wrote: > OK, I can see it is the same thing happening here > > DROP TABLE tab; > CREATE TABLE tab( id INT, num INT KEY); > ALTER TABLE `test`.`tab` CHANGE `num` `num` BIGINT; > SHOW CREATE TABLE tab; > /* > CREATE TABLE `tab` ( > `id` int(11) DEFAULT NULL, >

Re: [Maria-discuss] ALTER TABLE removes check constraint

Hi, Peter! On Nov 22, Peter Laursen wrote: > Test case: > > CREATE TABLE checks (a INT CHECK (a>2), b INT CHECK (b>2), CONSTRAINT > a_greater CHECK (a>b)); > SHOW CREATE TABLE checks; > ALTER TABLE `test`.`checks` CHANGE `a` `a` INT(11) NULL; > SHOW CREATE TABLE checks; > /' -- and now one

Re: [Maria-discuss] RPM CMake build arguments - Fedora

Hi, Michal! On Nov 13, Michal Schorm wrote: > > 3) PCRE > Good question actually :) > I think now it has mostly historical reasons only. I'll check, if it still > makes sense. To clarify. There can be four cases: 1. system PCRE is usable, WITH_PCRE=system = mariadb uses system pcre (default

Re: [Maria-discuss] RPM CMake build arguments - Fedora

Hi, Michal! On Nov 10, Michal Schorm wrote: > Hello everybody, > > I want to update Fedora SPECfile to the latest best practise. > This time, I want to fix CMake arguments. > > As the time flown, we were adding more and more arguments and for many of > them, I'm not sure of their correct

Re: [Maria-discuss] Building 10.2 from source issues

e to compile and other to fail. Regards, Sergei Chief Architect MariaDB and secur...@mariadb.org > -GL > > Le mer. 1 nov. 2017 à 00:30, Sergei Golubchik <s...@mariadb.org> a écrit : > > > Hi, Guillaume! > > > > On Oct 31, Guillaume Lefranc wrote: > > > Hi

Re: [Maria-discuss] Building 10.2 from source issues

Hi, Guillaume! On Oct 31, Guillaume Lefranc wrote: > Hi, > > I am trying to build 10.2 from sources while disabling some plugins > (building with all plugins works without issues). > > e.g. > > $ cmake . -DPLUGIN_MROONGA=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_SPHINX=NO > -DPLUGIN_ROCKSDB=NO > $ make

Re: [Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.9, MariaDB 10.1.28 and MariaDB Connector/J releases

Hi, Reindl! On Sep 29, Reindl Harald wrote: > > > Am 29.09.2017 um 11:01 schrieb Sergei Golubchik: > > Do you expect this diff to apply to 10.2.10 too? > > The short one could be: > > > > diff --git a/sql/CMakeLists.txt b/sql/CMakeLists.txt > >

Re: [Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.9, MariaDB 10.1.28 and MariaDB Connector/J releases

Hi, Reindl! On Sep 29, Reindl Harald wrote: > Am 29.09.2017 um 08:45 schrieb Sergei Golubchik: > > Hi, Reindl! > > > > I was able to repeat this error using your cmake command-line. > > The culprit here is -DWITHOUT_DYNAMIC_PLUGINS=ON. The commit

Re: [Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.9, MariaDB 10.1.28 and MariaDB Connector/J releases

Hi, Reindl! I was able to repeat this error using your cmake command-line. The culprit here is -DWITHOUT_DYNAMIC_PLUGINS=ON. The commit that introduced the bug (43b262af55db507320b165bb0f9abf05b2f05a89) makes SET_TARGET_PROPERTIES(mysqld PROPERTIES ENABLE_EXPORTS TRUE) to be only done

Re: [Maria-discuss] Fwd: [MariaDB Announce] MariaDB 10.2.9, MariaDB 10.1.28 and MariaDB Connector/J releases

Hi, Reindl! On Sep 28, Reindl Harald wrote: > it would be really cool if MariaDB minor updates (10.2.8 to 10.2.9 in > that case) would work like for any other software - just replace the > tarball, raise the version in the spec-file and hit "rpmbuild -bb > mariadb.spec" > > CMakeError.log as

Re: [Maria-discuss] Tokudb 5.7.18-16 fixes in Mariadb 10.2.8

Hi, Alessandro! On Aug 02, Alessandro Ren wrote: > Sergei, > > by any chance this merge will come out in MariaDB 10.0.32? It also fixes > the row count problem in TokuDB in versions greater than 10.0.25. > This fix came out here >

Re: [Maria-discuss] -DWITH_SYSTEMD=ON is the same as -DWITH_SYSTEMD=OFF

Hi, Reindl! Fixed. On Jul 13, Reindl Harald wrote: > > anyways, when "-DWITH_SYSTEMD=ON" and "-DWITH_SYSTEMD" is the same as > "-DWITH_SYSTEMD=OFF" and only completly leave out the param the whole > configure thing is just crap - and that's not again any person, i have > written enough crap

Re: [Maria-discuss] MariaDB 10.2.7 and libmysql compatibility

Hi, Reindl! On Jul 13, Reindl Harald wrote: > i am missing something (probably simple like symbol versioning however > done with some hack) or is it really not possible by providing symlinks > to avoid "libmysqlclient.so.18 => not found" and all clients linked > against 10.1.x failing? I'm

Re: [Maria-discuss] JSON in MariaDB 10.2.7 and MySQL

t; >> being equal to >> >> col1 LONGTEXT CHARACTER SET utf8mb4 CHECK(JSON_VALID(col1)) > > .. would be nice. > > -- Peter > > On Thu, Jul 13, 2017 at 12:03 PM, Sergei Golubchik <s...@mariadb.org> wrote: > > > Hi, Peter! > > >

Re: [Maria-discuss] incomplete provide of symlinks with 10.2.7

Hi, Reindl! On Jul 13, Reindl Harald wrote: > Fedora just started to work on MariaDB 10.2 packaging > > they create compat symlinks for a sane transition and i try to backport > that to my F25 builds with change as less as possible on my existing > "mariadb.spec" > > 10.2.7 seems to do the

Re: [Maria-discuss] 10.2.7 and xtradb in changelog

Hi, Reindl! On Jul 13, Reindl Harald wrote: > Am 13.07.2017 um 11:55 schrieb Sergei Golubchik: > > On Jul 13, Reindl Harald wrote: > >> https://mariadb.com/kb/en/mariadb/mariadb-1027-changelog/ > >> > >> i thought xtradb is gone in 10.2.x > >> > &

Re: [Maria-discuss] JSON in MariaDB 10.2.7 and MySQL

Hi, Peter! On Jul 13, Peter Laursen wrote: > -- MariaDB 10.2.7 > CREATE TABLE `jsontst`( `id` INT NOT NULL AUTO_INCREMENT, `str` JSON, > PRIMARY KEY (`id`) ) ENGINE=Aria CHARSET=latin1; > SHOW CREATE TABLE `jsontst`; > /* returns > CREATE TABLE `jsontst2` ( > `id` int(11) NOT NULL

Re: [Maria-discuss] 10.2.7 and xtradb in changelog

Hi, Reindl! On Jul 13, Reindl Harald wrote: > https://mariadb.com/kb/en/mariadb/mariadb-1027-changelog/ > > i thought xtradb is gone in 10.2.x > > is it back now with 10.2.7 or is the changelog a random wild mix of > commits with no context to the version of the release? Neither. Changelog is

Re: [Maria-discuss] Broken MariaDB client ARGGG!!!

Hi, Jon! Generally, if you want to have a bug fixed, you'll have better chances at jira.mariadb.org, than on the mailing list. This particular bug was filed as https://jira.mariadb.org/browse/MDEV-12889 and it's already fixed, the fix will be released in 10.2.7. The release schedule is also

Re: [Maria-discuss] I expected the same values for mariadb_config, mysql_config and my_print_defaults --mysqld

Hi, Guillermo! On Jul 03, Guillermo Cespedes wrote: > Hi, > The values are not correct, they are even different, I expected the same > values. > See socket and version. Version is identical in my 10.2.7 branch. I must've fixed it recently, there were few related changes. In particular,

Re: [Maria-discuss] how to build MariaDB from source

Hi, Reindl! On Jul 03, Reindl Harald wrote: > Am 03.07.2017 um 11:45 schrieb Sergei Golubchik: > > Hi, Reindl! > > > > On Jul 02, Reindl Harald wrote: > >> i get tired - "-DPLUGIN_INNODB=YES" leads to failures at configure time > >> -

Re: [Maria-discuss] how to build MariaDB from source

Hi, Reindl! On Jul 02, Reindl Harald wrote: > i get tired - "-DPLUGIN_INNODB=YES" leads to failures at configure time > - each time the same dance when the version changes Sorry for this. I know, this shouldn't happen. On the other hand, you use a rather detailed non-standard build

Re: [Maria-discuss] [mysqld] Can't find messagefile '/usr/share/mysql/errmsg.sys'

Hi, Guillermo! On Jun 29, Guillermo Cespedes wrote: > Hi, Sergei. > > I have two my.cnf files: /etc/my.cnf and /etc/mysql/my.cnf > > In /etc/mysql/my.cnf: > > basedir, datadir and lc-messages-dir > > They are pointing to an incorrect directory. > > I can avoid this when I compile mariadb,

Re: [Maria-discuss] [mysqld] Can't find messagefile '/usr/share/mysql/errmsg.sys'

Hi, Guillermo! On Jun 28, Guillermo Cespedes wrote: > Hi, > > Compilation Instructions: > # uname -a > Linux framework 3.16.0-4-686-pae #1 SMP Debian 3.16.43-2+deb8u2 > (2017-06-26) i686 GNU/Linux > > # groupadd mysql > # useradd -c "MySQL Server" -g mysql -s /bin/false mysql > >

Re: [Maria-discuss] Help to compile MariaDB 10.2.6 - Debian 8.8

Hi, Guillermo! On Jun 20, Guillermo Cespedes wrote: > Hello how are you? > > When doing the MariaDB compilation it gives me error if I do not have gnutls. > After compiling gnutls and their dependencies. MariaDB compiles well. > > But I'm interested in compiling MariaDB with OpenSSL and not

Re: [Maria-discuss] memory allocators and MariaDB

Hi, Reindl! On Jun 20, Reindl Harald wrote: > >> > >> the mariadb build below is built without tokudb > > > > Is it 10.2? > > 10.1.24 Ah, okay. > > I've removed jemalloc dependency in 10.2.5, commit bf40e8069cd6952 > > i don't get why it is not used everywhere at all > trafficsevrer and

Re: [Maria-discuss] memory allocators and MariaDB

Hi, Reindl! On Jun 20, Reindl Harald wrote: > > On Jun 20, MARK CALLAGHAN wrote: > >> Do MariaDB 10.2 binaries use glibc malloc or get built with one of tcmalloc > >> or jemalloc? Sorry for being lazy, as I have yet to install it. > > > > glibc malloc. > > Only ha_tokudb.so gets linked with

Re: [Maria-discuss] memory allocators and MariaDB

Hi, MARK! On Jun 20, MARK CALLAGHAN wrote: > Do MariaDB 10.2 binaries use glibc malloc or get built with one of tcmalloc > or jemalloc? Sorry for being lazy, as I have yet to install it. glibc malloc. Only ha_tokudb.so gets linked with jemalloc. Regards, Sergei Chief Architect MariaDB and

Re: [Maria-discuss] Help to compile MariaDB 10.2.6 - Debian 8.8

Hi, Guillermo! On Jun 19, Guillermo Céspedes Tabárez wrote: > Hello I need help to add in my script ( > https://gist.github.com/dertin/8de14e458dd4f0d3acb5f0deff120951#file-install-sh-L232 > ) > the compilation of "MariaDB 10.2.6" from its source code. > Must work for Debian 8.8 32bit and 64bit

Re: [Maria-discuss] MariaDB and Intel TSX

Hi, Reindl! On Jun 19, Reindl Harald wrote: > does MariaDB make usage of TSX on newer hardware or at least using > glibc for the query cache mutex which would implicit benfit form it? MariaDB does not explicitly use it. But it uses system mutexes, so if glibc uses that for mutexes, MariaDB will

Re: [Maria-discuss] mariadb 10.2.6 make test failures

Hi, Bruce! On Jun 18, Bruce Dubbs wrote: > I am trying to build mariadb from source on a linux system. I used this > procedure: > > mkdir build > cdbuild > cmake -DTOKUDB_OK=0 .. > make > make test > > The build goes fine, but the output of make test gives: > > 74% tests passed, 21 tests

Re: [Maria-discuss] Question about mariadb 10.2 "rows" keyword

Hi, Markus! On Jun 14, Markus Mäkelä wrote: > Hi, > > Checking this list > seems to confirm that it's not documented as a reserved word but it is > in sql/lex.h which means it's a keyword. I'd suggest adding it to the > list of documented

Re: [Maria-discuss] lz4 innodb compression

Hi, Reinis! On Apr 28, Reinis Rozitis wrote: > Hello, > is lz4 support not compiled in the Mariadb rpm (Opensuse) packages or are > there some runtime requirements or you have to rebuild from source? Not compiled in, you have to rebuild from source. This is the command line we're using:

Re: [Maria-discuss] userstats Denied_connections

Hi, Rhys.Campbell! On Apr 26, rhys.campb...@swisscom.com wrote: > Hello All, > > I've been using the userstats plugin do debug an application issue and > I think there's a bug in the collection of statistics, or at least a > case of bad wording... > >

Re: [Maria-discuss] MariaDB Server maintenance policy for 10.0

Hi, Colin! On Apr 27, Colin Charles wrote: > > Hi, Colin! > > > > On Apr 26, Colin Charles wrote: > >> Hi! > >> > >> I just read: > >>https://mariadb.org/about/maintenance-policy/ > >> > >> It says the 5 year boundary date for support ending for 10.0 is 31 > >> Mar 2019, and later goes on

Re: [Maria-discuss] MariaDB Server maintenance policy for 10.0

Hi, Colin! On Apr 26, Colin Charles wrote: > Hi! > > I just read: > https://mariadb.org/about/maintenance-policy/ > > It says the 5 year boundary date for support ending for 10.0 is 31 Mar > 2019, and later goes on to specify why 5.5 has a later EOL, "The > MariaDB Foundation may decide

Re: [Maria-discuss] logrotate

Hi, Daniel! On Apr 18, Daniel Black wrote: > > 1. What user logrotate is normally run as? > root So, unix_socket plugin is an option. In fact, as I realize now (all to late), it's always an option, even if logrotate would be using a special "logrotate" user, we could've still created

Re: [Maria-discuss] logrotate

Hi, Daniel! On Apr 10, Daniel Black wrote: > Quick proof of concept logrotate that hasn't really been changed in a while. > > The aim is to get this closer to a state for distro maintainers to use > directly. > > By using a dedicated SQL user this shouldn't conflict with an existing > user root

Re: [Maria-discuss] innodb table single column index max length

Hi, butler! On Apr 17, butler wrote: > we know the mysql have a limit that the max index length on a single > column is 767.I want know how the 767 come from ? why not 799 or 800 > etc. 768 is 256*3, originally selected to fit 256 characters in utf8 charset, each character can be up to 3 bytes

Re: [Maria-discuss] searching for etc/my.cnf and CMAKE_INSTALL_PREFIX

Hi, Mark! On Apr 05, Mark Callaghan wrote: > Maybe someone should edit the too strong claims on > https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ > > In bold at the top of the page... > > MariaDB is a binary drop in replacement for MySQL Indeed. I'll do it. Althought KB

Re: [Maria-discuss] Problem Upgrade MariaDb 5.5.52 MariaDb 10.1.22

Hi, Wilmer! On Mar 21, Wilmer Arambula wrote: > Hi, i have a system running perfectly on mariadb 5.5.52, i will change > everything to a new server with mariadb 10.1.22, but running the > installation script gives me problems, this is the error, is there any way > to configure mariadb 10.1.22 To

Re: [Maria-discuss] Missing MariaDB Seal logos?

Hi, Colin! On Oct 16, Colin Charles wrote: > Hi! > > Visiting: > https://mariadb.com/kb/en/mariadb/branding-guidelines/ > > You’ll note that the Powered by MariaDB badges still exist > (https://mariadb.org/about/logos/) — they should really say Powered by > MariaDB Server > > But what is

Re: [Maria-discuss] Questions to temporary myisam table files

Hi, Sebastian! On Mar 20, Hempel, Sebastian wrote: > Hi Sergei, > > thanks a lot for the fast answer. > > From time to time we see tablename.myd-date or tablename.myd.bak files > where are these coming from? Right, missed that, sorry. I don't think you're seeing tablename.myd-date or

Re: [Maria-discuss] MariaDB 10.1.22 now available

Hi, Reindl! On Mar 16, Reindl Harald wrote: > > https://github.com/mariadb/server/commit/2c2bd8c1556b081fccd0fc3e010dc3ea2c38fffb.patch > + /usr/bin/patch --no-backup-if-mismatch -p1 --fuzz=0 > patching file include/my_sys.h > Hunk #1 succeeded at 646 (offset 49 lines). > patching file

Re: [Maria-discuss] Exclusive lock not working

Hi, Jesse! On Mar 17, Jesse Schalken wrote: > I have a transaction that checks if a row exists with a particular value > and if not, generates the data for that row and inserts it: > > -- schema > > CREATE TABLE test ( > col INT, > data TEXT, > KEY (col) > ); > > -- transaction > >

Re: [Maria-discuss] Questions to temporary myisam table files

Hi, Hempel,! On Mar 17, Hempel, Sebastian wrote: > Hallo, > > there is a known issue with the repair table function (MDEV-5871, > MDEV-8475), which was fixed in MariaDB 10. Which is fine, but we have > still MariaDB 5.5 server running. > > So we created our own repairtable function to work

Re: [Maria-discuss] MariaDB 10.1.22 now available

Hi, Reindl! On Mar 14, Reindl Harald wrote: > > Am 14.03.2017 um 16:52 schrieb Reindl Harald: > > > > > > Am 14.03.2017 um 16:43 schrieb Daniel Bartholomew: > >> The MariaDB project is pleased to announce the immediate availability > >> of MariaDB 10.1.22. This is a stable (GA) release. See the

Re: [Maria-discuss] timestamp with time zone support mariaDB 10.1.14

Hi, Karthick! On Feb 23, Karthick Subramanian wrote: > Hi Experts, > > I got this error, not sure whether maria db supports time zone: > > MariaDB [devdb]> create table ts (dt datetime, tz timestamp with time zone); > ERROR 1064 (42000): You have an error in your SQL syntax; check the manual >

Re: [Maria-discuss] default_tmp_storage_engine=NULL

Hi, Ian! On Feb 09, Ian Gilfillan wrote: > What is the purpose/effect of having MariaDB's > default_tmp_storage_engine setting default to NULL instead of the > default used in MySQL, Innodb? I can't see any obvious differences in > behaviour. NULL means "same as default_storage_engine" That

Re: [Maria-discuss] for years failing tests

Hi, Reindl! On Jan 20, Reindl Harald wrote: > looks like many of them are caused by "--mysqld=--binlog-format=mixed" > but without a ton of tests are skipped with "Neither MIXED nor STATEMENT > binlog format" what i really don't understand when you configure and > start mysqld scripted > >

Re: [Maria-discuss] what about cleanly deprecation of config options

Hi, Reindl! On Jan 20, Reindl Harald wrote: > why do we have here ON/OFF and YES/NO at all > > -DWITH_XTRADB=1 \ > -DWITH_PARTITION=1 \ > -DWITHOUT_ARCHIVE=1 \ > -DWITHOUT_BLACKHOLE=1 \ > -DWITHOUT_CASSANDRA=1 \ > -DWITHOUT_MROONGA=1 \ > -DWITHOUT_OQGRAPH=1 \ >

Re: [Maria-discuss] for years failing tests

Hi, Reindl! I cannot repeat this. I get: rpl.rpl_binlog_index 'row' [ skipped ] Not ROW format rpl.sec_behind_master-5114 'stmt'[ skipped ] Not STATEMENT format rpl.rpl_semi_sync_event_after_sync 'innodb,mix' [ pass ] 10470 (it's innodb in my build, but that shouldn't

Re: [Maria-discuss] what about cleanly deprecation of config options

Hi, Reindl! On Jan 20, Reindl Harald wrote: > what about spit some warnings in 10.0.x releases instead after update to > 10.1.x service not starting and you can look what confdig options needs > to be removed > > 2017-01-20 16:34:36 140555676232000 [ERROR] /usr/libexec/mysqld: unknown >

Re: [Maria-discuss] limiting memory use by mariadb?

Hi, l! On Dec 28, l vic wrote: > Is there some way to set hard limit for use of RAM by mariaDB server? > Thanks, > -V Just FYI: In the next 10.1 release there will be a variable that sets a hard limit of RAM that can be allocated in one connection. Regards, Sergei Chief Architect MariaDB and

Re: [Maria-discuss] possible bug? #innodb-encryption-threads

Hi, lejeczek! On Dec 01, lejeczek wrote: > hi everyone > > I'm having a peculiar situation, a problem here with my > config, which config is pretty galera-vanilla. > Namely, if I set these: > > plugin-load-add = file_key_management.so > file-key-management > file-key-management-filename =

Re: [Maria-discuss] Download speeds on archive.mariadb.org

Hi, Guillaume! On Nov 12, Guillaume Lefranc wrote: > Hi Sergei! > > I am not sure where the mirror is. I needed a specific release of MariaDB > (10.1.16) and the downloads page redirected me to this server. I'm just > imagining what other, less informed users will experience themselves. Ah, I

Re: [Maria-discuss] Download speeds on archive.mariadb.org

Hi, Peter! On Nov 12, Peter Laursen wrote: > Right now I get around 50 kbps on archive.mariadb.org. This means > that a complete server package (with tests etc.) could take ~10 hours > to download. Or even 4 days with the 6 kbps that Guillaume > experiences (all roughly calculated numbers). >

Re: [Maria-discuss] Download speeds on archive.mariadb.org

Hi, Guillaume! On Nov 12, Guillaume Lefranc wrote: > Hi everyone, > > Download speeds on archive.mariadb.org have reached an abysmal level - > 6kb/s today. Honestly, what is the foundation waiting for to solve > this issue that has been lasting for years? I am ready to donate > server space and

Re: [Maria-discuss] on stored procedures

Hi, Richard! On Nov 08, Richard Bensley wrote: > Will we ever see a return of prepared statement parameters that were > introduced then removed in 10.2? What do you mean? Regards, Sergei Chief Architect MariaDB and secur...@mariadb.org ___ Mailing

Re: [Maria-discuss] on stored procedures

, 2016 at 10:43 AM, Sergei Golubchik <s...@mariadb.org> wrote: > > Hi, Federico! > > > > On Nov 07, Federico Razzoli wrote: > > > Some good points from Bill Karwin: > > > https://www.quora.com/What-are-the-reasons-not-to-use-or- > > not-u

Re: [Maria-discuss] on stored procedures

Hi, Federico! On Nov 07, Federico Razzoli wrote: > Some good points from Bill Karwin: > https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-procedures/answer/Bill-Karwin Thanks. These are valid points, and some of them are related. For example, "does not have a rich library

Re: [Maria-discuss] MYSQL_OPT_CONNECT_TIMEOUT default?

Hi, Peter! Oops. Sorry, my mistake. I mean "unlimited". No timeout. On Nov 03, Peter Laursen wrote: > Does "undefined" in practice mean "none" or "random/non-deterministic" > then? > > -- Peter > > On Wed, Nov 2, 2016 at 11:52 PM, S

Re: [Maria-discuss] MYSQL_OPT_CONNECT_TIMEOUT default?

Hi, Peter! According to Georg, MariaDB Connector/C default is 0, which is interpreted as "undefined". On Oct 28, Peter Laursen wrote: > MySQL docs page http://dev.mysql.com/doc/refman/5.7/en/mysql-options.html > > *MYSQL_OPT_CONNECT_TIMEOUT (argument type: unsigned int *)* > *The connect

Re: [Maria-discuss] User feedback plugin - reporting broken?

Hi, Colin! On Oct 23, Colin Charles wrote: > Hi, > > See https://mariadb.org/feedback_plugin/stats/server_count_by_month/ > > Is the reporting broken? August to September has a huge drop in > reporting servers. Yes, thanks a lot! There was something wrong with a cron job. Bryan fixed it and

Re: [Maria-discuss] Virtual CHECK constraint using Virtual columns

Hi, Peter! On Oct 16, Peter Laursen wrote: > Didn't CHECK CONSTRAINTS get introduced in MySQL 8? Then better port it > from there into MariaDB I think. -- Peter I'm afraid you've got it backwards :) MySQL 8.0 has no CHECK constraint (at least it's not mentioned in

Re: [Maria-discuss] MariaDB Server 10.3 notes

Hi, Justin! Very good questions, thanks! Some answers below: On Oct 12, Justin Swanhart wrote: > > > * InnoDB: InnoDB native partitioning - so MySQL 8 InnoDB? But Monty > > says there's next to no changes in InnoDB 8... Instant add column. > > New InnoDB deadlock detection (8.0). New

Re: [Maria-discuss] (/usr/include/mysql and libmysqlclient) vs (/usr/include/mariadb libmariadbclient and libmariadb)

Hi, james! On Oct 03, james harvey wrote: > First, let me clarify everything here is MariaDB - nothing actually > involving the MySQL code. > > In Arch Linux, I'm running a MariaDB server and client. I installed > the mariadb package, built from the source at: > >

Re: [Maria-discuss] MariaDB Server 10.3 notes

Hi, all! Thanks, Colin! Just for the sake of everyone who wasn't present there, I want to remind that these were discussions and plans, not promises. Nothing of this (written below) is guaranteed to happen, although certain items have a high probability of being done as planned. On Oct 12,

<    1   2   3   4   >