mysql optimization. What mysqltuner recommendations should be applied?

Question

MySQL

Good afternoon.
The project is located on a VPS (10 GB RAM, 2 CPU core, 65 GB SSD).
Installed mysqltuner and got recommendations for setting up mysql.
I want to clarify which of these recommendations need to be applied to obtain performance.
And what values ​​to put mysql parameters.
Current MySQL settings

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld_safe]
log-error=/var/log/mysql.log
pid-file = /var/run/mysqld/mysqld.pid
socket = / var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
local-infile=0
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
log-error = /var/log/mysql/error.log
# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
innodb-buffer-pool-instances = 2
innodb-buffer-pool-size = 2361393152
innodb-flush-log-at-trx-commit = 2
innodb-log-file-size = 524288000
innodb-thread-sleep-delay = 0
join-buffer-size = 8388608
max-connections = 100
max-heap-table-size = 268435456
query-cache-limit = 2097152
query-cache-size = 67108864
query-cache-type = ON
skip-name-resolve = TRUE
sort-buffer-size = 8388608
symbolic-links = FALSE
tmp -table-size=268435456

Mysql tuner recommendations

>> MySQLTuner 1.3.0 - Major Hayden
>> Bug reports, feature requests, and downloads at mysqltuner.com
>> Run with '--help' for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.
[OK] Currently running supported MySQL version 5.6.35
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics ------------------- -----------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in InnoDB tables : 2G (Tables: 326)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[--] Data in MyISAM tables: 46M (Tables: 5)
[!!] Total fragmented tables: 20
-------- Security Recommendations ---------------------------------------- ---
[OK] All database users have passwords assigned
-------- Performance Metrics ---------------------------- ----------------------
[--] Up for: 39d 21h 6m 2s (587M q [170.642 qps], 16M conn, TX: 1078B, RX: 358B )
[--] Reads / Writes: 75% / 25%
[--] Total buffers: 2.5G global + 16.6M per thread (100 max threads)
[OK] Maximum possible memory usage: 4.2G (41% of installed RAM )
[OK] Slow queries: 0% (1K/587M)
[OK] Highest usage of available connections: 40% (40/100)
[OK] Key buffer size / total MyISAM indexes: 8.0M/32.6M
[OK] Key buffer hit rate: 99.5% (136M cached / 677K reads)
[OK] Query cache efficiency: 81.7% (395M cached / 484M selects)
[!!] Query cache prunes per day: 1080995
[OK] Sorts requiring temporary tables: 0% (473 temp sorts / 27M sorts)
[!!] Joins performed without indexes: 22423559
[!!] Temporary tables created on disk: 33% (8M on disk / 25M total)
[OK] Thread cache hit rate: 99% (158K created / 16M connections)
[OK] Table cache hit rate: 79% (985 open / 1K opened)
[OK] Open file limit used: 0% (62/16K)
[OK] Table locks acquired immediately: 99% (390M immediate / 390M locks)
[OK] InnoDB buffer pool / data size : 2.2G/2.2G
[!!] InnoDB log waits: 5
-------- Recommendations -------------------------- ----------------------------
General recommendations: Run OPTIMIZE TABLE to defragment
tables for better performance
Adjust your join queries to always utilize indexes
Temporary table size is already large - reduce result set size > 8.0M, or always use indexes with joins) innodb_log_buffer_size (>= 8M)

Answer 1

Actually, here you are no longer concerned with muscle settings, but with the organization of the data of the database itself and your requests!
one)

!!] Joins performed without indexes: 22423559

This tells you that you have join queries where indexes don't work. Create the necessary indexes and there will be happiness.
2)

Reduce your SELECT DISTINCT queries without LIMIT clauses

Don't forget to include LIMIT in queries, especially when doing DISTINCT.
3) well, reduce the size of temporary tables, or queries that create them.

Answer 2

innodb_log_buffer_size
query_cache_size can be disabled altogether because % of records is large (depending on the situation)
join_buffer_size is better not to increase