Skip to content

False Calculation of Total RAM Usage #864

@dcz010

Description

@dcz010

Hi,

I found an error in the RAM calculation of the tuner script.
In the calculation of the memory per thread the "tmp_table_size" is missing so the calc is incorrect.
I'm using the MariaDB defaults and only changed the tmp_table_size from 16M to 32M.
So the bolt marked can not be correct because im sometime always producing OOM with mariadbd.

-------- Performance Metrics -----------------------------------------------------------------------
ℹ Up for: 5d 3h 18m 18s (168M q [378.922 qps], 15M conn, TX: 208G, RX: 29G)
ℹ Reads / Writes: 82% / 18%
ℹ Binary logging is disabled
ℹ Physical Memory : 72.0G
ℹ Max MySQL memory : 59.2G
ℹ Other process memory: 0B
ℹ Total buffers: 55.0G global + 2.9M per thread (1250 max threads)
ℹ Performance_schema Max memory usage: 631M
ℹ Galera GCache Max memory usage: 3G
✔ Maximum reached memory usage: 56.4G (78.29% of installed RAM)
✔ Maximum possible memory usage: 59.2G (82.28% of installed RAM)
✔ Overall possible memory usage with other process is compatible with memory available

Regards
dcz010

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions