Re: Xml data import

2014-12-12 Thread Sayth Renshaw
And does that then lead you to use Fabric? http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding Sayth On Sat, 13 Dec 2014 9:06 AM Larry Martell wrote: > On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw > wrote: > > So it is definitely achievable, I see other db

Re: Xml data import

2014-12-12 Thread Larry Martell
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw wrote: > So it is definitely achievable, I see other db's converting xml2json etc to > get it in. I use this https://github.com/hay/xml2json > Sends odd that xml had done great document qualities but as a data format > it seems rather hard to work w

Re: Xml data import

2014-12-12 Thread Sayth Renshaw
So it is definitely achievable, I see other db's converting xml2json etc to get it in. Sends odd that xml had done great document qualities but as a data format it seems rather hard to work with. Sayth On Fri, 12 Dec 2014 9:55 PM Johan De Meersman wrote: > > - Original Message - > > Fr

Function

2014-12-12 Thread Alexander Syvak
Hello! How is actually a function done internally in MySQL after CREATE FUNCTION statement? Why can't there be a dynamic SQL inside a function?

Re: command is not allowed with this MySQL version

2014-12-12 Thread hsv
2014/12/12 02:10 +0100, Christophe When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile for instance) can be us

Re: How to retrieve next record?

2014-12-12 Thread Trianon 33
Thanks Johan, You're partly right in your interpretation, but not in total :-) Later on in time I'll lift a tip. I need some time to process your answer and do my homework. Nevertheless I've got already something that works, but maybe isn't the most efficient. Nevertheless a good start, th

Re: How to retrieve next record?

2014-12-12 Thread Trianon 33
Thanks Martin, But loading ALL the records sums up to (now) 10 mio records and further on in future up to 100 mio records. H, don't think that's wise. Nevertheless, thanks for thinking alog. BR, Hans. Martin Gainty schreef op 11-12-14 om 23:33: If you *dont* mind implementing your f

Re: signal handling in mysql cli

2014-12-12 Thread Sebastien FLAESCH
Thank you Rafal for your answer! We do not use threads, it's a single threaded program. So we cannot set a flag to exec the KILL QUERY later on in another thread. The only flag I use is to avoid subsequent KILL QUERY attempts when one has already been sent... The code in the sigint handler is q

[Solved] Re: command is not allowed with this MySQL version

2014-12-12 Thread Christophe
Hi, Le 12/12/2014 11:51, Johan De Meersman a écrit : - Original Message - From: "yoku ts." Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun

Re: Re: signal handling in mysql cli

2014-12-12 Thread rafal somla
Hello Sebastein, On 2014-12-03 17:25, Sebastien FLAESCH wrote: Hi all, I have a similar question regarding KILL QUERY usage: We have a C client program using libmysqlclient.so, it is a single-threaded program. When running a long query, how can I send the KILL QUERY command when a SIGINT (CTR

Re: Xml data import

2014-12-12 Thread Johan De Meersman
- Original Message - > From: "Sayth Renshaw" > Subject: Xml data import > > I have an xml data feed with xsd, it's complex in elements not size. Wray > are the best way to get data into mysql, do I have to hack with xquery? That's going to depend on the complexity of your XML and how mu

Re: command is not allowed with this MySQL version

2014-12-12 Thread Johan De Meersman
- Original Message - > From: "yoku ts." > Subject: Re: command is not allowed with this MySQL version > > Christophe has already told, >> > The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was, too. > Mayb

Re: forum vs email

2014-12-12 Thread Lucio Chiappetti
True; and before that there was yahoo groups, and others. Those are not fora, however, merely web interfaces to mailing lists / newsgroups. as a lurker on this list, I jump in. It is curious that newsgroups are mentioned only en passant, and NNTP is not mentioned at all. Still vastly prefer e