Buy Percona ServicesBuy Now!

MySQL using

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL using

    Im using mysql 5.6.

    Config:
    • 32 CPU
    • 120GB Memory
    • 90GB innodb buffer pool
    • total DB size 30Gb

    Issue:
    In my monitoring system, mysql is using 115GB memory. But buffer pool using 28GB only.
    Im wondering that how mysql using this much without utilizing innodb_buffer_pool.

    HTML Code:
    +------------------------------------------+--------------------+
    |                          key_buffer_size |          32.000 MB |
    |                         query_cache_size |           0.000 MB |
    |                  innodb_buffer_pool_size |       92160.000 MB |
    |          innodb_additional_mem_pool_size |           8.000 MB |
    |                   innodb_log_buffer_size |           8.000 MB |
    +------------------------------------------+--------------------+
    |                              BASE MEMORY |       92208.000 MB |
    +------------------------------------------+--------------------+
    |                         sort_buffer_size |           0.250 MB |
    |                         read_buffer_size |           0.125 MB |
    |                     read_rnd_buffer_size |           0.250 MB |
    |                         join_buffer_size |           0.250 MB |
    |                             thread_stack |           0.250 MB |
    |                        binlog_cache_size |           0.031 MB |
    |                           tmp_table_size |          32.000 MB |
    +------------------------------------------+--------------------+
    |                    MEMORY PER CONNECTION |          33.156 MB |
    +------------------------------------------+--------------------+
    |                     Max_used_connections |               1806 |
    |                          max_connections |               4000 |
    +------------------------------------------+--------------------+
    |                              TOTAL (MIN) |      152088.188 MB |
    |                              TOTAL (MAX) |      224833.000 MB |
    +------------------------------------------+--------------------+

    Can someone guide me to understand where this mysql holding the most of the memory?
Working...
X