I've run the primer, but i would benefit from your reading of the following three points, please.
in particular the first one about the memory usage.
Many thanks,
MEMORY USAGE
Max Memory Ever Allocated : 62.17 G
Configured Max Per-thread Buffers : 178.22 G
Configured Max Global Buffers : 38.56 G
Configured Max Memory Limit : 216.78 G
Physical Memory : 47.03 G
Max memory limit exceeds 90% of physical memory
TABLE CACHE
Current table_open_cache = 1024 tables
Current table_definition_cache = 912 tables
You have a total of 669 tables
You have 1024 open tables.
Current table_cache hit rate is 0%
, while 100% of your table cache is in use
You should probably increase your table_cache
JOINS
Current join_buffer_size = 20.00 M
You have had 42247 queries where a join could not use an index properly
You have had 30012 joins without keys that check for key usage after each row
join_buffer_size >= 4 M
This is not advised
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
Hello @BMDan , Thanks for this excellent utility
I've run the primer, but i would benefit from your reading of the following three points, please. in particular the first one about the memory usage.
Many thanks,