Re: Mysql into outfile problem

I don't know what you mean by "straight" mysql connection. At any rate, the idea is to use --quick or otherwise using a connection which uses mysql_use_result over mysql_store_result. http://dev.mysql.com/doc/refman/5.6/en/mysql.html Best, / Carsten On 19-02-2014 12:02, Machiel Richards wrot

Re: Mysql into outfile problem

- Original Message - > From: "Machiel Richards" > Subject: Re: Mysql into outfile problem > > I have checked now and there is nothing in the Slow logs. It may be turned off, then. Depending on your version you can change the settings without having to restart the service, have a look a

Re: Mysql into outfile problem

I have checked now and there is nothing in the Slow logs. On 19/02/2014 15:33, Johan De Meersman wrote: - Original Message - From: "Machiel Richards" Subject: Mysql into outfile problem - when we run an explain on the query it shows that it is using indexes and the a

Re: Mysql into outfile problem

- Original Message - > From: "Machiel Richards" > Subject: Mysql into outfile problem > > - when we run an explain on the query it shows that it is > using indexes and the amount of rows it accesses is about 165000 rows > out of a 90mil+ rows table Not too bad, in and of i

Re: Mysql into outfile problem

Hi, the queries are done by connecting to the database using mysql workbench or otherwise after ssh to server by using straight mysql connection. regards On 19/02/2014 12:51, Carsten Pedersen wrote: If you're doing this from the cmd-line client, try running it using --quick. th Best,

Re: Mysql into outfile problem

If you're doing this from the cmd-line client, try running it using --quick. Best, / Carsten On 19-02-2014 09:03, Machiel Richards wrote: Hi guys I am hoping that someone might have experienced this before or might know why we are getting this. We regularly need to run some quer

career advice - Excel Expert and MySQL SQL specialist

Hi I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work 5% of my job with SQL but I am searching for a full time SQL job. http://shop.oreilly.com/product/0790145363466.do Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a junior SQL pro job? What do

Mysql into outfile problem

Hi guys I am hoping that someone might have experienced this before or might know why we are getting this. We regularly need to run some queries and export the results to a csv file. However we seem to be experiencing the following issues: - when we run an exp