Not the answer you need?
Register and ask your own question!

MySQL using

sqladminsqladmin EntrantInactive User Role Beginner
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]+
+
+
| 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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.