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 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
- When we run the query however and output to a file, it takes about 10-15 minutes to start writing to the file, then once it starts, it writes 28Mb to the file, then it waits again for another 10-15 minutes, and writes another 28Mb's and so it continues until it eventually completes.
for the amount of records and the fact that it uses indexes, this should be running quite fast, however we cant seem to figure out this behaviour.
Can anyone perhaps assist me with this as the help woul dbe greatly appreciated.
Regards
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Feb 19
Carsten Pedersen Re: Mysql into outfile problem
Feb 19, 2014; 11:51
Carsten Pedersen
Re: Mysql into outfile problem
Feb 19
Machiel Richards Re: Mysql into outfile problem
Feb 19, 2014; 13:02
Machiel Richards
Re: Mysql into outfile problem
Feb 19
Johan De Meersman Re: Mysql into outfile problem
Feb 19, 2014; 14:33
Johan De Meersman
Re: Mysql into outfile problem
Feb 19
Johan De Meersman Re: Mysql into outfile problem
Feb 19, 2014; 14:44
Johan De Meersman
Re: Mysql into outfile problem
Feb 19
Machiel Richards Re: Mysql into outfile problem
Feb 19, 2014; 15:38
Machiel Richards
Re: Mysql into outfile problem
Feb 19
Carsten Pedersen Re: Mysql into outfile problem
Feb 19, 2014; 15:47
Carsten Pedersen
Re: Mysql into outfile problem
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!