"Kris, please have a look at our database. We are running a
materialized dataset processor, and on a database with about 40
GB of buffer pool and a database size of 6 GB, we are observing
Now, that is interesting. The box in question has 48 GB of memory, and indeed, hardly 6 GB of data.
-> sum(data_length+index_length)/1024/1024/1024 as gb
-> from tables
-> where table_schema not in ('information_schema', 'performance_schema', 'mysql');