Re: [Maria-developers] (MDEV-3949) OTP authenticator plugins

) well if you could send your solution we could develop some more ideas for sure, i'will not use it to make money, just to secure my self 2012/12/19 > ou ask a question - do it on the mailing list. Jira is for > bug reports and feature requests. > -- Rober

Re: [Maria-developers] GSoC:Regex Project

maria-developers> >> More help : >> https://help.launchpad.net/**ListHelp<https://help.launchpad.net/ListHelp> >> >> > __**_ > Mailing list: > https://launchpad.net/~m

[Maria-developers] User question

er2 on db2 Thanks! -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp

Re: [Maria-developers] User question

other doubt, i will have about 256 masters how could i change limit of masters? in multi-source replication page of mariadb it says: You can for now only have 64 masters (trivial to increase if necessary). https://kb.askmonty.org/en/multi-source-replication/ 2013/4/18 Roberto Spadim > hi g

Re: [Maria-developers] User question

there`s a directory inside mariadb binary file, called support-files maybe a example there could be nice three files only: mysql-multi_master_replication_1.cnf mysql-multi_master_replication_2.cnf mysql-multi_master_replication_slave.cnf 2013/4/18 Roberto Spadim > other doubt, i will h

Re: [Maria-developers] User question

guys, anyone know about a public or private replication service for mysql/mariadb? i know the amazon a-z, there's anothers? maybe we could receive money creating a service like this in mariadb.org, what you think? 2013/4/19 Michael Widenius > > Hi! > > >>>>

Re: [Maria-developers] User question

solution right?! mariadb need money =) it's an easy solution to get money =D i prefer running REPLICATE TO CLOUD command than understand amazon manual, or other think like it... maybe we could put it in a plugin? just some ideas =) bye guys 2013/4/19 Roberto Spadim > guys, anyone kn

Re: [Maria-developers] User question

a tremendous burden and very expensive, and it's definitely not > something that would break even without at least thousands of users. > > Regards, > > Jeremy > > > On Fri, Apr 19, 2013 at 2:37 PM, Roberto Spadim wrote: > >> just some ideas... >> we could dev

[Maria-developers] Aria engine integrity

system (xfs for example) + myisam? or maybe xfs+aria? what's better? just one repair, from aria engine, or two repairs, one from file system and other from aria? thanks guys -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers

Re: [Maria-developers] Aria engine integrity

2013/4/20 Stewart Smith > Roberto Spadim writes: > > could i use aria engine over a ext2 file system and have a 'security' > near > > a jornaled file system (xfs for example) + myisam? or maybe xfs+aria? > > No. You need both. Why? Otherwise you get to wait a whole bu

[Maria-developers] ALTER TABLE xxx ENGINE=aria, progress only works in copying stage

the processlist show, at least, the last progress percentage? without get back to 0%? or maybe a column of current operation progress and another of total process operation? does 'repair by sorting' have progress algoritm implemented? i'm running mariadb 10.0.1 on linux 64bi

[Maria-developers] log analyzer

have the EXPLAIN, we could have PARSE or other name? simplifying the problem: read the query, parse it and change constant values with "?" willcard thanks! any help is welcome -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-d

Re: [Maria-developers] log analyzer

Reading a bit more mariadb manual what i need is near to EXPLAIN EXTENDED + SHOW WARNINGS, but with "?" will card instead of constants https://kb.askmonty.org/en/explain/#explain-extended 2013/4/23 Roberto Spadim > Hi guys, > > I was looking for something that give me the

Re: [Maria-developers] log analyzer

sorry tipo *wildcard instead willcard 2013/4/23 Roberto Spadim > Reading a bit more mariadb manual what i need is near to EXPLAIN EXTENDED > + SHOW WARNINGS, but with "?" will card instead of constants > https://kb.askmonty.org/en/explain/#explain-extended > > >

Re: [Maria-developers] Fwd: gsoc13

ariadb? >> >> Thanks! >> > > > ___ > Mailing list: https://launchpad.net/~maria-developers > Post to : maria-developers@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-developers > More help : ht

Re: [Maria-developers] Documentation about GTID

s.launchpad.net > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp > -- Roberto Spadim SPAEmpresarial ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Documentation about GTID

ok it's a very big number :) no problem at all in other words if we get 2^64 maybe we will change to 2^128 this could be put in manual just as an information of why use 64bits on gtid, it is interesting 2013/5/7 Kristian Nielsen > Roberto Spadim writes: > > > hum, lets thi

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

tude worse with ENGINE=MEMORY than > with ENGINE=InnoDB with ibdata and ib_log files on tmpfs. > > Gordan > > > __________**_ > Mailing list: > https://launchpad.net/~maria-**developers<https://launchpad.net/~maria-developers> > Po

Re: [Maria-developers] Feature Request - Working auto_inc rement on BlackHole Engine

o only execute 1 lock for each 'str' variable, must check the source code 2013/5/15 Gordan Bobic > On 05/15/2013 09:24 PM, Roberto Spadim wrote: > >> hum, maybe a 'global variable' + a 'counter' function could do the job? >> >> select add_and_re

Re: [Maria-developers] To Sergei:

just some questions about dialog_example.c, just to check if i understood the source the three_attempts, request 3 times the password, if it's all wrong return CR_ERROR, and user is 'disconnected'? the two_questions, request the password, if wrong, disconnect with CR_ERROR, send the second questi

Re: [Maria-developers] To Sergei:

in your example wth s/key it doesn't check password with mysql database? just the key with skey lib? example: Authentication Plugin Example static int skey_auth(MYSQL_PLUGIN_VIO *vio, MYSQL_SERVER_AUTH_INFO *info) { unsigned char *pkt; int pkt_len; struct skey mp; char buf[SKEY_MAX_CHAL

Re: [Maria-developers] To Sergei:

nice, thanks sergei i will study it 2013/5/16 Sergei Golubchik > Hi, Roberto! > > On May 16, Roberto Spadim wrote: > > in your example wth s/key > > it doesn't check password with mysql database? just the key with skey > lib? > > Right. It only checks the

[Maria-developers] Ogg vorbis based table

Hi guys, i was listening some musics, and i had a idea... let's me explain Some systems are based in time and value, an example of scada systems. In this kind of system we have an 'channel' (like right or left sound channel) a timestamp and a value, normally a table like CREATE TABLE history( Chan

[Maria-developers] History of table changes

ad changes done and 'commits' done by dba or developer or a tool to read my table and read remote table and show the create command to make they in sync (ok here history is lost) thanks guys -- Roberto Spadim ___ Mailing list: https://launchpad.n

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

t;number", and allow a "delete from query_cache_information where key=xxx" function? at line 1938 we have this maybe the query position on cache ("primary key of query cache")?: DBUG_PRINT("qcache", ("Query have result 0x%lx", (ulong)

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

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}, why we use the same "MY_INT32_NUM_DECIMAL_DIGITS" for "MYSQL_TY

[Maria-developers] query cache restrictions

hi guys, why we can't cache "union" queries with query cache? http://www.mysqlperformanceblog.com/2006/07/27/mysql-query-cache/ *Caching full queries only *– Meaning it does not work for subselects, inline views, parts of the UNION. This is also common missunderstanding. --

Re: [Maria-developers] query cache restrictions

sorry, found the problem... i tested the query select * from test.a where a =2 and b in(select a as a from test.a)union select * from test.a where a =2 and b in(select a as a from test.a) but it was not cached, i put the SQL_CACHE and i found it in query cache =] very nice =) __

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

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 f

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

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,

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

*-* 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

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

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 i

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

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) > &

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

gt; > 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/Revi

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

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 >

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

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

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 revi

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

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 >&

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

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

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

hi sergei with last patch, i think the job on https://mariadb.atlassian.net/browse/MDEV-4581 could be reviewed, and maybe considered to include in mariadb todo: better flags values (sql_mode is int, should be converted to string, connection charsets too, and add flag timezone informations) well th

[Maria-developers] Partition prune and lock

Hi guys i'm studing mariadb code and reading user manuals to know more about features. My last study was about query cache with many ideas in some MDEV and some patchs sent Now i'm reading about partition My questions are 1)when a update or a delete is done on a expecific partition like: Update t

Re: [Maria-developers] Partition prune and lock

the horizontal partition (2), could help us with alter online table add field type; 2013/5/29 Roberto Spadim > Hi guys i'm studing mariadb code and reading user manuals to know more > about features. My last study was about query cache with many ideas in some > MDEV and so

[Maria-developers] Help with MDEV-4419, ENUM optimization

thing "" > "3" ? no, "" < ASCII 51 -> remove the value "" from return variable end for now the return variable is : "x","y","z"the "" was removed rewrite the operator to: "column IN

[Maria-developers] audit plugin help with MDEV-575 (fail2ban like)

FROM users WHERE user="user") if count(*) > bad_login_max_tries form that user disconnect that's all -- Roberto Spadim SPAEmpresarial ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.

Re: [Maria-developers] audit plugin help with MDEV-575 (fail2ban like)

well i'm thinking about again, maybe just a syslog could do the job with fail2ban but in windows... well it will not work maybe the second option of a internal table could do the job too Host | bad_login_datetime if host have more than 'bad_login_tries' bad logins in 'bad_login_seconds' seconds be

Re: [Maria-developers] Help with MDEV-4419, ENUM optimization

hummm :) nice, i will study it =) it give me a lot of speed, since some system are closed source and i can't rewrite the query, just change the mysql server or put a mysql proxy ___ Mailing list: https://launchpad.net/~maria-developers Post to : mari

Re: [Maria-developers] audit plugin help with MDEV-575 (fail2ban like)

i will update MDEV to try this option, it's easier and 'do the job', maybe a log could help too but... leave to another plugin do this =) 2013/6/11 Roberto Spadim > well i'm thinking about again, maybe just a syslog could do the job with > fail2ban > but in win

Re: [Maria-developers] audit plugin help with MDEV-575 (fail2ban like)

now, MDEV updated with a better idea of what we should do, i think it will be a nicelly optimized code ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-

Re: [Maria-developers] Help with MDEV-4419, ENUM optimization

i will put this info in MDEV, maybe some one will try do this before me and will ask again ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers M

[Maria-developers] MDEV-4581 , more query cache information fields

ache.h "dirty" but will be more easly to read and patch future versions. only add 2 lines to sql_cache.cc , and many lines to sql_cache.h since sql_cache.h have the structure it will be easly to write function call at struct than sql_cache.cc file bye guys --

Re: [Maria-developers] MDEV-4581 , more query cache information fields

hi sergei, i sent the patch, could you check it? i think that's easy to read and understand maybe some code standard should be done since i don't know how code in mariadb cs https://mariadb.atlassian.net/browse/MDEV-4581 ___ Mailing list: https://launchpa

[Maria-developers] I_S plugin doubts

[]= { {"ENTRY_POSITION_IN_CACHE", MY_INT32_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, 0, 0}, ... to static ST_FIELD_INFO qc_info_fields_queries[]= { {"ENTRY_POSITION_IN_CACHE", MY_INT32_NUM_DECIMAL_DIGITS, MYSQL_TYPE_LONG, 0, 0, 0, SKIP_OPEN_TABLE}, ...

Re: [Maria-developers] I_S plugin doubts

Second doubt... there's a ENGINE=INFORMATION_SCHEMA that's more 'beautiful' than 'aria' or 'memory', since they aren't this kind of engine like the PERFORMACE_SCHEMA engine ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-deve

Re: [Maria-developers] Help with MDEV-4419, ENUM optimization

should i use SQL_SELECT::test_quick_select() ? or just get_quick_select_for_ref() ? i didn't understand if test_quick_select is just for keys (index) or any WHERE condition 2013/6/11 Roberto Spadim > i will put this info in MDEV, maybe some one will try do this before me > and wil

Re: [Maria-developers] Help with MDEV-4419, ENUM optimization

i was reading file "opt_range.cc", but i'm a bit confused (maybe first impression) where the per column check occurs? where the "Impossible WHERE" condiction occurs? -- i'm thinking about a implementation like this (per column): field = ENUM field WITH enum_val

Re: [Maria-developers] I_S plugin doubts

maybe just to informe it as information schema? how could i know if a I_S table will be memory or aria or myisam? does mysqld 'parse' it at startup? ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.

Re: [Maria-developers] I_S plugin doubts

hu nice =] thanks stewart, well i'm doing it right the information_schema engine is just to easly view what type the table is but we can see this using the schema thanks! ___ Mailing list: https://launchpad.net/~maria-developers Post to : ma

Re: [Maria-developers] Process suggestion for minor issues

i like the today jira process, if you want a higher priority, do some job solving the problem, after that we could have NEW FEATURE in JIRA, like: send the patch and marke the issue to "PLEASE REVIEW I HAVE SENT A SOLUTION!" (i don't remember but when this occur i set the issue to major (sorry i wi

Re: [Maria-developers] Process suggestion for minor issues

about quality assurance process, what should be done? unit tests? test team? ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help :

Re: [Maria-developers] Process suggestion for minor issues

maybe creating a project (in jira) about mariadb docs, could allow do do this, instead using the MDEV project, create a MDOC project to documentation or a MQA (quality) that should do test, documentation and quality features (code standard, benchmark etc etc ) at least if anyone know about somethin

[Maria-developers] Jira new field

hi guys, could we add a Reporter Label inside jira issue? instead of only Label (used by mariadb team) it's easier to filter issues, thinking about the reporter filter not for mariadb team filters -- Roberto Spadim ___ Mailing list:

Re: [Maria-developers] Jira new field

he work of mariadb placing the right label in the right issue 2013/6/17 Sergei Golubchik > Hi, Roberto! > > On Jun 17, Roberto Spadim wrote: > > hi guys, could we add a Reporter Label inside jira issue? instead of only > > Label (used by mariadb team) > > it's easie

Re: [Maria-developers] Jira new field

vate field' just to add this kind of information is nice to don't setup a issue tracker (in my case) 2013/6/17 Roberto Spadim > heeh sometimes i just add a label that don't have interest to mariadb > team, it's just to 'group' my issues > if there's a

Re: [Maria-developers] Jira new field

it don't need to be a very big field (100bytes of latin1 is nice to me) 2013/6/17 Roberto Spadim > i think that the right way (but it's not good to me...) > is build a issue tracker outside jira just to me > but i'm using mariadb php and apache, and i only have issues

Re: [Maria-developers] Jira new field

change and when i lost my memory (some times =) ) i need to read all issues again and find where i put the information 2013/6/17 Roberto Spadim > it don't need to be a very big field (100bytes of latin1 is nice to me) > > > 2013/6/17 Roberto Spadim > >> i think th

Re: [Maria-developers] Jira new field

ok =) thanks 2013/6/17 Sergei Golubchik > Hi, Roberto! > > On Jun 17, Roberto Spadim wrote: > > > > today i'm 'working around ' this, and putting the 'group information' in > > MDEV issue, example.. query cache things i put > > Q

[Maria-developers] close some mdev

iadb.atlassian.net/browse/MDEV-4589> 1. MDEV-575 <https://mariadb.atlassian.net/browse/MDEV-575> -- Roberto Spadim SPAEmpresarial ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net U

[Maria-developers] mysql 5.6, 5.7

today i'm not using it in mariadb (not a problem, but it's nice features) -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-

[Maria-developers] query cache issue

if we get low men in query cache querycache_result - features relative to when should or shouldn't hit query cache when query is cached if they will be or not implemented is another history is labels ok? should i remove it? -- Roberto Spadim ___ Mail

[Maria-developers] review / close MDEV-4581

hi guys, could review / close MDEV-4581<https://mariadb.atlassian.net/browse/MDEV-4581> ? -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe :

Re: [Maria-developers] mysql 5.6, 5.7

it's a nice feature not a must have feature trace what mariadb is doing in optimizer, some time (in bugs or performace problem) is nice to see what is going wrong, and why a must have feature, for me, is lock partition prune i have many myisam table with lock problem and partition lock prune can s

Re: [Maria-developers] close some mdev

hi sergei! thanks about others mdev, and yes mdev 4583 shouldn't be closed, i will study a bit more to see what can be done to write a patch about it and test the speed of a procedure removing query cache queries 2013/6/18 Sergei Golubchik > Hi, Roberto! > > On Jun 17, Robert

Re: [Maria-developers] review / close MDEV-4581

nice! thanks sergei! i think it's now rich in features, maybe should be used by community to check if it's usefull (there's many columns) thanks again! 2013/6/18 Sergei Golubchik > Hi, Roberto! > > On Jun 18, Roberto Spadim wrote: > > hi guys, could revi

Re: [Maria-developers] mysql 5.6, 5.7

explain WHY the chosen alternative is REALLY better than rejected ones: > the calculation of the costs remains under the cover. > > Regards, > Igor. > > > Just my $.02. > > > > -Zardosht > > > > On Mon, Jun 17, 2013 at 10:37 PM, Igor Babaev wrote: > &g

Re: [Maria-developers] mysql 5.6, 5.7

hum, there's something that show the "cost" of each optimization in mariadb, like the mysql optimizer_trace? i'm thinking about the MDEV-350 about self tune coeficients, the first task is find all constants that are used in "cost" values _

[Maria-developers] users table

version (ok no problem) and flush tables in all servers after add an user i don't know if i could do a two replications since it's like a master-master storage when one database add a user all databases need that information any idea? -- Roberto Spadim ___

Re: [Maria-developers] users table

19.06.2013 00:03, schrieb Roberto Spadim: > > hi guys, what's the better way to have a shared mysql schema? > > i'm talking about creating a user in one database and this user be > created in many databases (in the same server) > > i'm trying with symbolic links in da

[Maria-developers] help with parser

cause an warning (first variable don't exists) and change the second variable* thanks -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.

[Maria-developers] Doubt at query cache resize

Hi guys I was trying to compile in windows and warning was displayed at mariadb 10:0:3 in sysvars.cc at line 2235 Ulong new cache size = ulonglong function Could we lost the query cache size? Like a overflow ___ Mailing list: https://launchpad.net/~maria

[Maria-developers] Debug on windows

Hi guys i want to learn about optrange.cc, but i dont know how to debug I'm using visual studio 2008 on windows, could anyone help me I will place a break point at get_mm_leaf function and watch all variables Anyone could help me? ___ Mailing list: https:

Re: [Maria-developers] RFC: Pausing a query thread

developers@lists.**launchpad.net > Unsubscribe : > https://launchpad.net/~maria-**developers<https://launchpad.net/~maria-developers> > More help : > https://help.launchpad.net/**ListHelp<https://help.launchpad.net/ListHelp> > -- Roberto Spadim SPAEmpresarial __

Re: [Maria-developers] Help with MDEV-4419, ENUM optimization

hi guys, i was trying to understand get_mm_leaf of opt_range.cc debuging with VS 2008 but, i think that "get_mm_leaf" function, only execute when we are on a 'indexed field' anyone know if there's a rewriter before get_mm_leaf and others index optimization? maybe it do something that change: a>10

Re: [Maria-developers] RFC: Pausing a query thread

m will "pause" too. They'll wait > for the lock, and may eventually time out. > > Regards, > Sergei > > > ___ > Mailing list: https://launchpad.net/~maria-developers > Post to : maria-developers@lists.launchpad.n

Re: [Maria-developers] RFC: Pausing a query thread

i reread your emails, are you thinking something like this: 1)select * from table (very big) 2)update table (lock reads, very time consuming) 3)select * from table2 (very small, but i/o is very high and it will be very time consuming) questions: 1)you want to pause 1 or 2 or 3? 2)maybe

Re: [Maria-developers] RFC: Pausing a query thread

hi marian, could you see MDEV-4623 and MDEV-4427, and tell me if that could help you? MDEV-4623 - https://mariadb.atlassian.net/browse/MDEV-4623 - lock/unlock connection MDEV-4427 - https://mariadb.at

Re: [Maria-developers] Help with MDEV-4419, ENUM optimization

hum, should i use this function in sql_select.cc? remove_eq_conds() /** Remove const and eq items. Return new item, or NULL if no condition cond_value is set to according: COND_OKquery is possible (field = constant) COND_TRUE always true ( 1 = 1 ) COND_FALSE always false ( 1 = 2 )

Re: [Maria-developers] RFC: Pausing a query thread

hi marian, as a beginner mysql developer, could i ask some questions? your plugin is based in daemon? information schema? other kind of plugin? just to help me how could expand mariadb ___ Mailing list: https://launchpad.net/~maria-developers Post to

Re: [Maria-developers] RFC: Pausing a query thread

hi Peter, i was helping some guys in a datacenter here in brazil and they implement server hosting via virtual machines, in other words, they have a very big linux cluster and many virtual machines with memory/cpu restrictions, maybe that's the solution they give... in each virtual machine they run

[Maria-developers] Debug interface

lace to ask about it? -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp

Re: [Maria-developers] RFC: Pausing a query thread

about the priority column i will create a MDEV but i don't know if it's a good solution (maybe a performace tune, not feature that every body will use) the MDEV is: MDEV-4705 but again, i don't know if i will do it and if anyone will do it too, but

Re: [Maria-developers] RFC: Pausing a query thread

hi marian, you told what i'm think, the main problem is 'pause' query and 'continue' query without disconnect the user, not the priority level i think that MDEV-4623 is the solution to our problems, plus some others tunes and automatic scripts that check that a query is blocking the system and pau

Re: [Maria-developers] query cache issue

it's a memory in client side with query_parameters (sql_mode, query text, schema used, and others flags that change results) + query_results example in php $query_cache= array( "sql_mode=12341234124124;SELECT * from query_Table" => array( "tables_used"=>array("query_Table"), 0=>array('a'=>1,'b'

Re: [Maria-developers] query cache issue

Nice, in this case, should be nice implement a cache server, and mysql servers will send cache to it? something like: 5 mysql clients (no cache here) < - >10 mysql servers (100mb of cache each) < - >2 cache servers (16gb of cache each) we could use local cache + remote cache, for example, wi

Re: [Maria-developers] Doubt at query cache resize

hi sergei, it was a warning of cmake in windows, i will read more and check if it's ok or just a windows wrong message 2013/6/28 Sergei Golubchik > Hi, Roberto! > > On Jun 23, Roberto Spadim wrote: > > Hi guys > > I was trying to compile in windows and warning was dis

[Maria-developers] Developer course

cus on query rewrite (select.cc), optimizer (opt_range.cc/opt_*) and partition engine, others engine (myisam,heap,innodb,aria) is not my priority now -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to

Re: [Maria-developers] Developer course

hi james! thanks for your time! 2013/7/4 James Briggs : > Hi Roberto. > > I don't know anything about courses inside Oracle or Mariadb.com. me too k :P > But I googled around and found the following outside resources: > > - MySQL Internals Manual (online) this one i found, but it don't give

Re: [Maria-developers] Developer course

i found a very nice ftp copy of internal classes and others features of sun http://ftp.nchu.edu.tw/MySQL/sources/doxygen/mysql-5.1/classes.html 2013/7/4 Roberto Spadim : > hi james! thanks for your time! > > 2013/7/4 James Briggs : >> Hi Roberto. >> >> I don't kn

[Maria-developers] Replication

ier way to mark tables? maybe alter table REPLICATION=ON/OFF if not, could we add this feature? thanks guys -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubsc

[Maria-developers] SO_REUSEPORT and mariadb

new_fd = accept(...); process_connection(new_fd); } -- i didn -- Roberto Spadim ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria

  1   2   3   4   >