MySQl Tuning

Hey all, I know this has been asked many times before but I'm still battling to find a solid solution, my server is struggling due to MySql memory usage, I'm not that clued up on SQL but I've run the tuner script and have the below results. We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found. See mysql/mysql-sys for MySQL Consider installing Sys schema from MySQL :: MySQL 8.0 Reference Manual :: 15.6.5 Redo Log Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_size (=0) query_cache_type (=0) query_cache_limit (> 1M, or use smaller result sets) join_buffer_size (> 256.0K, or always use indexes with JOINs) tmp_table_size (> 16M) max_heap_table_size (> 16M) table_definition_cache(400) > 70384 or -1 (autosizing if supported) performance_schema = ON enable PFS innodb_buffer_pool_size (>= 4.1G) if possible. innodb_log_file_size should be (=16M) if possible, so InnoDB total log files size equals to 25% of buffer pool size. Server spec is 26 core with 48GB Ram. If anyone could please help as I would be super grateful.