Re: [Maria-developers] an observation

2017-01-30 Thread Sergei Golubchik
Hi, AugustQ! On Jan 29, AugustQ wrote: > Hi, > > by playing with the code I think I found something interesting. > > My environment: MariaDB 10.0.10, MyISAM-engine > > I played with a table-scan, no index is defined on this table. When I > execute a SQL-statement that forces the server to do a

Re: [Maria-developers] an observation

2017-01-30 Thread AugustQ
Hi Robert, #1: OS I've only tested on Linux. But I was using the source-code of MariaDB so I assume the effect will happen on Windows too. #2: SQL-statement this is the statement I've used for my test: MariaDB [TestOpt]> select SQL_NO_CACHE   B.PZN, B.ArtikelText  from TestBig B where exists ( sele

Re: [Maria-developers] an observation

2017-01-30 Thread AugustQ
Hi Sergei, thnkas for your reply. In my tests I found that the first table-scan takes about 12 seconds, the second table-scan takes about 25 seconds (and all folowing) scans too). When I call the function reinit_io_cache() all scans take about 12 seonds. But my implementation was quick and dirty...

Re: [Maria-developers] [Commits] d44c14e: MDEV-10812 WSREP causes responses being sent to protocol commands that must not send a response

2017-01-30 Thread Nirbhay Choubey
Hi Sachin, On Mon, Jan 30, 2017 at 12:10 AM, Sachin Setiya wrote: > HI Nirbhay! > > On Sun, Jan 29, 2017 at 11:42 PM, Nirbhay Choubey > wrote: > > Hi Sachin! > > > > On Fri, Jan 27, 2017 at 12:53 AM, SachinSetiya < > sachin.set...@mariadb.com> > > wrote: > >> > >> revision-id: d44c14e1e0dea3127