Thanks, I am looking answer internally how the thinks work. Regards, Krishna
On Fri, Jun 26, 2009 at 2:33 PM, Moon's Father <[email protected]>wrote: > 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 < > [email protected]> 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 >
