Click here to Skip to main content
12,555,488 members (55,000 online)
Rate this:
Please Sign up or sign in to vote.
See more: MySQL
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"

Sas Gabriel
Posted 7-Feb-13 4:24am
ryanb31 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
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!
Gabriel Sas 7-Feb-13 10:58am
but doing the Select statement won't use any memory?
Gabriel Sas 7-Feb-13 10:59am
or only very little memory? and all of the data inserted will go into disk space?
E.F. Nijboer 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.161021.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2016
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