Re: [Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Sergei Golubchik
Hi, Erik! On Apr 20, Erik Cederstrand wrote: > > CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` > int(11) NOT NULL, `m` int(11) DEFAULT NULL, PRIMARY KEY > (`i`,`j`,`l`)); > > CREATE TABLE `t2` ( `i` int(11) NOT NULL, `k` int(11) DEFAULT NULL, > PRIMARY KEY (`i`)) ENGINE=Inn

Re: [Maria-discuss] InnoDB fake changes

2016-04-20 Thread Colin Charles
> On 21 Apr 2016, at 00:47, Jan Lindström wrote: > > Hi, > > Yes, I have not yet made decision should the parameter be removed or left as > it is. It is to my knowledge stable but use cases are limited. > From what I can see, its pretty clear that Percona Server now says: "Support for Fake C

Re: [Maria-discuss] InnoDB fake changes

2016-04-20 Thread Jan Lindström
Hi, Yes, I have not yet made decision should the parameter be removed or left as it is. It is to my knowledge stable but use cases are limited. R: Jan On Tue, Apr 19, 2016 at 11:54 AM, Federico Razzoli wrote: > Hi all > > I see that 10.2 still has the innodb_fake_changes variable (OFF by > def

Re: [Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Colin Charles
> On 20 Apr 2016, at 22:09, Erik Cederstrand wrote: > > In the meantime, is there any way I can rewrite queries like this dynamically > to remove the DISTINCT clause? MySQL 5.7 documentation mentions query rewrite > plugins, but I don't see that mentioned in MariaDB documentation. Any other >

Re: [Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Guillaume Lefranc
You can use MaxScale : https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/maxscale-regex-filter-overview/ 2016-04-20 16:09 GMT+02:00 Erik Cederstrand : > Hello list, > > I'm administering a MariaDB (10.0.23) backend used by some proprietary > software. I'm having trouble with one speci

[Maria-discuss] Dynamically rewrite query

2016-04-20 Thread Erik Cederstrand
Hello list, I'm administering a MariaDB (10.0.23) backend used by some proprietary software. I'm having trouble with one specific slow query. The tables look like this (simplified for clarity): CREATE TABLE `t1` ( `i` int(11) NOT NULL, `j` int(11) NOT NULL, `l` int(11) NOT NULL, `m` int

[Maria-discuss] New Question: Storage engine support and compatibility constraints

2016-04-20 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB FAQ" by dbamaria. Please answer it at http://mariadb.com/kb/en/storage-engine-support-and-compatibility-constraints/ as the person asking the question may not be subscribed to the mailing list. Hi, 1- As the stor