Example Calculation
+------------------------------------------+--------------------+
| key_buffer_size | 16.000 MB |
| query_cache_size | 16.000 MB |
| innodb_buffer_pool_size | 64.000 MB |
| innodb_additional_mem_pool_size | 8.000 MB |
| innodb_log_buffer_size | 8.000 MB |
+------------------------------------------+--------------------+
| BASE MEMORY | 112.000 MB |
+------------------------------------------+--------------------+
| sort_buffer_size | 1.000 MB |
| read_buffer_size | 0.059 MB |
| read_rnd_buffer_size | 0.250 MB |
| join_buffer_size | 0.125 MB |
| thread_stack | 0.188 MB |
| binlog_cache_size | 0.031 MB |
| tmp_table_size | 8.000 MB |
+------------------------------------------+--------------------+
| MEMORY PER CONNECTION | 9.652 MB |
+------------------------------------------+--------------------+
| max_used_connections | 1 |
| max_connections | 25 |
+------------------------------------------+--------------------+
| TOTAL (MIN) | 121.652 MB |
| TOTAL (MAX) | 353.309 MB |
+------------------------------------------+--------------------+
Last active
August 11, 2022 07:42
-
-
Save mjf/9ae860ae5028df216aa1ed9e6cdfe830 to your computer and use it in GitHub Desktop.
MySQL min/max memory consumption calculation example
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment