Re: Table freeze when size exceeds innodb buffer pool size

[Peter Brawley]

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;