Re: [Maria-developers] Review of patch for MDEV-4820

2013-08-19 Thread Kristian Nielsen
Pavel Ivanov piva...@google.com writes: I think to fix this bug we should stop using gtid_slave_pos as indication of the current db state. We should make it possible to Agree. change gtid_binlog_pos when there's no events in binlogs. And when Ok. Actually, I think we should expose the real

Re: [Maria-developers] MariaDB mutex contention

2013-08-19 Thread Roberto Spadim
hi! Another plugin that should be disabled is QUERY_RESPONSE_TIME. It has quite some impact on LOCK_plugin: -DWITH_QUERY_RESPONSE_TIME=1 +-++-+ | event_name | count_star | sum_timer_wait |

Re: [Maria-developers] MariaDB mutex contention

2013-08-19 Thread MARK CALLAGHAN
Is it reasonable for semi-sync to need to lock/unlock LOCK_plugin that frequently? The plugin architecture, like most of the rest of MySQL, wasn't described to people on the outside (like me). On Mon, Aug 19, 2013 at 6:32 AM, Pavel Ivanov piva...@google.com wrote: On Mon, Aug 19, 2013 at 5:17

Re: [Maria-developers] Can there be a better storage engine API?

2013-08-19 Thread MARK CALLAGHAN
Thanks for your response. On Fri, Aug 16, 2013 at 11:23 AM, Zardosht Kasheff zardo...@gmail.comwrote: I've worked on the TokuDB storage engine for quite a while now. I have had many experiences over the years, so I guess it's hard to know where to begin. I guess I will start small, and if the

Re: [Maria-developers] linking an external library

2013-08-19 Thread Stewart Smith
rg rgross...@gmail.com writes: I want to link an external library for a language extension. After several hours of trying to tell cmake (^%$@*) to pick it up for linking the library would still not be built with. did you remove the CMakeCache.txt file? CMake is garbage like that. -- Stewart

Re: [Maria-developers] Can there be a better storage engine API?

2013-08-19 Thread Jan Lindström
Hi, From experience working on two storage engines on MySQL and being main developer for the second one, and one storage engine on big company, I would say MySQL storage engine API has some legacy problems and clearly some missing functionality. e.g. - Some part of the storage engines are

Re: [Maria-developers] Can there be a better storage engine API?

2013-08-19 Thread MARK CALLAGHAN
Welcome back to the MySQL community Jan. It is good to see SkySQL/MariaDB get more InnoDB expertise. On Mon, Aug 19, 2013 at 9:32 AM, Jan Lindström jplin...@mariadb.org wrote: Hi, From experience working on two storage engines on MySQL and being main developer for the second one, and one

Re: [Maria-developers] linking an external library

2013-08-19 Thread Vladislav Vaintroub
TARGET_LINK_LIBRARIES({$LIBNAME}) is not a correct syntax It does need target (you link your library to some other library or executable, and this library or executable is called target) TARGET_LINK_LIBRARIES(target ${LIBNAME}) should work For example, if you want to link something with

Re: [Maria-developers] MariaDB mutex contention

2013-08-19 Thread Roberto Spadim
hummm some doubts since i never used/write an audit plugin... the lock_plugin of query response time, is a audit plugin + a information schema plugin right? he audit plugin is 'called' at query start and query end? or there's more locks used? when used the locked is used in what case? to lock the

Re: [Maria-developers] MDEV-4911 - KILL command with query id

2013-08-19 Thread Roberto Spadim
uhmmm i didn't think about the if_idle, it was a mail at maria-discuss that send the patch of google mysql (must check if i'm wrong), and i ported the patch to mariadb code the state='' could be really nice, an very good idea =] 2013/8/19 Eric Bergen eric.ber...@gmail.com: If you're going

Re: [Maria-developers] Can there be a better storage engine API?

2013-08-19 Thread Peter Laursen
I think PBXT is the best example till now that the SE API actually works. Paul, who created it, also was not grown in MySQL but he managed to figure out good enough to write a complete transactional general-purpose storage engine. It did not quite reach GA level. But I don't think the API is to

Re: [Maria-developers] Can there be a better storage engine API?

2013-08-19 Thread Leif Walsh
Hi Mark, TokuMX is a quite different beast than TokuDB. First of all, we already had the experience of integrating our engine into one database product before we started. So many kinks in the TokuKV layer had already been worked out. But more importantly, TokuMX/MongoDB doesn't have a storage

Re: [Maria-developers] linking an external library

2013-08-19 Thread Vladislav Vaintroub
For embedded, libsql.a is not used. Instead, there is libsql_embedded.a, and it is built in libmysqld/CMakeLists.txt So, - If you want your static library to be merged into one big libmysqld.a , you need to add it into the LIBS list (see SET(LIBS.) in the CMakeLists.txt). -

[Maria-developers] Master slave

2013-08-19 Thread Richard Couture
Is it possible to set up replication in such a manner as to permit writing records to either a master or a slave replica? We want to set up a fail safe replica that can easily take over when our connection to the main replica fails, which, unfortunately, is fairly often. I read a document,

Re: [Maria-developers] [Otto Kekäläinen] Fwd: initial feedback on mar iadb

2013-08-19 Thread Michael Widenius
Hi! Otto == Otto Kekäläinen o...@fsfe.org writes: Otto 2013/8/18 Sergei Golubchik s...@mariadb.org: I'd say, let us treat the copyright headers in source files as the authoritative source. Then the debian copyright file should simply say exactly what copyright comments do. And there will be

Re: [Maria-developers] MDEV-4911 - KILL command with query id

2013-08-19 Thread Roberto Spadim
maybe we could use (a bit complex, but nice): KILL QUERY_ID IN (SELECT QUERY_ID FROM information_schema.PROCESSLIST WHERE ...) or KILL THREAD_ID IN (SELECT id FROM information_schema.PROCESSLIST WHERE ...) or KILL USER IN (SELECT user FROM information_schema.PROCESSLIST WHERE ...)