Imagine we have a table which has 100 Million rows and 80 GB size.
Every rows has Text column and multiply integer columns.
we set Innodb_buffer_pool_size to 40G
I executing this Query:
select text,id,like_count from example where time > 'xxx-xx-xx' and time < 'xxx-xx-xx'
So if this query need to read 50G of data file (because of query) and move to Buffer Pool. I want to know how buffer pool handle this data.
because We set buffer pool to 40G but query need 50G to handle it.