Re: [Maria-discuss] query result inconsistency between MariaDB 10.0.x and Oracle MySQL 5.1.x

This is actually a bug https://mariadb.atlassian.net/browse/MDEV-5719. Pavel On Fri, May 23, 2014 at 11:18 AM, Charles Cazabon charlesc-web-register-launchpad@pyropus.ca wrote: Greetings, I recently upgraded the db server behind an application from MySQL 5.1.73 (as shipped in Ubuntu

Re: [Maria-discuss] PERFORMANCE_SCHEMA to be disabled in 10.0 (10.0.12)

I personally would prefer if MariaDB had performance schema not compiled in by default. Then we wouldn't be frustrated every time we upgrade and find out that the tarball doesn't compile without performance schema (yes, 10.0.11 doesn't compile). On Tue, Jun 3, 2014 at 1:20 AM, Colin Charles

Re: [Maria-discuss] newbie question

On Wed, Jun 11, 2014 at 8:32 PM, Roberto Spadim robe...@spadim.com.br wrote: Guys, i'm with a newbie question I need to swap a primary key value, for example: create table test ( id int not null default 0, other varchar(255) not null default '', primary key(id) ); insert into test

Re: [Maria-discuss] newbie question

table what about a aria/myisam/connect/federated table? 2014-06-12 0:45 GMT-03:00 Pavel Ivanov piva...@google.com: On Wed, Jun 11, 2014 at 8:32 PM, Roberto Spadim robe...@spadim.com.br wrote: Guys, i'm with a newbie question I need to swap a primary key value, for example: create table

Re: [Maria-discuss] newbie question

2014-06-12 0:57 GMT-03:00 Pavel Ivanov piva...@google.com: I think you need to explain better what the big task is. This particular problem is solved with this: update test set other = case when other = 'a' then 'b' when other = 'b' then 'a' end; I wonder though how would

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.

4bb6e79ace33e56627672b98a5 > > Joseph Glanville > Sent from Polymail > <https://polymail.io/?utm_source=polymail_medium=referral_campaign=signature> > > > On Fri, 29 Jul 2016 at 3:08 PM Pavel Ivanov <pavel+ivanov+%3cpiva...@google.com%3E>> wrote: > >> By &

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.

iday, 29 July 2016 6:17:28 PM > *To:* Joseph Glanville > *Cc:* Pavel Ivanov; maria-discuss@lists.launchpad.net > > *Subject:* Re: [Maria-discuss] Semi-sync replication hangs when changing > binlog filename. > > Hi, > > Does the problem appear if you set the timeout value to

Re: [Maria-discuss] master and slave binlog question?

There is no way to find corresponding binlog file and position on the slave. You should use GTIDs to find corresponding binlog positions. On Thu, Nov 17, 2016 at 7:19 PM, Ljr Yang wrote: > > Hi, >we config master slave and set log_slave_updates = 1 on slave. >on

Re: [Maria-discuss] MariaDB Server 10.3 notes

> For example, in MariaDB one can use InnoDB > for system tables too. Always could, even in 5.5, it's not a new > feature. There is no code that limits system tables to a specific > storage engine. This is not true even in MariaDB 10.2:

Re: [Maria-discuss] semi-sync replication rpl_semi_sync_master_clients question ?

17-03-28 18:07:07 140469136173824 [ERROR] Read semi-sync reply network >> error: (errno: 1158) >> 2017-03-28 18:07:07 140469136173824 [Note] Stop semi-sync binlog_dump to >> slave (server_id: 63) >> 2017-03-28 18:09:14 140467881470720 [Note] Start semi-sync binlog_dump to

Re: [Maria-discuss] semi-sync replication rpl_semi_sync_master_clients question ?

Could it be that your slaves are periodically disconnecting from the master and then reconnecting again, and you just happened to catch a state when only one slave is connected when you queried for Rpl_semi_sync_master_clients status? To confirm or deny this you should look at the master's error

Re: [Maria-discuss] logging original SQL statement along with ROW events

https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/ On Fri, Jun 9, 2017 at 11:05 AM, Justin Swanhart wrote: > Hi, > > I seem to recall reading that MariaDB can annotate the binary log with the > original SQL statement for a given set of ROW changes in the binary log,

Re: [Maria-discuss] Why MyISAM as default engine for system tables ?

Note that several system tables in "mysql" schema cannot have InnoDB as storage engine due to explicit prohibition in the InnoDB code (see https://github.com/MariaDB/server/blob/10.4/storage/innobase/row/row0mysql.cc#L2376) and due to lots of other code throughout the codebase assuming that the

Re: [Maria-discuss] How does InnoDB delete rows?

from being written again? Also, when talking about > large tables, could this "table bloat" impact performance in, for instance, > sequential scans? > > Thanks again, > Arlindo Neto. > > Em sex, 27 de jul de 2018 às 18:35, Pavel Ivanov > escreveu: >>