Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Sergei Golubchik
Hi, Roberto! On May 24, Roberto Spadim wrote: > Hi guys i'm reading query cache code, and i have some doubts... > mariadb-10.0.1 source: > > 1)PROTOCOL_LOCAL: > at line: 1412 (Query_cache::store_query) > we have this comment: > /* PROTOCOL_LOCAL results are not cached. */ > > what's PROTOCOL_LOC

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Sergei Golubchik
Hi, Roberto! On May 24, Roberto Spadim wrote: > in query cache information plugin file (qc_info.cc), line 69: > {"RESULT_BLOCKS_COUNT", MY_INT32_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, > 0, 0, 0}, > {"RESULT_BLOCKS_SIZE", MY_INT32_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONGLONG, > 0, 0, 0, 0}, > > wh

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
nice =) i'm putting a new mdev and a patch with table inside query cache ,and all flags (i think, two flags i don't know how to add) 2013/5/25 Sergei Golubchik > Hi, Roberto! > > On May 24, Roberto Spadim wrote: > > in query cache information plugin file (qc_info.cc), line 69: > > {"RESULT_BL

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
done! :) https://mariadb.atlassian.net/browse/MDEV-4580 2013/5/25 Roberto Spadim > nice =) i'm putting a new mdev and a patch with table inside query cache > ,and all flags (i think, two flags i don't know how to add) > > > 2013/5/25 Sergei Golubchik > >> Hi, Roberto! >> >> On May 24, Roberto

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
*-* my first mariadb patch *-* please accept it hahaha what's the difference of mariadb 10 and mariadb 5 I_S plugin? ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launc

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
hi sergei =D work done :D i put a last diff with tables used by the query i used a char[] since i don't know how to use string or others function in c :) now query cache information is very very nice and beautiful =D i'm putting code here too it's mariadb 5.5.31 diff_qc_info.cc Description: Bin

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
ops... please change ยด with ` attached again thanks guy!! :D 2013/5/25 Roberto Spadim > hi sergei =D work done :D > i put a last diff with tables used by the query > i used a char[] since i don't know how to use string or others function in > c :) > > now query cache information is very very

Re: [Maria-developers] MariaDB 5.5 EOL plans

2013-05-25 Thread Rasmus Johansson
Hi, On Tue, May 14, 2013 at 5:57 PM, Honza Horak wrote: > Hi guys, > > I'm not able to find any info about life cycle of MariaDB 5.5 or even other > versions. Particularly if the MariaDB 5.5 life cycle will somehow follow the > MySQL's 5.5 life cycle or if there is some another vision/rough plans

Re: [Maria-developers] MariaDB 5.5 EOL plans

2013-05-25 Thread Rasmus Johansson
Hi, On Tue, May 14, 2013 at 5:57 PM, Honza Horak wrote: > Hi guys, > > I'm not able to find any info about life cycle of MariaDB 5.5 or even other > versions. Particularly if the MariaDB 5.5 life cycle will somehow follow the > MySQL's 5.5 life cycle or if there is some another vision/rough plans

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
sorry wrong files now diff files =) 2013/5/25 Roberto Spadim > sergei, there's a public contribuition system like github for mariadb? > > i put more information to query cache: > query_hits (per query) > rows_read (todo) > expend_time (todo) > > attached patchs > diff -u maria_db_5.5.31_origin

Re: [Maria-developers] MariaDB 5.5 EOL plans

2013-05-25 Thread Daniel Bartholomew
On Sat, May 25, 2013 at 9:03 AM, Rasmus Johansson wrote: > Thanks for bringing this up! It has been on the table quite some > times, but now finally I think we got it documented. So here it is: > ... And here it is in the Knowledgebase: https://kb.askmonty.org/en/mariadb-maintenance-policy/ Tha

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Sergei Golubchik
Hi, Roberto! On May 25, Roberto Spadim wrote: > sergei, there's a public contribuition system like github for mariadb? MariaDB sources are on launchpad. To porpose a code contribution, you can submit a merge request on launchpad: https://help.launchpad.net/Code/Review Regards, Sergei __

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
nice, about how to get expend time in query and rows read, how could i do? thd->examined_row_count and thd->start_time return 0?! at function in sql_cache.cc line ~ 1560 void Query_cache::store_query(THD *thd, TABLE_LIST *tables_used) 2013/5/25 Sergei Golubchik > Hi, Roberto! > > On May 2

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
foudn =) hehehei should do it at line ~1200 2013/5/25 Roberto Spadim > nice, about how to get expend time in query and rows read, how could i do? > > thd->examined_row_count and > thd->start_time > > return 0?! > > at function in sql_cache.cc line ~ 1560 > void Query_cache::store_query(THD *

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
updated files at https://mariadb.atlassian.net/browse/MDEV-4581 too =) i will study lauchpad in some time now, but if possible review the patch could be nice i don't know if string concats are ok, and if i done some overflow, or bad casts... must test thank :) ___

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
ops :( i done tab-space conversion and sql_cache.cc and sql_cache.h are very big now :( sending the patch now again 2013/5/25 Roberto Spadim > updated files at > https://mariadb.atlassian.net/browse/MDEV-4581 > too =) > i will study lauchpad in some time now, but if possible review the patch >

Re: [Maria-developers] GTID replication and relay_log.info

2013-05-25 Thread Pavel Ivanov
Kristian, On Tue, May 21, 2013 at 2:31 PM, Kristian Nielsen wrote: >> GTIDs it's really easy to solve the problem -- rpl_slave_state has >> GTID of the last executed transaction, so on restart one needs just to >> ignore all relay logs and re-connect to master with the last GTID. Did > > Yes. Tha

Re: [Maria-developers] GTID replication and relay_log.info

2013-05-25 Thread Kristian Nielsen
Pavel Ivanov writes: > yet). But from time to time we see failures of rpl.rpl_gtid_crash test > with the output like this: Hm, strange, it does not fail in our Buildbot, which runs hundreds of tests on different hosts... > Can you suggest what debugging information should I gather to > understa

Re: [Maria-developers] GTID replication and relay_log.info

2013-05-25 Thread Pavel Ivanov
On Sat, May 25, 2013 at 8:51 PM, Kristian Nielsen wrote: >> yet). But from time to time we see failures of rpl.rpl_gtid_crash test >> with the output like this: > > Hm, strange, it does not fail in our Buildbot, which runs hundreds of tests on > different hosts... Well, either our build environme

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
sergei, i will port it to mariadb 10.0.2, any work was done? 2013/5/25 Roberto Spadim > ops :( i done tab-space conversion and sql_cache.cc and sql_cache.h are > very big now :( > sending the patch now again > > > 2013/5/25 Roberto Spadim > >> updated files at >> https://mariadb.atlassian.net/

Re: [Maria-developers] Query cache information plugin - MDEV-4516

2013-05-25 Thread Roberto Spadim
well =) done https://mariadb.atlassian.net/browse/MDEV-4581 bye =) now i will study launchpad =) ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-devel