Discover Centmin Mod today
Register Now

Mysqltunner wrong memory report

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

  1. pamamolf

    pamamolf Well-Known Member

    2,819
    251
    83
    May 31, 2014
    Ratings:
    +445
    Local Time:
    11:48 PM
    Nginx-1.13.x
    MariaDB 10.1.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

    30,902
    6,908
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,404
    Local Time:
    7:48 AM
    Nginx 1.13.x
    MariaDB 5.5
  3. pamamolf

    pamamolf Well-Known Member

    2,819
    251
    83
    May 31, 2014
    Ratings:
    +445
    Local Time:
    11:48 PM
    Nginx-1.13.x
    MariaDB 10.1.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 ?