Re: [Maria-discuss] Question regarding mariadb-dump/mysqldump and rocksdb

2023-05-14 Thread Daniel Black
Sorry for delayed response Jonas, It looks like quite a good addition. Please request a task https://jira.mariadb.org As you've seen the code, you're welcome to make an addition (in connect_to_db). On Tue, Apr 25, 2023 at 12:53 AM Jonas Krauss wrote: > > Hi MariaDB, > > in Myrocks / Facebook

Re: [Maria-discuss] mariadb crash und recovery

2023-04-18 Thread Daniel Black
bug report https://jira.mariadb.org or here welcome. Daniel Black On Mon, Apr 17, 2023 at 9:05 PM wrote: > > Hello list, > i had a crash at weekend with no apparend cause. > The aria engine did a recovery without furture problems. > Maybe that is a hint that somebody can make use of

Re: [Maria-discuss] Creating a trigger on information_schema.processlist

2023-02-27 Thread Daniel Black
On Tue, Feb 28, 2023 at 9:31 AM Gordan Bobic wrote: > > A long standing annoyance has been that stored procedures are opaque > when it comes to profiling them with more granularity than just the > entire procedure. > > SHOW FULL PROCESSLIST shows the individual queries while they are > running,

Re: [Maria-discuss] DBMS vs Storage Engine Alone

2022-12-15 Thread Daniel Black
On Fri, Dec 16, 2022 at 12:44 PM Jonathan M. Wilbur wrote: > Sorry to ask this question here, since it is not strictly MariaDB-related, > but I need the knowledge of people that develop with databases: is there > significant overhead to using a DBMS versus a storage engine directly? > DBMS add

Re: [Maria-discuss] Maria-db refuses to start

2022-11-15 Thread Daniel Black
> The log from this failure (/var/log/mysqld.log): > > 2022-11-10 20:22:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.12 > 2022-11-10 20:22:34 0 [Note] InnoDB: Number of transaction pools: 1 > 2022-11-10 20:22:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions > 2022-11-10 20:22:34 0

Re: [Maria-discuss] Maria-db refuses to start

2022-11-08 Thread Daniel Black
On Wed, Nov 9, 2022 at 12:01 AM Jogchum Reitsma wrote: > > Op 08-11-2022 om 13:04 schreef Marko Mäkelä: > > Hi Jogchum, > > On Tue, Nov 8, 2022 at 1:21 PM Jogchum Reitsma > wrote: > [...] > > 2022-11-08 12:06:17 0 [Warning] 'innodb-file-format' was removed. It does > nothing now and exists only

Re: [Maria-discuss] Migration path for unix_socket authentication plugin

2022-10-14 Thread Daniel Black
On Fri, Oct 14, 2022 at 12:55 AM William Edwards wrote: > > Hi, > > On MariaDB servers that were installed with >= MariaDB 10.4, I have one > root user that was created as: > > MariaDB [(none)]> show create user 'root'@'localhost'; > CREATE USER `root`@`localhost` IDENTIFIED VIA

Re: [Maria-discuss] Maria-db refuses to start

2022-10-12 Thread Daniel Black
On Thu, Oct 13, 2022 at 12:27 AM Jogchum Reitsma wrote: > Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test > can't be created and how to solve that? In systemd ProtectHome=read-only is the default. systemctl edit mariadb.service and add: [Service] ProtectHome=false

Re: [Maria-discuss] ibtmp1 for internal temporary tablespaces

2022-08-09 Thread Daniel Black
William, On Mon, Aug 8, 2022 at 7:59 PM William Edwards wrote: > > Hi, > > User-created temporary tables are stored in ibtmp1. Are internal > temporary tablespaces (those created by MariaDB while executing queries) > too? >From

Re: [Maria-discuss] 485 GB of galera.page.xxxxx files never deleted!?

2022-08-01 Thread Daniel Black
Like: https://dba.stackexchange.com/questions/306131/mariadb-galera-cluster-filling-disk-with-gcache-page-files and linked MDEVs I haven't followed your other thread to identify your versions used. If the linked MDEVs aren't relevant to your newer version, please create a new issue. Comments

Re: [Maria-discuss] Custom Galera SST Method Documentation

2022-05-27 Thread Daniel Black
Sure, There's https://galeracluster.com/library/documentation/scriptable-sst.html And the configuration is derived from wsrep_sst_method (https://galeracluster.com/library/documentation/mysql-wsrep-options.html#wsrep-sst-method) On Fri, May 27, 2022 at 5:41 PM Gordan Bobic wrote: > > Hi, > >

Re: [Maria-discuss] Galera: jump through major versions at once

2022-05-18 Thread Daniel Black
William, Recently a lot of testing was done on this (https://jira.mariadb.org/browse/MDEV-27437). >From reading https://jira.mariadb.org/browse/MDEV-28247 an upgrade to 10.3.35 might be required first (or an explicit disable of background merge - if possible). So sst=rsync is required with

Re: [Maria-discuss] demo: running MariaDB with rootless Podman and socket activation

2022-02-16 Thread Daniel Black
On Mon, Feb 14, 2022 at 6:37 PM Erik Sjölund wrote: > > Hi Daniel, > Thanks for the feedback. > > On Thu, Feb 10, 2022 at 4:40 AM Daniel Black wrote: > > There's some really powerful concepts with unix_socket auth across > > into the container if you get the uid mappi

Re: [Maria-discuss] demo: running MariaDB with rootless Podman and socket activation

2022-02-09 Thread Daniel Black
Erik, Thanks for the email and repository. On Wed, Feb 9, 2022 at 9:18 AM Erik Sjölund wrote: > > Hi, > Support for socket activation was added to MariaDB in release 10.6 > (released April 2021). Podman also supports socket activation Nice. I saw some bits around sdnotify but didn't realize

Re: [Maria-discuss] Weird behavior in Fedora 34 server

2022-01-04 Thread Daniel Black
, 2022 at 10:18 PM Honza Horak wrote: > > Ha, I failed to see this reply, so will close > https://bugzilla.redhat.com/show_bug.cgi?id=2036572 as a duplicate of this > original one. > > Honza > > On Fri, Dec 31, 2021 at 2:37 AM Daniel Black wrote: >> >> On

Re: [Maria-discuss] Weird behavior in Fedora 34 server

2021-12-30 Thread Daniel Black
On Fri, Dec 31, 2021 at 12:31 PM Daniel Black wrote: > > There's no reported bug of this on bugzilla.redhat.com either, so if > you have time, please report there too. Actually found it - https://bugzilla.redhat.com/show_bug.cgi?i

Re: [Maria-discuss] Weird behavior in Fedora 34 server

2021-12-30 Thread Daniel Black
ovs-master-fedora. > All those failures are due to this problem with mysqladmin. As it can be > seen in the job's page, the problem started showing up on December 13th. > > Any ideas as to what might be the root problem? > > Thanks > > Miguel > > On Wed, Dec 29, 2021 a

Re: [Maria-discuss] Weird behavior in Fedora 34 server

2021-12-29 Thread Daniel Black
Hi Miguel, On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle wrote: > > Hi, > > I am installing MariaDB in Fedora 34 server with the following sequence of > commands: > > sudo dnf upgrade -y > sudo dnf install -y mariadb-server mariadb-devel > sudo dnf -y install git vim > > With this sequence of

Re: [Maria-discuss] sys schema backup

2021-12-03 Thread Daniel Black
It can be skipped. An installation or a mysql_upgrade will recreate it. On Sat, Dec 4, 2021 at 12:27 AM William Edwards wrote: > > Hi, > > The 'sys' schema is documented to be "A collection of views, functions > and procedures to help MySQL administrators get insight in to MySQL > Database

Re: [Maria-discuss] How can I separate one test from mysql_test

2021-11-18 Thread Daniel Black
On Fri, Nov 19, 2021 at 8:13 AM Sergei Golubchik wrote: > > Hi, Lukas! > > This looks very strange. Perhaps, indeed, the previous server process > didn't die and is still bound to the port 16020? > > This is not very likely, mtr kills all processes with -9, there > shouldn't be anything hanging

Re: [Maria-discuss] mariadb 10.4.13-lp152.1.1 to 10.5.12-3.9.1 upgrade failure

2021-11-04 Thread Daniel Black
Marc, Sorry to see you encountered this. I searched https://jira.mariadb.org and cannot find a similar issue. Can you please create a bug report. A mariadbackup might hit exactly the same issue. A mysqldump/restore will regenerate the innodb space listed as corrupt. On Fri, Nov 5, 2021 at

Re: [Maria-discuss] State of "alternative" engines and mariadb

2021-10-19 Thread Daniel Black
On Tue, Oct 19, 2021 at 12:14 AM pslawek83 wrote: > > Hi Guys, And everyone else too. > what's the state of "alternative" engines (aria and rocks). AFAIR there were > some plans to make aria much more advanced than myisam, transactional > (transaction safe?) and more optimized for todays

Re: [Maria-discuss] DBSeeder Version 3.0.3

2021-09-12 Thread Daniel Black
Hey Walter, Thanks for sharing. The 73.7% mariadb drop is in the query speed(?) is compared to which other measurement? An earlier MariaDB version and/or a new DBSeeder version? On Sun, Sep 12, 2021 at 10:55 PM Walter Weinmann < walter.at.konnexi...@gmail.com> wrote: > We are pleased to

Re: [Maria-discuss] DBSeeder Version 2.9.0

2021-06-06 Thread Daniel Black
Thanks Walter for letting everyone know. I did play around with it as it might be useful in attempting to replicate sample data for users experiencing problems. What was your intended purpose when creating this? Suggestions/minor problems that I came up with testing it: It doesn't compile

Re: [Maria-discuss] Is it possible to upgrade SHA-1 and MD5 algorithms in Mariadb-10.5?

2021-03-18 Thread Daniel Black
md5: extra/mariabackup/xbcloud.cc - old bit, however for old reasons used md5 as a checksum on a storage format. I'm think can be removed before RHEL9 In SQL there is a MD5 function, we can't just replace that as it will break user applications. sha1: also a SQL function.

Re: [Maria-discuss] Why does MariaDB needs SELinux capability for setuid/setgid?

2021-03-16 Thread Daniel Black
o. Happy to help if I can. Thanks for clarifying > Lukas > > On Sun, Mar 14, 2021 at 12:42 AM Daniel Black wrote: > >> >> This was relaxed in https://github.com/MariaDB/server/commit/27e6fd9a5968 >> where the setuid is only tried if mariadbd --user is specified.

Re: [Maria-discuss] Why does MariaDB needs SELinux capability for setuid/setgid?

2021-03-13 Thread Daniel Black
This was relaxed in https://github.com/MariaDB/server/commit/27e6fd9a5968 where the setuid is only tried if mariadbd --user is specified. This isn't the case with systemd service files (which set the user) https://github.com/MariaDB/server/blob/10.5/support-files/mariadb.service.in#L50 where the

Re: [Maria-discuss] mdb 10.4.13 manual delete/recreate of 'root' user fails: ERROR 1471 (HY000): The target table user of the INSERT is not insertable-into ?

2020-06-21 Thread Daniel Black
On Sun, 21 Jun 2020 18:24:19 -0700 PGNet Dev wrote: > On 6/21/20 5:47 PM, Daniel Black wrote: > >> what different/additional steps are required to recreate a deleted root > >> user? > > > > There are perfectly usable SHOW CREATE USER > > (https://mari

Re: [Maria-discuss] mdb 10.4.13 manual delete/recreate of 'root' user fails: ERROR 1471 (HY000): The target table user of the INSERT is not insertable-into ?

2020-06-21 Thread Daniel Black
On Sun, 21 Jun 2020 16:34:25 -0700 PGNet Dev wrote: >  i've installed distro-packaged MDB > > mariadb -V > mariadb Ver 15.1 Distrib 10.4.13-MariaDB, for Linux (x86_64) > using readline 5.1 > > on > > lsb_release -rd > Description:Arch Linux >

Re: [Maria-discuss] setting db root passwd failed now reinstall is failing

2020-06-19 Thread Daniel Black
On Fri, 19 Jun 2020 12:27:02 -0700 ubu...@enabled.com wrote: > Hi there, > > I am doing a poor job installing mariadb. Yes. > I need to install mariadb on a new ubunutu server. Yes. > I attempted to set the root password and was having difficulties getting > mariadb in a usable state after

Re: [Maria-discuss] Error writing to binary log file

2020-05-28 Thread Daniel Black
On Thu, 28 May 2020 16:24:23 -0300 Gustavo Vieira wrote: > Hello, > > I have several MariaDB 10.1.45 instances running in Linux containers > with memory limits. > Sounds like your out of memory that happens to be showing up when you write to the binary log. Can you monitor the memory use

Re: [Maria-discuss] Mariadb 10.3 crashing continuously on Centos 8

2020-05-17 Thread Daniel Black
On Sun, 17 May 2020 16:00:29 +0200 Ralf Hartings wrote: > Hi > > My up-to-date Wordpress website running with mariadb 10.3 on CentOS8 (up > to date) has been running for a long time without any issues. > Suddenly, yesterday, my server became unreachable and did not respond to > anything. Only

Re: [Maria-discuss] OSX fix need on MariaDB-10.5

2020-05-08 Thread Daniel Black
On Fri, 8 May 2020 14:35:29 -0400 Justin Swanhart wrote: > You don't have hardware to work on your own supported platform? Or you > can't figure it out? > I didn't have hardware, However thanks to Etienne Guesnet AIX was having the same fault and came up with this patch which allows most of

[Maria-discuss] OSX fix need on MariaDB-10.5

2020-04-27 Thread Daniel Black
://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/Get.20OSX.20working.20on.2010.2E5.20-.20MDEV-22173 To paraphrase J.F.Kennedy ask not what your database server community can do for you — ask what you can do for your database server community. Keep the community spirit going, Daniel Black

Re: [Maria-discuss] 回复: Some questions about the Aarch64 CI

2019-12-10 Thread Daniel Black
On Tue, 10 Dec 2019 21:54:37 + Gordan Bobic wrote: > I thought EL7 is very much supported with aarch64. If that is the case > won't what you are suggesting effectively abandon EL7? I suggest that to help Red Hat get the ARM support you: a) search https://bugzilla.redhat.com/ for anything

Re: [Maria-discuss] Some questions about the Aarch64 CI

2019-11-26 Thread Daniel Black
On Tue, 26 Nov 2019 10:56:41 +0200 Marko Mäkelä wrote: > Hi Daniel, > > On Tue, Nov 26, 2019 at 2:02 AM Daniel Black wrote: > > > > On Mon, 25 Nov 2019 11:32:07 +0200 > > Marko Mäkelä wrote: > > > > > > > I also found a claim that POWER8 supp

Re: [Maria-discuss] Some questions about the Aarch64 CI

2019-11-25 Thread Daniel Black
le 80486 BSWAP instruction, or an AMD64 MOVBE > instruction. Yes, compilers are getting pretty good as are libc implementations of occasionally re-invented code (threads, mutexes, copy functions etc.). Daniel Black IBM Power systems ___ Mailing

Re: [Maria-discuss] MariaDB 10.4.8

2019-10-03 Thread Daniel Black
On Thu, 3 Oct 2019 10:27:01 +0200 Thomas Plant wrote: > Hello, > > we have a client VM with MariaDB 10.4.8 which crashes always on the same > query (it's in the log). Can someone help me to debug the problem, or is > it already known problem? Server ist a CentOS 7 patched up to date and >

Re: [Maria-discuss] fsync alternative

2019-09-15 Thread Daniel Black
conf.org/event/4/page/34-accepted-microconferences#db > where both the atomic writes and fsync() were discussed. I hope that > Sergei Golubchik or Daniel Black can report more on that. In any case, > it might take years before these improvements become available in > Linux distributions; with lu

Re: [Maria-discuss] System lock thread state

2019-07-24 Thread Daniel Black
On Wed, 24 Jul 2019 14:00:05 -0400 mari...@biblestuph.com wrote: > On a system with skip-external-locking = ON, why would I ever see a > thread state of "System lock" on a MyISAM table? Explicit "FLUSH TABLES WITH READ LOCK" in effect in one of the threads I assume.

Re: [Maria-discuss] Rolling upgrade to Galera 10.4 not working

2019-06-27 Thread Daniel Black
On Thu, 20 Jun 2019 17:59:26 +0200 Tiemen Ruiten wrote: > On the donor, I see: > > ... > 2019-06-20 16:24:48 0 [ERROR] WSREP: Failed to read from: > wsrep_sst_rsync --role 'donor' --address > '10.100.130.24:/rsync_sst' --socket '/var/lib/mysql/mysql.sock' > --datadir '/var/lib/mysql/' ''

[Maria-discuss] MariaDB-10.4 / Galera and GTIDs - aka we now have two different GTID implementations

2019-03-03 Thread Daniel Black
Hi, I was excited to come across the Galera-4 release notes and blog. http://galeracluster.com/2019/02/galera-cluster-4-available-for-use-in-the-latest-mariadb-10-4-3-release-candidate/ It was good to see causal read functions that I'd hoped for in https://jira.mariadb.org/browse/MDEV-10715.

Re: [Maria-discuss] Character set & BLOBS on MySQL

2018-11-07 Thread Daniel Black
On Wed, 7 Nov 2018 13:29:09 + Andrew Wood wrote: > Also is there a way for the client to specify the correct settings > for reading/writing BLOBS on a per connection basis as it might not > always be possible to alter the server? BLOBS don't have a character set, TEXT and varchar do. You

Re: [Maria-discuss] adding syslog crashes container

2018-10-29 Thread Daniel Black
On Tue, 30 Oct 2018 08:58:35 +1100 Paul Chubb wrote: > hi I am trying to get Mariadb to log to syslog - this is for log > consolidation etc. I am using Maria in a docker container from docker > hub. Other things from the container are successfully logging to > syslog on my logging server but

Re: [Maria-discuss] My Solution to MariaDB Database Server Crashed in Experimental Online Store

2018-10-22 Thread Daniel Black
On Mon, 22 Oct 2018 10:28:31 + Turritopsis Dohrnii Teo En Ming wrote: > Good evening from Singapore, > > > My virtual server is an Amazon AWS Linux instance. I only gave it 1 > GB of RAM. > > > How much RAM/memory do I need to support MariaDB SQL database server > without crashing?

Re: [Maria-discuss] community contribution measurement page

2018-07-22 Thread Daniel Black
On Sun, 22 Jul 2018 14:32:42 +0300 Vicențiu Ciorbaru wrote: > Hi Daniel! > > Some pr's get merged by a separate commit and the issue itself gets > closed, not merged on github. Do your graphs catch that use case? Most likely not - the data is largely based on what github exposes in their API.

Re: [Maria-discuss] community contribution measurement page

2018-07-22 Thread Daniel Black
merged/rebased in background (as Vicențiu suggested), I think 60% is something to be proud of. As a measure subject to varying effects, its relative performance probably would need to be very careful about inferences made. > On Jul 22, Daniel Black wrote: > > > > > > Fol

[Maria-discuss] community contribution measurement page

2018-07-21 Thread Daniel Black
Folks, I've prepared a community contribution measurement page: http://measure-mariadb.ozlabs.org/repo/mariadb/server-outside-org.html This is largely the code base of https://github.com/MeasureOSS/Measure known errors: * I've yet to create the organisation aspects of this site. * some top

Re: [Maria-discuss] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so'

2017-07-03 Thread Daniel Black
On 03/07/17 22:54, Jonathan Gazeley wrote: > On 03/07/17 13:38, Ian Gilfillan wrote: >> On 03/07/2017 14:13, Jonathan Gazeley wrote: >>> >>> It fails to find auth_socket.so, but when I check in yum what >>> provides that file, only MariaDB 5.5 from the CentOS repo has it, but >>> not MariaDB

Re: [Maria-discuss] AWS Key Management plugin

2017-05-09 Thread Daniel Black
On 10/05/17 05:59, Christopher Hendry wrote: > Currently configuring MariaDB for at rest encryption using Amazon key > management. > > A few weeks ago, I setup our primary server with no problems (Centos > 7). Recently, working on the same hardware/OS for slaves - when I do a > yum install

Re: [Maria-discuss] logrotate

2017-04-17 Thread Daniel Black
On 18/04/17 05:59, Sergei Golubchik wrote: > 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 >> directl

Re: [Maria-discuss] "Error: MySQL server has gone away" issue while running mariadb database

2017-04-10 Thread Daniel Black
On 11/04/17 15:15, Geunsik Lim wrote: > For reference, We are running web-based front service > with nodejs package + pm2 (http://pm2.keymetrics.io/) on Ubuntu 16.04.1 > server. > > It seems that this issue results from the too big packet size and too > long waiting time > between mariadb

[Maria-discuss] logrotate

2017-04-09 Thread Daniel Black
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 user (which users always use despite the ability create

Re: [Maria-discuss] mysqladmin - flush failed: Unknown error

2017-03-30 Thread Daniel Black
e to create new logs in /var/log/. I'd normally expect /var/log/mysql to be owned by the mysql user and its configuration to log the error to a file in this directory. > I've > added some extra information gathering, so we'll see how it runs tonight. > > > On 27 March 2017 at 22:3

Re: [Maria-discuss] Cross compile error

2017-03-27 Thread Daniel Black
On this error I'm not sure. Looks to be some sort of inheritance hierarchy that is different in musl from glibc et al. I'd chase them up to see who is violating the C++ spec. Have you tried using buildroot? It has a stable 10.1 version that is kept up to date and it has the one outstanding uclibc

Re: [Maria-discuss] mysqladmin - flush failed: Unknown error

2017-03-27 Thread Daniel Black
I think you'll find that the mysql user don't have permissions to create a new file in /var/log/. As such logrotate renames the file which is still open by mysqld. As such it is now writing to mysqld.log.1. On 28/03/17 00:13, Matthew Pash wrote: > Hi, > > We've got some database servers running

Re: [Maria-discuss] Change to innodb_large_prefix with respect to creating long indexes

2017-03-06 Thread Daniel Black
On 07/03/17 13:00, Marco Nicosia wrote: > Hi there, > > We noticed a change between MariaDB 10.1.18 and 10.1.20, but I haven't > been able to find anything in the changelogs or JIRA that would help me > understand what changed, and why. > > On 10.1.18, if I set `innodb_large_prefix=OFF` I can

Re: [Maria-discuss] mysqldump 10.1.16

2017-02-15 Thread Daniel Black
On 15/02/17 19:02, Karthick Subramanian wrote: > All, > > I got a replciation problem and planned to take master server dump using > below command and tried to restore in slave server: > > mysqldump --skip-lock-tables --single-transaction --flush-logs > --hex-blob --master-data=1 -A --routines

Re: [Maria-discuss] MariaDB Fedora update - testing

2017-01-30 Thread Daniel Black
On 31/01/17 00:31, Michal Schorm wrote: > Hi Daniel and thanks for a reply! > > I'll parse the mail you send a little: > > *1) Move "mysqldump, mysqlbinlog, mysqlcheck, mysql_upgrade" and their > manpages to dependent package. > * * I'm really not going to make another subpackage only with

Re: [Maria-discuss] MariaDB Fedora update - testing

2017-01-29 Thread Daniel Black
On 27/01/17 22:58, Michal Schorm wrote: > Hello everybody, > > I made a (form my POV) bigger change to how MariaDB is packed, and I > would be grateful for any feedback. Thanks for continuing with this. > I separated all the non-essential utilities to a standalone sub-package >

Re: [Maria-discuss] 10.1.21 - tests: main.analyze_stmt_orderby 'xtradb' w4 [ fail ]

2017-01-22 Thread Daniel Black
Merry Christmas: https://github.com/MariaDB/server/pull/292 On 22/01/17 04:49, Reindl Harald wrote: > main.analyze_stmt_orderby 'xtradb' w4 [ fail ] > Test ended at 2017-01-21 18:43:58 > > CURRENT_TEST: main.analyze_stmt_orderby > ---

Re: [Maria-discuss] Fwd: Update of RPM layout

2016-12-21 Thread Daniel Black
On 22/12/16 03:29, Michal Schorm wrote: > Hello all, > > I went through an idea [1] to lighten the server package. > > I tested it, and I found out, I can save about 40MB of space, if I'd > move all Perl utilites to a standalone subpackage. > It would make sense to move them, so the users

Re: [Maria-discuss] Semaphore hangs

2016-12-08 Thread Daniel Black
On 09/12/16 09:43, Jon Foster wrote: > On 12/07/2016 06:04 PM, Daniel Black wrote: >> On 08/12/16 08:51, Jon Foster wrote: >>> We are having trouble with MariaDB hanging due to a "semaphore wait". We >>> then have to shut MariaDB down as it typically won't r

[Maria-discuss] Replication compatibility MySQL/MariaDB

2016-11-01 Thread Daniel Black
Folks, At the MariaDB Developer meetup there was some discussion about the limits of compatibility especially regarding replication. I've started a section on this page: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/ If you can identify what can/cannot work in various

Re: [Maria-discuss] Flashback (MDEV-10459) bikeshedding a name

2016-11-01 Thread Daniel Black
On 02/11/16 11:35, Ralf Gebhardt wrote: > Hi Daniel, > > Thanks for creating this. One comment. I have selected other and have > added "binlog revert". It looks like, when looking at the results, > others don't see new suggestions. It looks like it was a pro feature to enable the responses

[Maria-discuss] Flashback (MDEV-10459) bikeshedding a name

2016-11-01 Thread Daniel Black
During the MariaDB Developers Meetup last month we deferred deciding on a name for Flashback - a rewinding of database state using binary logs applied in reverse. It is described in MDEV-10459 (https://jira.mariadb.org/browse/MDEV-10459). If you have an opinion as to what name to choose follow

Re: [Maria-discuss] Best way to scale writes

2016-10-16 Thread Daniel Black
On 15/10/16 03:33, Jon Foster wrote: > I have a DB scenario that is very write intensive. Essentially its a > large scale hit counter of sorts. Currently we're running on a single > 12core server with 6 SSDs in a RAID6 array. Not using RAID6 would be a good start. > But we're looking for a way

Re: [Maria-discuss] New MariaDB 10.1.18 Galera setup question

2016-10-16 Thread Daniel Black
On 16/10/16 09:26, Alex Evonosky wrote: > Hello team- > > Quick question- > > I recently just installed mariaDB 10.1.18 (via apt-get) and all went > well, no issues.. Here is my galera.cnf file: > > cat galera.cnf > [mysqld] > binlog_format = ROW > default_storage_engine

Re: [Maria-discuss] eviction in information_schema?

2016-09-28 Thread Daniel Black
http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-notify-cmd This script will be executed on all nodes so you'll definitely detect it. On 29/09/16 04:04, l vic wrote: > How can i detect eviction of node from the cluster from > "information_schema" other than

Re: [Maria-discuss] optimize table wait table level lock in MairaDB 10.1.16 ?

2016-08-30 Thread Daniel Black
On 30/08/16 19:38, Ljr Yang wrote: > > Hi, all >Today, we use optimize table in MariaDB 10.1.16. > Table test01 have about 2 millions records. > > > session 1: optimize table test01; > > session 2: select count(*) from test01 ; > > when session 1 run, In processlist session 2

Re: [Maria-discuss] Don't replicate procedures in the mysql database

2016-08-28 Thread Daniel Black
On 28/08/16 21:06, Игорь Пашев wrote: > Hi all, > > I'm using multi-source replication with "white list" options only: > > foo.replicate_wild_do_table = foo.% > foo.replicate_ignore_table = foo.beep > foo.replicate_ignore_table = foo.tmp > > The masters are writing row-based binary logs as is

Re: [Maria-discuss] Creating Custom Storage Engine

2016-07-19 Thread Daniel Black
On 20/07/16 14:31, Jonathan Ellithorpe wrote: > Follow-up: I see in the blog pointed to by Daniel mentioned an SE for > Cassandra so I take it the answer is yes? Does anyone have > experience with this / know if anything "extra" must be done to make > that work? It falls to the

Re: [Maria-discuss] Creating Custom Storage Engine

2016-07-19 Thread Daniel Black
http://www.codeproject.com/Articles/1107279/Writing-a-MySQL-storage-engine-from-scratch is also a recent blog. Was written with MySQL rather than MariaDB in mind however there are probably lots of common concepts. On 19/07/16 20:00, Sergei Golubchik wrote: > Hi, Jonathan! > > On Jul 18, Jonathan

Re: [Maria-discuss] Designated donor.

2016-07-07 Thread Daniel Black
It needs to match https://mariadb.com/kb/en/mariadb/galera-cluster-system-variables/#wsrep_node_name of the donor. On 08/07/16 10:59, Tom Worster wrote: > On 7/7/16, 2:11 AM, "Maria-discuss on behalf of Daniel Black" > <maria-discuss-bounces+fsb=thefsb@lists.laun

Re: [Maria-discuss] Designated donor.

2016-07-07 Thread Daniel Black
Don't get the donor name wrong or you'll be chasing phantom network error messages. https://github.com/codership/galera/pull/109 On 06/07/16 20:00, Thorvald Hallvardsson wrote: > Hi, > > I want to configure my cluster of 3 nodes let's call them sql1, sql2, > sql3 in the way that maxscale will

[Maria-discuss] configuration changes to consider in 10.2

2016-05-05 Thread Daniel Black
As major versions are really the only time to consider changing default settings perhaps getting onto the following MDEV soon. https://jira.mariadb.org/browse/MDEV-7635 My main objective is to move the required configuration file down to approximately 0 settings and to work for the majority of

Re: [Maria-discuss] per session query rewrite?

2015-11-21 Thread Daniel Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 21/11/15 08:53, James Leu wrote: > Hello, > > I've recently discovered the QueryRewrite plugin. I was wondering > if there was any thought, or active work on making the rewrite > rules associated with a connection/session. > > If there is not

Re: [Maria-discuss] GRANT error - undocumented?

2015-11-11 Thread Daniel Black
row affected (0.00 sec) > > mysql> use fgtemp; > Database changed > mysql> grant all on fgtemp.* to 'root'@'nowhere'; > Query OK, 0 rows affected (0.05 sec) > -- > > ___ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net

Re: [Maria-discuss] Numa linux

2015-08-04 Thread Daniel Black
$ numactl --hardware shows hardware. E.g the following from a non numa. available: 1 nodes (0) node 0 cpus: 0 1 2 3 node 0 size: 11905 MB node 0 free: 437 MB node distances: node 0 0: 10 -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance

Re: [Maria-discuss] Travis-CI and MariaDB

2015-07-23 Thread Daniel Black
- On 24 Jul, 2015, at 7:25 AM, Otto Kekäläinen o...@seravo.fi wrote: Hello! 2015-07-23 10:59 GMT+03:00 Daniel Black daniel.bl...@openquery.com.au: [..] As for MariaDB-server in Travis-CI? we'll see if the bug committing fairies decide https://github.com/MariaDB/server/pull/84

[Maria-discuss] Travis-CI and MariaDB

2015-07-23 Thread Daniel Black
/MariaDB/server/pull/84 is useful. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria

Re: [Maria-discuss] Questions regarding Galera Cluster

2015-06-12 Thread Daniel Black
. The DR recovery mechanism (hardware failure etc... ) covers your calculated business and technical risks. Hint, you many need more that one mechanism. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments

Re: [Maria-discuss] 2015 leap second issues?

2015-06-06 Thread Daniel Black
for working mysql, even if other applications don't use that part of the kernel API. Thanks to all those who reminded us of this. Lets make sure we're running a fixed kernel by the end of the month. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance

Re: [Maria-discuss] Dynamic Columns ORM

2015-05-23 Thread Daniel Black
with that particular word or do you think it would be better to do without any such name? Just try to stay consistent which how mariadb/postgres call them rather than making up new terms. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL

Re: [Maria-discuss] Dynamic Columns ORM

2015-05-22 Thread Daniel Black
/mariadb/virtual-computed-columns/ Enhancing frameworks to expose database features is a good thing as they often get omitted in the reduction to the lowest common factor (mysql-5.0?) and sometimes the lowest common factor across db implementations (ansi SQL(?)). -- -- Daniel Black, Engineer @ Open

Re: [Maria-discuss] doubt about best engine

2015-05-13 Thread Daniel Black
throughput. -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net

[Maria-discuss] query cache dump_at_shutdown/load_at_startup useful + no character set/collation?

2015-05-12 Thread Daniel Black
to innodb_buffer_pool_dump_at_shutdown/innodb_buffer_pool_restore_at_startup) going to be useful to anyone? -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net

Re: [Maria-discuss] [Maria-developers] MariaDB finally in Debian officially (Fwd: Debian 8 Jessie released)

2015-04-26 Thread Daniel Black
/openquery/mariadb-server/blob/travis-ci-10.0/.travis.yml Probably could do something for packaging tests here. Build/test time is limited to 50 mins so its probably too much of a stretch to get packaging and content tests in the same package. Build time is only about 5 mins. -- Daniel Black

Re: [Maria-discuss] [Maria-developers] MariaDB finally in Debian officially (Fwd: Debian 8 Jessie released)

2015-04-26 Thread Daniel Black
to the MariaDB package and adapt them a little bit. Would you be interested in contributing here? :) As time permits. I'll get travis-ci to trigger the ci exactly like http://ci.debian.net/doc/. Need to sort out some g++ internal compile errors which is just being a pain first. -- -- Daniel Black

Re: [Maria-discuss] Does MariaDB support 2 level replication and crash recover from such situation?

2014-12-30 Thread Daniel Black
that what you;ve described. Ensure log-slave-updates is on all nodes. Using gtid replication will help you. Read the docs for this. -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments

Re: [Maria-discuss] new mdev about better explain

2014-12-01 Thread Daniel Black
is a slower query (it's a problem, but it's not related with my doubt...) Could also be related to https://mariadb.atlassian.net/browse/MDEV-7084 -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments

Re: [Maria-discuss] fusion io

2014-06-17 Thread Daniel Black
are out 11:51 bytee jplindst: doubt there is, from what i gathere I hope this helps cheers, -colin On Tue, Jun 10, 2014 at 5:18 PM, Daniel Black daniel.bl...@openquery.com wrote: Thanks Colin. Missed that line of the doco and/or assumed it was a capability of another file-system

[Maria-discuss] fusion io

2014-06-10 Thread Daniel Black
in opening ./ibdata1 -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss

[Maria-discuss] locking on endpoints of range deletes

2014-04-08 Thread Daniel Black
` trx id 290E33 lock mode IX RECORD LOCKS space id 82547 page no 3 n bits 72 index `PRIMARY` of table `drupal_test`.`x` trx id 290E33 lock_mode X locks rec but not gap MariaDB [drupal_test] insert into x values (DEFAULT); Query OK, 1 row affected (0.00 sec) -- -- Daniel Black, Engineer @ Open

Re: [Maria-discuss] Trouble getting MariaDB to start up

2014-04-01 Thread Daniel Black
- Original Message - On 01/04/14 04:52, Daniel Black wrote: Start one of the nodes with service mysql bootstrap (to define the primary node). This is still failing for me. It's apparently not to do with the clustering, but for some other reason I can't determine

Re: [Maria-discuss] Trouble getting MariaDB to start up

2014-03-31 Thread Daniel Black
-discuss More help : https://help.launchpad.net/ListHelp -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net/~maria-discuss Post

Re: [Maria-discuss] InnoDB pain points

2014-01-29 Thread Daniel Black
with file_per_table you can do optimize table Good call -- -- Daniel Black, Engineer @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net/~maria-discuss Post

[Maria-discuss] mydumper halting replication by creating innodb table in mysql db

2014-01-17 Thread Daniel Black
/~perconardba/mydumper/0.6/revision/23 ) Any clues to why the blocking? -- Daniel Black, Engineer @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. ___ Mailing list: https://launchpad.net/~maria-discuss

Re: [Maria-discuss] mydumper halting replication by creating innodb table in mysql db

2014-01-17 Thread Daniel Black
Appears someone beat me to it: https://bugs.launchpad.net/mydumper/+bug/1267501 And why: https://bugs.launchpad.net/galera/+bug/1265656 -- Daniel Black, Engineer @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments