Re: [Maria-discuss] Backup on the replication server getting affected

2023-06-09 Thread Kristian Nielsen
ragul rangarajan writes: > Indeed the environment where we are able to see the issue is in *MariaDB > 10.6.10 *and using pool-of-threads. Cool, thanks ragul, that confirms that your issue is caused by the MDEV-29843. - Kristian. ___ Mailing list: ht

Re: [Maria-discuss] Backup on the replication server getting affected

2023-06-09 Thread Kristian Nielsen
ragul rangarajan writes: > Hope my issue is more related to the issue MDEV-30780 optimistic parallel > slave hangs after hit an error > Trying to reproduce with a minimal database. > > Attaching the gbd output Thanks, that gdb output is really helpful! I agree with Andrei that this rules out MD

Re: [Maria-discuss] Privilege Question

2023-04-06 Thread Kristian Nielsen
Scott Canaan writes: > Thank you. I found SUPER, but was trying to avoid using it as it > gives too many privileges. I was looking for something more > fine-grained. Maybe you can define a stored procedure with SQL SECURITY DEFINER (and a DEFINER with the SUPER priviledge) that sets the desire

Re: [Maria-discuss] Code of Conduct

2022-12-22 Thread Kristian Nielsen
Andrew Hutchings writes: > Instead the intention is to discourage people from personal attacks at > each other, which negatively affects the group as a whole. It doesn't affect anyone at all expect those that choose to read them and have nothing better to spend their time on than react to them a

Re: [Maria-discuss] MariaDB master-slave chained replication and parallelism

2021-08-06 Thread Kristian Nielsen
andrei.el...@pp.inet.fi writes: > And the above transition can be explained by > MDEV-24654 GTID event falsely marked transactional, its patch is under > review. Oh, yes, this bug sounds like it could result in what Jan described. It was not clear to me from the bug description exactly under what

Re: [Maria-discuss] MariaDB master-slave chained replication and parallelism

2021-08-05 Thread Kristian Nielsen
Jan Křístek writes: > We have a MariaDB 10.3 replication setup with one master and a few chained > slaves (each has log_slave_updates switched on). Master uses mainly MyISAM > tables, slaves have about 10 or 40 threads for parallel replication. > > Interesting is, that the first slave in the chai

Re: [Maria-discuss] GTID and missing domain

2021-02-27 Thread Kristian Nielsen
mari...@biblestuph.com writes: > And my primary server has: > > gtid_binlog_pos 0-303-67739600,1-303-7363061243,100-303-4338582 > > gtid_binlog_state > 0-302-67690294,0-301-67719794,0-303-67739600,1-301-7350472534,1-302-7350381758,1-303-7363061243,100-302-4242958,100-301-4332195,

Re: [Maria-discuss] fsync alternative

2019-09-13 Thread Kristian Nielsen
Marko Mäkelä writes: > There is some ongoing development work around this area. If the binlog > is enabled, it should actually be unnecessary to persist the storage > engine log, because it should be possible to replay any > not-committed-in-engine transactions from the binlog. We must merely Ni

Re: [Maria-discuss] fsync alternative

2019-09-07 Thread Kristian Nielsen
Jure Sah writes: > It would appear that on a typical webserver, the majority of disk i/o > belongs to the MariaDB database process. It would appear it's mostly > waiting on fsync(), which to my understanding is executed at least once > per commit. Group commit can amortise this if there are mult

Re: [Maria-discuss] gtid and current_pos vs slave_pos

2019-04-24 Thread Kristian Nielsen
mari...@biblestuph.com writes: > TEMPORARY TABLE statement that was injected on Slave C? Does setting > sql_log_bin=0 prior to the creation of the temporary table also > prevent the creation of these DROP statements? Well, it should prevent it. (But since it is a bug causing these redundant drop

Re: [Maria-discuss] gtid and current_pos vs slave_pos

2019-04-23 Thread Kristian Nielsen
mari...@biblestuph.com writes: > I have four servers all running 10.3 as follows: > >A <=> B => C => D > and C is a master to D. In addition to their actual replicating DBs, > all four servers also have a "norep" DB that is used to create > temporary tables for local report processing (as wel

Re: [Maria-discuss] Post-MySQL(5.6) to MariaDB migration question - why are master_info_repository=TABLE and relay_log_info_repository=TABLE not supported?

2018-12-25 Thread Kristian Nielsen
Artem Russakovskii writes: > Thank you for the explanation. Helpful. I'm guessing once all slaves and > then the master are converted to mariadb, global transaction IDs are going > to start getting used (or maybe I'll need to tweak some variables). Because > right now it's empty on the one slave

Re: [Maria-discuss] Post-MySQL(5.6) to MariaDB migration question - why are master_info_repository=TABLE and relay_log_info_repository=TABLE not supported?

2018-12-24 Thread Kristian Nielsen
Artem Russakovskii writes: > Upon further analysis, it turned out to be the lack of support of > master_info_repository=TABLE and relay_log_info_repository=TABLE in > mariadb, which means the master information effectively disappeared as far > as the slave server is concerned. > the values fishe

Re: [Maria-discuss] gtid_slave_pos row count

2018-10-13 Thread Kristian Nielsen
Hi Reinis, I have now pushed a fix for this. I expect it will be included in the next release. Once again thanks for taking the time to do a good error report, glad to get this fixed. - Kristian. ___ Mailing list: https://launchpad.net/~maria-discuss

Re: [Maria-discuss] gtid_slave_pos row count

2018-10-08 Thread Kristian Nielsen
>> In any case, thanks Reinis for taking the time to report this serious issue, >> I'll see >> if I can come up with a patch to fix the problem. > > Thx and looking forward to it. I have now committed a patch that should fix this. If you want to try it, you can find it here: https://github.

Re: [Maria-discuss] gtid_slave_pos row count

2018-10-06 Thread Kristian Nielsen
"Reinis Rozitis" writes: > Is there a jira/github issue I could follow? I can put any updates in the MDEV-12147. - Kristian. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https:/

Re: [Maria-discuss] gtid_slave_pos row count

2018-10-02 Thread Kristian Nielsen
Kristian Nielsen writes: > (Hm. Actually... if a conflict is detected _after_ the transaction has > deleted old rows from the mysql.gtid_slave_pos table, then the deletions > will be rolled back along with the conflicting transaction, and it seems we > will get old rows left-over jus

Re: [Maria-discuss] gtid_slave_pos row count

2018-09-29 Thread Kristian Nielsen
Kristian Nielsen writes: > It is cool that optimistic replication works well in your setup to avoid > slave lag (but not cool that it causes this problem). I will try to see if I > can reproduce with simple test-generated traffic. But if you know of a way I > could reproduce that wou

Re: [Maria-discuss] gtid_slave_pos row count

2018-09-29 Thread Kristian Nielsen
Thanks for the additional info. TokuDB probably isn't the most used engine with optimistic parallel replication. I worked with a TokuDB developer some time ago to make it work, but I'm not sure how well those fixes are maintained in MariaDB (ie. I tried now running the testcase tokudb_rpl.rpl_para

Re: [Maria-discuss] gtid_slave_pos row count

2018-09-28 Thread Kristian Nielsen
"Reinis Rozitis" writes: > the table starts to grow continuously: > > MariaDB [mysql]> select count(*) from gtid_slave_pos; > +--+ > | count(*) | > +--+ > | 5577268 | > +--+ > 1 row in set (1.553 sec) That definitely look bad. As you say, there can be multiple rows in th

Re: [Maria-discuss] Replication Problem

2018-07-05 Thread Kristian Nielsen
Thomas Plant writes: > Your tip with 'MASTER_USE_GTID=slave_pos' fixed it.Will have to look > better in the documentation next time, never found the 'slave_pos' > mentioned or 'SET sql_log_bin=0'. > > Thank you very much for your help. Welcome, glad that you solved your problem. The slave_pos/c

Re: [Maria-discuss] Replication Problem

2018-07-04 Thread Kristian Nielsen
Thomas Plant writes: > Today I had time to look at the error, removed the duplicate ID from > the table and started the slave thread again using 'start slave;'. > > But now I get another error: > > Last_IO_Error: Got fatal error 1236 from master when reading data from > binary log: 'Error: connec

Re: [Maria-discuss] Replication New to Old

2018-04-05 Thread Kristian Nielsen
andrei.el...@pp.inet.fi writes: > Mike, > >> Hello, >> >> I realize that in general replication from a newer master to an older >> slave is typically not recommended.  This said, does anyone have an >> experience replicating from MariaDB 10.2 to MySQL 5.6? > > A problem that is evident at once is

Re: [Maria-discuss] Pacemaker and mariadb semi-sync

2017-08-09 Thread Kristian Nielsen
Nils Carlson writes: > I would be very happy for some review (and even testing) of this > resource-agent from somebody with expertise in mariadb replication. I do not think I can offer review or testing, but I can give a few general remarks, maybe they can be helpful. > The parameter set on eac

Re: [Maria-discuss] Duplication of documentation for binlog annotation and a question on replicate_annotate_row_events not being dynamic

2017-07-03 Thread Kristian Nielsen
"Jean-Francois B. Gagne" writes: > And the technical question about replicate_annotate_row_events: this > variable is not dynamic, is there a reason for that ? I understand that > this variable could/should only be modifiable while the slave is stopped, > but not being dynamic is not very DBA/Sy

Re: [Maria-discuss] Fix different gtid-positions on domain 0 in multi-master

2017-03-17 Thread Kristian Nielsen
Reinder Cuperus writes: > The problem is, as soon as I stop that connection, that master2 and > master3 have different gtid-positions for domain0, and stop/start on > replication master3->backup results in the error: > "Got fatal error 1236 from master when reading data from binary log: > 'Error:

Re: [Maria-discuss] Reg replication and commit

2016-10-14 Thread Kristian Nielsen
Karthick Subramanian writes: > Below when I try at Slave DB: > > MariaDB [dr_repl]> select * from test_dr_repl; > Empty set (0.00 sec) > > MariaDB [dr_repl]> commit; > Query OK, 0 rows affected (0.00 sec) > > MariaDB [dr_repl]> select * from test_dr_repl; > ++--+ > | id | val | > ++-

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.

2016-08-16 Thread Kristian Nielsen
Joseph Glanville writes: > This fixes the problem for me. How do we go about getting this into a release? I can push it. It should go into 10.1, I think (this code is not in 10.0). Thanks for testing! - Kristian. ___ Mailing list: https://launchpad

Re: [Maria-discuss] Semi-sync replication hangs when changing binlog filename.

2016-08-15 Thread Kristian Nielsen
Pavel Ivanov writes: > binlog ending at position mariadb-bin.04:2039896, somehow the > function ReplSemiSyncMaster::commitTrx() gets trx_wait_binlog_name = > 'mariadb-bin.05' and trx_wait_binlog_pos = 2039896. I.e. the > function gets the position of the transaction to wait semi-sync ack

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-08-10 Thread Kristian Nielsen
Rich, Cool, thanks for the pointers, that looks very helpful. I'll try to see if I can come up with something. - Kristian. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://lau

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-08-10 Thread Kristian Nielsen
Kristian Nielsen writes: > Rich Prohaska writes: > >> Is TokuDB supposed to call the thd report wait for API just prior to a >> thread about to wait on a tokudb lock? > > If I wanted to look into implementing this, do you have a quick pointer to > where in the TokuDB

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-08-10 Thread Kristian Nielsen
Rich Prohaska writes: > Is TokuDB supposed to call the thd report wait for API just prior to a > thread about to wait on a tokudb lock? If I wanted to look into implementing this, do you have a quick pointer to where in the TokuDB code I could start looking? Like the place where lock waits are d

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-08-08 Thread Kristian Nielsen
Rich Prohaska writes: > Is TokuDB supposed to call the thd report wait for API just prior to a > thread about to wait on a tokudb lock? Yes, that's basically it. Optimistic parallel replication runs transactions in parallel, but enforces that they commit in the original order. So suppose we hav

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-07-15 Thread Kristian Nielsen
Do you have a test case that can be used to repeat the bug? - Kristian. ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-07-15 Thread Kristian Nielsen
jocelyn fournier writes: > Thanks for the quick answer! I wonder if it would be possible the > automatically disable the optimistic parallel replication for an > engine if it does not implement it ? That would probably be good - though it would be better to just implement the necessary API, it's

Re: [Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?

2016-07-15 Thread Kristian Nielsen
jocelyn fournier writes: > After upgrading from TokuDB Enterprise with MariaDB 5.5 to MariaDB > 10.1.14, I tried to enable the parallel replication > (parallel_mode=optimistic, slave_parallel_threads=4) on a GTID enabled > Is this a known limitation with TokuDB ? Yes. TokuDB does not (to my kno

Re: [Maria-discuss] MariaDB non-blocking with EPOLL

2016-06-20 Thread Kristian Nielsen
Dave C writes: > With you help I was able to get the whole thing working this afternoon, > although I will need to spend a lot more time testing and checking I've > caught all the traps. Ok, great! > The core application uses edge triggered epoll for the sake of efficiency > and so far I have n

Re: [Maria-discuss] MariaDB non-blocking with EPOLL

2016-06-20 Thread Kristian Nielsen
Dave C writes: > Originally posted to : > http://stackoverflow.com/questions/37909652/mariadb-non-blocking-with-epoll > Edited for context. > > I have single threaded server written in C that accepts TCP/UDP connections > based on EPOLL and supports plugins for the multitude of protocol layers we

Re: [Maria-discuss] Long email about a replication issue

2016-06-01 Thread Kristian Nielsen
writes: > This weekend I had to repair a replication problem on one of our > clusters. I've attempted to get to the root cause but not sure where I Is this pure MariaDB replication, or is it Galera? I think it is the former, but the term "cluster" is somewhat overloaded, which is why I ask... >

Re: [Maria-discuss] HikariCP + searching archives

2016-04-16 Thread Kristian Nielsen
Stu Smith writes: > I'm curious if there is a way to search the archives for this list - I One way is to use google with an additional search term: site:lists.launchpad.net/maria-discuss This restricts the search to the archives. The maria-developers@ list can be similarly searched by addi

Re: [Maria-discuss] Collations, trailing spaces and unique indexes

2016-03-11 Thread Kristian Nielsen
Binarus writes: > "All MySQL collations are of type PADSPACE. This means that all CHAR, > VARCHAR, and TEXT values in MySQL are compared without regard to any > trailing spaces. “Comparison” in this context does not include the Yes, I have always found this terminally stupid as well. But I think

Re: [Maria-discuss] The insert performance issue

2016-03-10 Thread Kristian Nielsen
林澤宇 writes: > I use a file include 10 insert command statements to test the insert > performanc . > On local server ,the Mariadb spent about 20 second to insert data;but on > remote server ,the MariaDB spent about 30 second to insert data . > Why the MariaDB has about 10 second gap ? > Maybe

Re: [Maria-discuss] replicate_rewrite_db as a system variable

2015-11-27 Thread Kristian Nielsen
Ian Gilfillan writes: > Is there a reason replicate_rewrite_db is not available as a system > variable, while other similar settings, such as replicate_do_db are? I don't know of any specific reason, except that it is not implemented. Originally, none of these variables could be changed dynamica

Re: [Maria-discuss] Bug in MAX() function?

2015-06-22 Thread Kristian Nielsen
Benoit Panizzon writes: > MariaDB [maildb]> select mail_out_anon+mail_out_auth,timeslice from > domaincounters where domain_id=19 order by timeslice desc limit 24; This takes the first 24 rows by timeslice, and selects them. > select max(mail_out_anon+mail_out_auth),timeslice from domaincount

Re: [Maria-discuss] Error Message spelling mistake

2015-03-16 Thread Kristian Nielsen
Daniel Black writes: >> “Last_IO_Error: Got fatal error 1236 from master when reading data from >> binary log: 'Error: connecting slave requested to start from GTID 1-1-7, >> which is not in the master's binlog. Since the master's binlog contains >> GTIDs with higher sequence numbers, it probably

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-09 Thread Kristian Nielsen
Michael Widenius writes: > for the alpha so I suggested Sergei today that we should enable it for > the beta period of MariaDB 10.0 (10.*1* beta, I guess?) > As most MariaDB users should know, the feedback is totally anonymous > and no private or sensitive information is being sent. > > Any com

Re: [Maria-discuss] The relay-log is not fluashed after the slave-relay-log.999999 showed

2015-01-05 Thread Kristian Nielsen
Gmail writes: > And, as I mentioned at the title of this question, the relay-log is not > flushed after the slave-relay-log.99 showed when using > "Salve_parallel_threads:10" setting. like showed blow. > > - binlog_format: ROW > - Slave_parallel_threads:10 > > Everything are working fine exce

Re: [Maria-discuss] Excluding plugins when building MariaDB 10.1

2014-09-03 Thread Kristian Nielsen
Kolbe Kegel writes: > cmake ../server/ -DBUILD_CONFIG=mysql_release -DWITH_SSL=system > -DCMAKE_CXX_FLAGS:STRING='-stdlib=libstdc++' -DPLUGIN_TOKUDB=NO > -DPLUGIN_OQGRAPH=NO -DWITH_EMBEDDED_SERVER:BOOL=OFF -DWITH_WSREP=OFF > > The build is failing on tokudb code even though I am trying to avoid

Re: [Maria-discuss] New Question: Multi Master Replication

2014-03-27 Thread Kristian Nielsen
AskMonty KB writes: > What I am having a problem with is if I add a new master. When I add the > master the data in the slave table is truncated and only the data from the > new master is replicated. I loose all my old data in the slave. The obvious guess is that the new master has DROP TABL

Re: [Maria-discuss] MariaDB vs. MySQL error codes (1900+)

2014-03-17 Thread Kristian Nielsen
Felipe Gasper writes: > Hi everyone, > > I notice that MariaDB is using the 1900+ range for its own > error codes; however, MySQL 5.7, at least, has a few errors in that > range as well. > > Are error codes just going to be an area of increasing > conflict between the two, or is there

[Maria-discuss] GCC native thread local storage (Was: xtradb in 10.0)

2014-02-07 Thread Kristian Nielsen
Laurynas Biveinis writes: > We have another platform-specific addition: thread-local storage > implemented by __thread GCC keyword, which is GNU specific. This is Hm, this is interesting, I was not aware of the __thread feature. This looks to be much more efficient than pthread_getspecific(), wh

Re: [Maria-discuss] Question about MariaDB Non-blocking Client

2013-08-07 Thread Kristian Nielsen
Mike Gibson writes: > Greetings, Hi, sorry for taking a few days to get back to you: > I'm using the MariaDB Non-blocking API to write a C++ client, but I've hit > a wall regarding connection checking. I've been referencing the binding > from node-mariasql ( > https://github.com/mscdex/node-mar

Re: [Maria-discuss] openbsd switched libmysqlclient back to older mysql one

2013-06-13 Thread Kristian Nielsen
Colin Charles writes: > I noticed this: > > http://www.openbsd.org/cgi-bin/cvsweb/ports/databases/mariadb/Makefile?rev=1.4 > > Revert back to using MySQL 5.1 for the time being. MariaDB 5.5 introduces > a new libmysqlclient non-blocking API which utilizes co-routines. The X86 > specific GC

Re: [Maria-discuss] WL#4925 and multi-source replication

2013-03-15 Thread Kristian Nielsen
Greg writes: > This morning I've removed DRBD to verify that it is not the bottleneck, and > It's much faster with DRBD ! Yes, because with DRBD, an fdatasync() only needs to do a network trip to the other node. On local disk, it needs a physical disk write, which can take 10 milliseconds (

Re: [Maria-discuss] WL#4925 and multi-source replication

2013-03-15 Thread Kristian Nielsen
Greg writes: > I think you're right. I know that DRBD is not the best choice to have > high-availibility on a MariaDB master, but I have my reasons to make this Isn't it? I do not have practical experience with MariaDB/MySQL in a HA setup, but I have always thought that DRBD was one of the best

Re: [Maria-discuss] WL#4925 and multi-source replication

2013-03-15 Thread Kristian Nielsen
Greg writes: > With "kill -9 mysqld", and sync_binlog=0, I'm not really surprised since > mysql will not fdatasync after each commit, right ? Right. So this is mostly just my own academic interest, in practice it is of course real crashes/powerfailures we want to handle, not SIGKILL. If you are

Re: [Maria-discuss] WL#4925 and multi-source replication

2013-03-14 Thread Kristian Nielsen
Greg writes: >> I didn't think that sync_binlog=1 is required anymore for safe reliction. >> >> We are always using group commit in MariaDB 10.0 for the master, so >> the binary log will be synced for each group commit, which is safe. >> > > I have to use it in a DRBD config. When testing this co

Re: [Maria-discuss] testing Galera

2013-02-12 Thread Kristian Nielsen
Jan Kirchhoff writes: > Kristian, > I didn't know of that function, good to hear that. > > But I was after some kind of slave_skip_counter-like function to make > galera skip an event in case of problems. I'm fine with a cluster member > stopping (or going read-only or something like that) becaus

Re: [Maria-discuss] testing Galera

2013-02-12 Thread Kristian Nielsen
Jan Kirchhoff writes: > Is there something like slave_skip_counter, aka "I Know what I do, skip > that update"? I think I have to take a new snapshot to get the second Yes, MariaDB has this: https://kb.askmonty.org/en/selectively-skipping-replication-of-binlog-events/ If you set skip_repl

Re: [Maria-discuss] mariasql client question (zappajs, coffeescript, nodejs)

2013-02-05 Thread Kristian Nielsen
klrumpf writes: > I now want to switch to the mariasql client... Cool, that is an interesting project ... > res.on("row", (row) -> > console.log "Result row: " + inspect(row) > @get '/': (req,res) -> # LANDING PAGE) >result = doSql("select pakz from pkt where pktnr=10001") >

Re: [Maria-discuss] MariaDB's tracking of MySQL changes

2013-02-04 Thread Kristian Nielsen
Christian Convey writes: > So what's the deal? Does MariaDB have alternative implementations for > just some of MySQL's components, and when a new MySQL release comes > out, MariaDB updates just those components for which it doesn't have > its own versions? That is more or less it, yes. - Kri

Re: [Maria-discuss] can xtradb and innodb coexist in mariadb?

2011-09-28 Thread Kristian Nielsen
Federico Razzoli writes: > I'd like to test the differences between InnoDB and XtraDB, but I don't want > to have 2 MariaDB instances. Is there some way to compile MariaDB with both > Innodb and XtraDB? It is possible to compile MariaDB with both if one builds one of them (or both) as dynamic

Re: [Maria-discuss] failed to initialize plugins error

2011-09-09 Thread Kristian Nielsen
Patrick Galbraith writes: > So, when I start mysqld, I get the error: > > "[ERROR] Failed to initialize plugins." I think this means that the plugin init function of a static plugin (or dynamic, but static seems more likely in this case) returned an error. Rather than it failing to load a dynam

Re: [Maria-discuss] MariaDB 5.6

2011-04-12 Thread Kristian Nielsen
"Adam M. Dutko" writes: > Does the following item under the Performance section indicate > optimizations for AMD chips are not being added? > > Better multi CPU performance above 16 cores (Work with Intel) No (very unlikely). The AMD and Intel x86_64 chips are quite similar, and most optim

Re: [Maria-discuss] MariaDB 5.6

2011-04-09 Thread Kristian Nielsen
Peter Laursen writes: > I noticed this on planet.mysql: http://kb.askmonty.org/v/plans-for-56 > > I *again* strongly want to discourage a major version number identical with > a MySQL/Oracle release. MySQL plans a 5.6 too and I believe that there is > already a source-tree available on launchpad

Re: [Maria-discuss] FreeBSD BuildBot Slave - I can offer one

2011-04-07 Thread Kristian Nielsen
"Jakob Lorberblatt" writes: > I noticed that you do not have a regular build of FreeBSD for either > common architecture (x86_64 or i386) I would be able to provide that for > you, I have equipment to spare and would be willing to lend this to the > project for building assistance; in addition I

Re: [Maria-discuss] MariaDB and Sun CoolThread

2011-04-03 Thread Kristian Nielsen
Alexandre Almeida writes: > As far as I can see MariaDB stay locked/running on a single > virtual CPU and MariaDB doesn't take advantage of CoolThread/CMT > technologies, I mean it can not run on more than one virtual CPU same > time. Result: poor performance. > > Anybody knows if

Re: [Maria-discuss] client library shared library version changed in 5.5.10

2011-03-28 Thread Kristian Nielsen
"Vladislav Vaintroub" writes: > For 5.5 the discussion starts here http://bugs.mysql.com/bug.php?id=59078 > ([9 Feb 2:26] Clint Byrum, IIRC he works for Debian). His argument that ABI > has changed "dramatically" is that for example an exported symbol named > TERMINATE has gone, while new symb

Re: [Maria-discuss] Installation problems of 5.2 in debian squueze

2011-03-12 Thread Kristian Nielsen
Πρεκατές Αλέξανδρος writes: > Then i used aptitude to update packages. > After choosing mariadb server and client aptitude warned me of conflicts > and > that i should remove mysql-server-core-5.1 That conflict is intentional. The way the .deb packages are made, they are supposed to r

Re: [Maria-discuss] Installation problems of 5.2 in debian squueze

2011-03-11 Thread Kristian Nielsen
Πρεκατές Αλέξανδρος writes: > in debian squeeze trying to install mariaDB5.2 i get a conflict withmysql- > core used by aconandi. what should i do? Can you provide some more details? - What version of MariaDB 5.2? - How did you try to install? Repository/mirror URL and exact commands use

Re: [Maria-discuss] Glibc 2.3 support in MariaDB builds ?

2010-12-19 Thread Kristian Nielsen
Jocelyn Fournier writes: > I'm trying to push my company to adopt MariaDB 5.2. Unfortunately, the > currently available binaries (at least for the x86-64 version) > requires a glibc 2.4, where we have only a 2.3 version (debian etch) > installed on our server. > MySQL 5.5 standard binaries, as we

Re: [Maria-discuss] SphinxSE missing plug.in

2010-12-16 Thread Kristian Nielsen
Brian Evans writes: > MariaDB 5.2.4 tarball is missing the SphinxSE plug.in file in > storage/sphinx. > > I'm not sure if this was intentional or not, so I thought I might > point it out. Oops :-( Thanks a lot for pointing out this serious issue! I filed a bug for it (https://bugs.launchpad.net

Re: [Maria-discuss] Non-root install of MariaDB

2010-11-05 Thread Kristian Nielsen
Arun Jagatheesan writes: > Is it mandatory to be a privileged user for MariaDB? (hope not so). No, it's not. > Is there an existing documentation or any suggestions for a non-root > instal of MariaDB on Linux (CentOS)? I would suggest starting from the INSTALL file in the distribution, the sec

Re: [Maria-discuss] my_atomic_add64

2010-08-24 Thread Kristian Nielsen
Antony T Curtis writes: > I think the 80486 introduced the cmp8xchg instruction. It appears you are right. Oleg, it seems that MySQL 5.5 already implements a 64-bit atomic add for 32-bit x86 platforms. Check include/atomic/x86-gcc.h , it uses the cmpxchg8b instruction. - Kristian. __

Re: [Maria-discuss] Full Replacement of MySQL (innoDB, mysql Workbench, data, etc)

2010-08-17 Thread Kristian Nielsen
Enrique writes: > Sphinx storage engine is included in the source, and here is explained > how to install SphinxSE: > http://kb.askmonty.org/v/sphinxse > But, is installed Sphinx (indexer, searchd, etc) with MariaDB? or we > must install Sphinx apart, and after that, install the SphinxSE > plugin

Re: [Maria-discuss] my_atomic_add64

2010-08-17 Thread Kristian Nielsen
Kristian Nielsen writes: > I think you'll also need > > make_transparent_unions(32) > #define U_32 int32 > #define Uv_32 int32 Gah. I meant of course this: make_transparent_unions(64) #define U_64 int64 #define Uv_64

Re: [Maria-discuss] my_atomic_add64

2010-08-17 Thread Kristian Nielsen
Oleg Tsarev writes: > I need my_atomic_add64 in mysql. > > Can i simple add following macros, or i need more advanced tricks? > > tsa...@main:/storage/project/percona/rtd_2$ diff -Nur > ../rtd/c/include/my_atomic.h c/include/my_atomic.h > --- ../rtd/c/include/my_atomic.h2010-07-09 16:35:1

Re: [Maria-discuss] Locale settings and fractal number

2010-08-16 Thread Kristian Nielsen
Oleg Tsarev writes: > I use string column, because i need fixed-point number (time column): > 14_digit_to_second.6_digit_to_microsecond > > 123456.654321 as example. > > Big number, because i have not only "time" column and also "sum" column too. > I didn't find any type what good for this, and i

Re: [Maria-discuss] where are the buildbot results for valgrind and the InnoDB plugin?

2010-07-25 Thread Kristian Nielsen
MARK CALLAGHAN writes: > I was asking about the tests not the plugin used. MariaDB should be > able to run all tests in mysql-test/suite/innodb_plugin for > storage/xtradb and for storage/innodb_plugin. It cannot per > https://bugs.launchpad.net/maria/+bug/609813 Why do you think the tests in my

Re: [Maria-discuss] where are the buildbot results for valgrind and the InnoDB plugin?

2010-07-25 Thread Kristian Nielsen
MARK CALLAGHAN writes: > There are no results for innodb_plugin.* in > http://buildbot.askmonty.org/buildbot/builders/work-amd64-valgrind/builds/636/steps/test/logs/stdio No, we do not run tests for the innodb_plugin in Buildbot. We run them for XtraDB (which shows up as just "innodb", as xtradb

Re: [Maria-discuss] where are the buildbot results for valgrind and the InnoDB plugin?

2010-07-25 Thread Kristian Nielsen
MARK CALLAGHAN writes: > As described in > http://mysqlha.blogspot.com/2010/07/building-mariadb-with-innodb-plugin.html > I did some of the QA checks that I do for any new code that I might > use. I have yet to find buildbot results for valgrind and the InnoDB > plugin or XtraDB. Are they not run

Re: [Maria-discuss] Fwd: MySQL Open Space

2010-04-09 Thread Kristian Nielsen
Henrik Ingo writes: > Didn't you have something about Buildbot you wanted to do? Maybe even have > someone from Drizzle join - depending on what you had planned to talk about. I have not planned anything. But I'm happy to do a session going through various aspects of Buildbot if there is an int

Re: [Maria-discuss] Why isn't SO_SNDTIMEO used?

2010-03-18 Thread Kristian Nielsen
Michael Widenius writes: >>>>>> "Kristian" == Kristian Nielsen writes: > Kristian> Well, I checked the code, and it seems to wake up the thread using > Kristian> pthread_kill(thread, signal) for the 'kill connection-id' command. > This sho

Re: [Maria-discuss] Why isn't SO_SNDTIMEO used?

2010-03-17 Thread Kristian Nielsen
> On Wed, Mar 10, 2010 at 12:29 PM, Michael Widenius wrote: >> We also use the thr_alarm() functionality when one uses 'kill >> connection-id' in MySQL.  I don't know of any easy way to gracefully >> wake up a thread that is sleeping on SO_SNDTIMEO. Do you? Well, I checked the code, and it seems

[Maria-discuss] [Kristian Nielsen] [Maria-developers] FOSDEM 2010

2009-11-11 Thread Kristian Nielsen
It occured to me that this might be better to send to -discuss to get a wider audience. Sorry if you receive this twice. - Kristian. --- Begin Message --- FOSDEM 2010 will be held next year on February 6-7. http://fosdem.org/ It looks like from MariaDB both I and Sergey Petrunya will be at

Re: [Maria-discuss] [Maria-developers] Information for release notes

2009-09-28 Thread Kristian Nielsen
Arjen Lentz writes: > Re NDB... the NDB in the source tree may not be production capable, > but it's technically functional. > Builds for Ubuntu tend to include NDB, and it actually works (I've > used it in training classes). > So that's already the real world. > > MariaDB may also consider a mag

Re: [Maria-discuss] [Maria-developers] MariaDB and the SCA

2009-09-03 Thread Kristian Nielsen
MARK CALLAGHAN writes: > Will MariaDB incorporate BSD-licensed features published by the community? Yes. Though looking at the web pages, this is not as clear as it could be. I did find it at the end of this page: http://askmonty.org/wiki/index.php/Working_with_the_community - Kristian.