Welcome to Centmin Mod Community
Register Now

Mysqltunner wrong memory report

Discussion in 'Bug Reports' started by pamamolf, Aug 19, 2015.

  1. pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    10:47 AM
    Nginx-1.26.x
    MariaDB 10.6.x
    Hi


    I have a server with 128GB ram and i use about 50gb of it most of the times....

    I was used mysqltunner to get an idea about my mysql and all was fine until today that i upgrade to the latest Centminmod beta as it now reports with 30gb ram for sql seems to be 2426% of installed RAM :(

    Code:
    [--] Total buffers: 30.0G global + 928.0K per thread (700 max threads)
    [!!] Maximum possible memory usage: 30.6G (2426% of installed RAM)
    Code:
    [root@server ~]# free -m
                 total       used       free     shared    buffers     cached
    Mem:        129030      14518     114511       1131         89       2450
    -/+ buffers/cache:      11978     117052
    Swap:         4095          0       4095
    Code:
    Mem:  132126804k total, 12235156k used, 119891648k free,    57204k buffers
    Swap:  4194300k total,        0k used,  4194300k free,  2422768k cached
    *Tunning primer report the correct ram.....
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,375
    12,255
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,835
    Local Time:
    5:47 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. pamamolf

    pamamolf Well-Known Member

    4,101
    428
    83
    May 31, 2014
    Ratings:
    +838
    Local Time:
    10:47 AM
    Nginx-1.26.x
    MariaDB 10.6.x
    Nope

    It is the one from:

    Code:
    https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl
    Do you have another newer custom version ?