Re: InnoDB size
Posted by:
Sasi Tovi
Date: February 04, 2019 02:40AM
Hi,
these are the details:
# engine, data, indexes, total
'InnoDB', '11.60 GB', '4.63 GB', '16.23 GB'
'CSV', '0.00 GB', '0.00 GB', '0.00 GB'
'MEMORY', '0.00 GB', '0.00 GB', '0.00 GB'
'MyISAM', '0.00 GB', '0.00 GB', '0.00 GB'
'TOTALS', '11.61 GB', '4.63 GB', '16.23 GB'
In the above, you can see that Mysql Innodb using only half (data + index = ~12G) of his dedicated memory (24G total).???
Is this normal behavior?
In general, Does Mysql acts like Sql server/Oracle and takes all the memory as much as it can?
I'm asking this because when I Monitor SQL Server, I can see that it use all his memory that dedicated for him, something that I can't see in mysql Innodb.
Am I missing something?