when do i get out of memory in mysql 5

Question

0.00/5 (No votes)

See more:

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

Gabriel Sas

Add a Solution

Comments

ZurdoDev 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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

E.F. Nijboer · Accepted Answer · 2013-02-07T04:57:00

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!

Posted 7-Feb-13 4:57am

E.F. Nijboer

Comments

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