Jump to content

Clericer

New Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Clericer

  • Rank
    Newbie
  1. 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 .
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.