mysql 8 virt usage too high

oah

• November 07, 2023 16:52

Hi I have the following in my server: As you can see myql is hugging 40 Gigs in VIRT and 6 Gigs in RES. and free -mh shows this: so why is mysql using around 40 Gigs in VIRT? while in RES it is showing only 6 Gigs? how can I bring it down? I am using the settings below: I have a single database on the server of size 20 gigs with the following table and index sizes: First of all, is it normal to have that value for mysql (the 40 Gigs), if not, what might be causing it? how to proceed, any ideas, suggestions are welcome. Mike.

• 

  cPRex Jurassic Moderator

  • November 08, 2023 03:41

  Hey there! Thanks for including details output of all these areas - I wish all posts were like this :D The good news, is that there likely isn't anything wrong with the server. We can see that you really aren't "using" those 40G of RAM as they are listed as available. What is most likely happening is that the large 20G table is taking up some address space on the system, but if needed the server would be able to stop that work and use the memory for something else, hence the available 43G. There are more details about how this works in the following post:

  0
• 

  oah

  • November 08, 2023 10:47

  Hey there! Thanks for including details output of all these areas - I wish all posts were like this :D The good news, is that there likely isn't anything wrong with the server. We can see that you really aren't "using" those 40G of RAM as they are listed as available. What is most likely happening is that the large 20G table is taking up some address space on the system, but if needed the server would be able to stop that work and use the memory for something else, hence the available 43G. There are more details about how this works in the following post:

  0
• 

  cPRex Jurassic Moderator

  • November 08, 2023 12:58

  You're welcome!

  0

Please sign in to leave a comment.