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.
Thanks.