Join the community today
Register Now

Mysqltunner wrong memory report

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

  1. pamamolf

    pamamolf Premium Member Premium Member

    3,160
    304
    83
    May 31, 2014
    Ratings:
    +548
    Local Time:
    4:03 AM
    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:
    [[email protected] ~]# 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

    37,726
    8,257
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,713
    Local Time:
    12:03 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  3. pamamolf

    pamamolf Premium Member Premium Member

    3,160
    304
    83
    May 31, 2014
    Ratings:
    +548
    Local Time:
    4:03 AM
    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 ?
     
..