Click here to Skip to main content
11,721,289 members (84,289 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL queries
I am trying to find out if i can get "out a memory" if i do
insert into schema.table
select * from schema2.table;
now i have about 700 000 lines in schema2.table

how big does schema2.table has to be to get out of memory?

and second question

what are the possibilities to look at so i don't get "out of memory"

Thanks,
Sas Gabriel
Posted 7-Feb-13 4:24am
Comments
ryanb31 at 7-Feb-13 10:55am
   
Well, first off, out of memory will happen based on how much resources your server has. So, you'll have to look into that.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Why would it go out of memory? Data is stored on disk and doesn't need to be in memory completely all at the same time. You just need enough disk space.

Good luck!
  Permalink  
Comments
Gabriel Sas at 7-Feb-13 10:58am
   
but doing the Select statement won't use any memory?
Gabriel Sas at 7-Feb-13 10:59am
   
or only very little memory? and all of the data inserted will go into disk space?
E.F. Nijboer at 7-Feb-13 11:11am
   
Yes that's correct. The operation could be performed one row at a time. Even that could be broken into smaller operations by field. And field data could be handled in blocks. Operations would rather slow to a crawl before running out of memory.
Gabriel Sas at 7-Feb-13 11:49am
   
good, thanks for the info

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 515
1 OriginalGriff 279
2 Mika Wendelius 170
3 F-ES Sitecore 150
4 cyycoish 70
0 Sergey Alexandrovich Kryukov 2,209
1 OriginalGriff 969
2 F-ES Sitecore 660
3 Maciej Los 609
4 Richard MacCutchan 560


Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100