MySQL Forums
Forum List  »  InnoDB

Re: Table freeze when size exceeds innodb buffer pool size
Posted by: Peter Brawley
Date: September 19, 2017 10:39AM

If all tables & indexes can fit into the buffer, InnoDB runs in memory.

The effect of table growth on performance depends on what queries are being run.

Let's see the results of ...

select  
  'innodb',  
  concat(round(raw/1024/1024,1),'MB') as totalLen,  
  @@innodb_buffer_pool_size as innodb_buffer_pool_size,  
  round(raw-(1.1*@@innodb_buffer_pool_size),0) as 'Suggested change' 
from ( 
  select sum(index_length) + sum(data_length) as raw 
  from information_schema.tables 
  where engine ='innodb' 
) sum; 

show variables;

show global table status;

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.