On Nov 22, 2009, at 8:54 AM, Ryan Chan wrote:
Hello,
Is it common heard from people that if you have large table (assume
MyISAM in my case), you need large memory in order to have the
key/index in memory for performance, otherwise, table scan on disk is
slow.
But how to estimate how much
Hello,
Is it common heard from people that if you have large table (assume
MyISAM in my case), you need large memory in order to have the
key/index in memory for performance, otherwise, table scan on disk is
slow.
But how to estimate how much memory I need?
Consider a simple case, a MyISAM
In the last episode (Nov 22), Ryan Chan said:
Is it common heard from people that if you have large table (assume MyISAM
in my case), you need large memory in order to have the key/index in
memory for performance, otherwise, table scan on disk is slow.
But how to estimate how much memory I