[Mysql using 50gb Ram]

Hey guys,

this is my first post, so please tell me if i do something wrong.

My Problem:

I'm using mysql innodb on Ubunut 18.04 > sql  Ver 14.14 Distrib 5.7.27 <

and im running unto some strange issues.

First: if i change the values in my.cnf for       innodb_buffer_pool_size=48G

mysql using 50gb of ram but the database is 11gb large (there is only one Database) .

Can someone tell me what mysql is doing? where are the 37gb of data comming from?

I have some heavy  select and write querys and i need fast results.

At the beginning with my mysql experiences i wanted to create a fstab ram directory and put mysql into it, but then i found the buffer pool option and i hoped it would solve my problem.

I hope someone have some ideas what to do or what i missunderstand.

 

Best regards .