Im using mysql 5.6.
Config:
[LIST]
[]32 CPU
[]120GB Memory
[]90GB innodb buffer pool
[]total DB size 30Gb
[/LIST]
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]±-----------------------------------------±-------------------+
| 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 |
±-----------------------------------------±-------------------+[/HTML]
Can someone guide me to understand where this mysql holding the most of the memory?