Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Oleksandr Byelkin
08.08.2013 09:11, Roberto Spadim пишет: ops... i forgot one more question that i don't know how today it is executed... the "explain extended" create the "normalized query" after parse/optimize but don't execute the query, i'm thinking right or i miss something? Yes it could execute only cons

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Roberto Spadim
ops... i forgot one more question that i don't know how today it is executed... the "explain extended" create the "normalized query" after parse/optimize but don't execute the query, i'm thinking right or i miss something? ___ Mailing list: https://launch

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Roberto Spadim
hi oleksandr! i understood some points... but let me explain better... about optimizer part, i was talking about constant propagation and others optimizations, like this: 1) "select .. where 0=0 and a=1 and a=2" optimized to: "0=0 and a=1 and a=2" => "true and false" => "always false" (ok here exe

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Oleksandr Byelkin
Hi! 08.08.2013 08:05, Roberto Spadim пишет: hum... check if i'm thinking wrong about the internal flow of mariadb/mysql ... client send data over network server receive data server process data and check that it's a query command server check query cache and return if found (that's how query ca

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Roberto Spadim
hum... check if i'm thinking wrong about the internal flow of mariadb/mysql ... client send data over network server receive data server process data and check that it's a query command server check query cache and return if found (that's how query cache execute today, right?) (here no query was f

Re: [Maria-developers] [Commits] Rev 3772: MDEV-4645: Incorrect reads of frozen binlog events; FDE corrupted in relay log in file:///home/bell/maria/bzr/work-maria-10.0-MDEV-4548/

2013-08-07 Thread Oleksandr Byelkin
07.08.2013 23:57, Jeremy Cole пишет: Sanja, (Resending with the mailing list since this previous conversation was there.) Thank you a lot! [skip] ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launch

Re: [Maria-developers] [Commits] Rev 3772: MDEV-4645: Incorrect reads of frozen binlog events; FDE corrupted in relay log in file:///home/bell/maria/bzr/work-maria-10.0-MDEV-4548/

2013-08-07 Thread Oleksandr Byelkin
Hi, Jeremy! 07.08.2013 23:58, Jeremy Cole пишет: I meant that the code itself is sometimes indented with spaces, and sometimes tabs, not that you have printed with a mix of " " and "\t". That is because of setup of my editor according to MySQL codding style, it just do not use tabs at all (bu

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Oleksandr Byelkin
07.08.2013 18:44, Roberto Spadim пишет: Hi Oleksandr! humm i will check the source and understand how it is done, thanks oleksandr! but... another doubt... today query cache have: query blocks (with query and flags), table blocks (with tables) result blocks (with results) there's any way of

[Maria-developers] RFC - temporary path and SSD/HDD

2013-08-07 Thread Roberto Spadim
Hi guys I have some server running with bcache and some in test running flash cache and others linux ssd cache solution I was thinking about how to optimize the temporary tables of mysql/mariadb... could we implement something like: Temporary Slow/Big Path = /tmp/hdd Temporary Fast/Small Path =

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Roberto Spadim
Hi Oleksandr! humm i will check the source and understand how it is done, >> thanks oleksandr! >> >> but... another doubt... >> >> today query cache have: >> query blocks (with query and flags), >> table blocks (with tables) >> result blocks (with results) >> there's any way of two query blocks (

Re: [Maria-developers] [Commits] Rev 3671: MDEV-4811 Assertion `offset < 0x1f' fails in type_and_offset_store on COLUMN_ADD in file:///home/bell/maria/bzr/work-maria-5.3-MDEV-4811/

2013-08-07 Thread Sergei Petrunia
Hi Sanja, Ok to push. On Thu, Aug 01, 2013 at 11:46:14AM +0300, sa...@montyprogram.com wrote: > At file:///home/bell/maria/bzr/work-maria-5.3-MDEV-4811/ > > > revno: 3671 > revision-id: sa...@montyprogram.com-20130801084611-cu3wpoazd19

Re: [Maria-developers] [Commits] Rev 3797: MDEV-4816: rpl.rpl_trunc_temp fails in 10.0-serg in file:///data0/psergey/dev2/10.0-serg/

2013-08-07 Thread Kristian Nielsen
Sergey Petrunya writes: > revision-id: pser...@askmonty.org-20130802141209-4dqfvx2db8acxwbl > message: > MDEV-4816: rpl.rpl_trunc_temp fails in 10.0-serg > Temorary fix for a number of replication tests (rpl.rpl_temp_table_mix_row > rpl.rpl_trunc_temp rpl.rpl_current_user rpl.rpl_gtid_mast

Re: [Maria-developers] RFC: Compile-time checking for unmatched DBUG_ENTER/LEAVE via unused variable

2013-08-07 Thread Stewart Smith
Jeremy Cole writes: > The attached patch adds what amounts to compile-time checking for unmatched > DBUG_ENTER/DBUG_LEAVE (DBUG_RETURN, DBUG_VOID_RETURN) by introducing a > variable in DBUG_ENTER which is only used in DBUG_LEAVE. This allows any > compiler which can robustly detect unused variable

Re: [Maria-developers] RFC - query cache insert

2013-08-07 Thread Oleksandr Byelkin
06.08.2013 20:49, Roberto Spadim пишет: humm i will check the source and understand how it is done, thanks oleksandr! but... another doubt... today query cache have: query blocks (with query and flags), table blocks (with tables) result blocks (with results) there's any way of two query blocks