Thanks, I am looking answer internally how the thinks work.
Regards,
Krishna
On Fri, Jun 26, 2009 at 2:33 PM, Moon's Father yueliangdao0...@gmail.comwrote:
Hi.
I think innodb will split these into many small pieces and then merge them
to execute.
On Thu, Jun 18, 2009 at 1:52 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi guys,
On MIS (management information system) server we have 16GB of physical
memory. 10GB has been allocated to innodb_buffer_pool_size. Database size
is
around 500GB and some tables contains 600millions records.
my question is if innodb index_length(25GB) is greater than
data_length(20GB). How innodb manage and execute (select query) the join
between the bigger table which contains 500millions and 600millions
records.
Although innodb_buffer_pool has been allocated only 10GB.
Any response is highly appreciated.
Thanks in advance.
Thanks,
Krishna
--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My Blog:http://yueliangdao0608.cublog.cn