Re: problem with select *

På mandag 24. august 2015 kl. 09:04:07, skrev bhuvan Mitra <bhuvanrjb(at)gmail(dot)com
<mailto:bhuvanrjb(at)gmail(dot)com>>:
Hello,
 
I have a table with 12 columns and 20 Million rows. While writing the table I
do not find any problem but when reading that I have some issues faced. When I
perform a 'select * from table limit 14000000;' (selecting 14million rows), it
is working fine. If the limit value is 15000000, it is throwing the error as
'out of memory'.
 
If the query is 'select * from table' , The process is getting killed by
displaying the message 'killed'.
 
Kindly tell me where it is going wrong. I have 6MB cache, 1.6GHz CPU, linux
14.04 OS, 8GB RAM.

 
In what application are you performing these queries?
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>