- discuss - lists.mariadb.org

[Maria-discuss] New Question: CONNECT engine windows
by AskMonty KB 06 Feb '14

06 Feb '14

Hello, A new question has been asked in "CONNECT Table Types" by jpser2: -------------------------------- with mariadb 10.07 installed on windows, how to setup engines, particulary CONNECT engine We do appreciate your effort to produce an efficient product with many engines capabilities, But in your web site communication , it is not obvious that all the soultions exposed ( in particular, ENGINES) are effective, anf it they are : on what OS can they be installed. Thanks for answer -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-engine-windows/

1 0

[Maria-discuss] Connect engine assistance needed with nested first node in XML
by Rasmus Johansson 04 Feb '14

04 Feb '14

Hi, I'm trying to parse GPX files, which are XML with the connect engine. They look like this: <?xml version="1.0" encoding="UTF-8"?> <gpx version="1.1" creator="runtastic - makes sports funtastic, http://www.runtastic.com"> <trk> <trkseg> <trkpt lon="-0.7057708501815800" lat="51.4470825195312003"> <ele>76.6089172363281</ele> <time>2013-08-12T18:17:25.000Z</time> </trkpt> <trkpt lon="-0.7059442996978760" lat="51.4470443725586009"> <ele>72.1513061523437</ele> <time>2013-08-12T18:17:28.000Z</time> </trkpt> <trkpt lon="-0.7059520483016970" lat="51.4470558166503977"> <ele>75.0039749145508</ele> <time>2013-08-12T18:17:30.000Z</time> </trkpt> </trkseg> </trk> </gpx> Once I have the Connect -engine enabled I do the following: create table GPXSource ( lat char(20) field_format='@', lon char(20) field_format='@') engine=CONNECT table_type=XML file_name='/home/rasmus/nodegpxmariadb/public/uploads/runtastic_20130812_2157_Running.gpx' tabname='gpx/trk/trkseg' option_list='rownode=trkpt'; It doesn't work, I cannot figure out how to tell the Connect engine that the data I'm interested is beneath the gpx/trk/trkseg -node (tabname). If I remove the trk and trkseg -nodes from the data and just have the gpx -node left and all trkpt -nodes inside it everything works perfectly. Any help is appriciated. BR, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

3 8

[Maria-discuss] Threadpool benchmarks / feature note
by Colin Charles 01 Feb '14

01 Feb '14

Hi! Svoj: this is MDEV-5533 (https://mariadb.atlassian.net/browse/MDEV-5533) XL: Can you think about doing benchmarks like Ranger has done? (http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scala…) Thanks -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 2

[Maria-discuss] New Question: Maximum number of columns
by AskMonty KB 30 Jan '14

30 Jan '14

Hello, A new question has been asked in "MariaDB FAQ" by robpaton: -------------------------------- Hi there, What is the maximum number of columns a row can have in MariaDB? I can't find this info anywhere on the web. Best regards, Rob -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maximum-number-of-columns/

4 7

Re: [Maria-discuss] Threadpool benchmarks / feature note
by Colin Charles 30 Jan '14

30 Jan '14

Hi XL, On 28 Jan 2014, at 18:20, Axel Schwenke <axel(a)mariadb.com> wrote: > Hi Colin, > >> XL: Can you think about doing benchmarks like Ranger has done? (http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scala…) > > I did those benchmarks for 5.5. The r/w benchmark looked much worse than > what Percona has here. That's why I blogged results for readonly workload only. > > But they test with much more data - that might make the difference. I agree > that this benchmark should be repeated with 10.0. http://www.mysqlperformanceblog.com/2014/01/29/percona-server-thread-pool-i… Ranger has now responded (if he's reading this list, Hi!) cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

3 3

[Maria-discuss] GSoC 2014
by Rushi Shukla 30 Jan '14

30 Jan '14

Hello I am a student of Dhirubhai Ambani Institute of Information and Communication Technology (DAIICT), Gandhinagar, India. I am really interested in going for GSoC 2014. I would like to contribute to MariaDB community and for it to be my mentoring organisation for GSoC 2014. I am highly dedicated towards programming and research. How do I get started on working with the source code and playing around with it? Any sort of help is highly appreciated.Awaiting your reply soon. Regards, Rushi Shukla irc : rushboy

2 1

[Maria-discuss] Mariadb upgrade issues
by Constantine 27 Jan '14

27 Jan '14

Recently we migrate to mariadb and every version upgrade failed (last failed from 10.0.6 to 10.0.7). After investigation I find this thread http://mirzmaster.wordpress.com/2009/01/16/mysql-access-denied-for-user-deb… after password update issue fixed. I find bug https://bugs.launchpad.net/maria/+bug/983322 but it marked as incomplete -- With Best Regards, Constantine

2 1

[Maria-discuss] Guidance required
by Rushi Shukla 26 Jan '14

26 Jan '14

Hello I am a student of Dhirubhai Ambani Institute of Information and Communication Technology (DAIICT), Gandhinagar, India. I am really interested in going for GSoC 2014. I would like to contribute to MariaDB community and for it to be my mentoring organisation for GSoC 2014. I am highly dedicated towards programming and research. How do I get started on working with the source code and playing around with it? Any sort of help is highly appreciated.Awaiting your reply soon. Regards, Rushi Shukla

2 1

[Maria-discuss] New Question: Stable release of 10.0
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "What is in the different MariaDB releases?" by pranava: -------------------------------- Hi, In which month there will be a stable release of 10.0? We are using 5.5.34 and want to upgrade to 10.0 but are waiting for a stable release. Thanks Pranav. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/stable-release-of-100/

1 0

[Maria-discuss] New Question: Asynchronous Replication with Galera Cluster ?
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "Galera" by nicolasblanc: -------------------------------- My question is simple. Today i have a Galera Cluster with 3 nodes to write/read. And i want to put one(more to come) slave (asynchronous replication) to the cluster. As all my writes are located on 1 node, it's ok. But if i change the node on which the writes come... My slave is not synchronized anymore. I had to change the master of the slave to have the new written node as master. It seems that each galera node write only transactions from "real client" to replication binary log, not the ones from wsrep. Is there a way that i can ask to a Galera cluster node to always write commited transaction on the replication binary log ? Even if the transaction come from wsrep and not "real client" ? Thx in advance, -- Nicolas Blanc. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/asynchronous-replication-with-galera-cluster/

1 0