this is my first post, so please tell me if i do something wrong.
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 .