什么时候我在mysql 5中内存不足 [英] when do i get out of memory in mysql 5

问题描述

我试图找出我是否可以获得记忆如果我这样做

I am trying to find out if i can get "out a memory" if i do

insert into schema.table
select * from schema2.table;

现在我在schema2.table中有大约70万行



schema2.table有多大要忘记内存了吗？



和第二个问题



有什么可能看的所以我不会失去记忆



谢谢，

Sas Gabriel

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

推荐答案

为什么内存不足？数据存储在磁盘上，并不需要同时完全存储在内存中。你只需要足够的磁盘空间。



祝你好运！

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!

这篇关于什么时候我在mysql 5中内存不足的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！