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?

Options: ReplyQuote


Subject
Written By
Posted
February 03, 2019 06:48AM
February 03, 2019 09:40AM
Re: InnoDB size
February 04, 2019 02:40AM
February 04, 2019 11:22AM


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.