MySQL select into outfile, select data amount (file size limit)

I am selecting huge amounts of data (~ 10-100 mbytes) from 400M-1G tables, I am using query:

select log from logs_010110 where [cond] into outfile '/tmp/log.txt'

the problem is - /tmp/log.txt开发者_Python百科 file size EVERY time is 14134375 bytes == 15Mb so I think there is some limit for select statement which I need to override to select big amounts of data. What variable controls this limit/how can I set it bigger?

You need to increase buffer_pool_size mysql param!