Mysql optimization suggestions?

[Larkolag]

friends hello, cpanel I made mysql optimizations for my centos server, but the usage of ram increased too much what could be the reason I'm writing the server properties below.
Ram: 11867 MB
cpu: 8
Disk:215GB Sas
Os: Cloudlinux
The contents of my.cnf file are as follows. what should i do to reduce ram usage. when I use this my.cnf the ram usage is 98% how can i solve this problem?
Can you help me to organize the best optimized setup file for my server?

[mysqld]
performance_schema=on
skip-networking
innodb_file_per_table=1
tmpdir=/tmp
max_connections=500
max_user_connections=500
key_buffer_size=1024M
myisam_sort_buffer_size=512M
join_buffer_size=8M
read_buffer_size=8M
sort_buffer_size=8M
table_open_cache=1024M
thread_cache_size=512M
table_definition_cache=3072
open_files_limit=64000
wait_timeout=300
connect_timeout=300
tmp_table_size=512M
read_rnd_buffer_size=786432
max_heap_table_size=512M
max_allowed_packet=512M
max_seeks_for_key=1000
max_write_lock_count=4
net_buffer_length=16384
group_concat_max_len=1024M
transaction_alloc_block_size=2048
transaction_prealloc_size=1024
range_alloc_block_size=1024
query_prealloc_size=262144
query_alloc_block_size=65536
query_cache_limit=30M
query_cache_size=256M
query_cache_type=1
interactive_timeout=300
max_connect_errors=15
local-infile=0
thread_concurrency=16
query-cache-type=1
long_query_time=5
port=3306
concurrent_insert=2
max_length_for_sort_data=1024
local-infile=0
thread_concurrency=16
long_query_time=5
bulk_insert_buffer_size=8M
port=3306
concurrent_insert=2
innodb_buffer_pool_size=512M
innodb_additional_mem_pool_size=128M
innodb_thread_concurrency=4
innodb_log_file_size=128M
innodb_log_buffer_size=10M
innodb_flush_method=O_DIRECT
socket="/var/lib/mysql/mysql.sock"
default-storage-engine=MyISAM

[isamchk]
key_buffer=512M
sort_buffer_size=4M
read_buffer=4M
write_buffer=4M

[myisamchk]
tmpdir=/tmp
key_buffer=512M
sort_buffer=4M
read_buffer=4M
write_buffer=4M
sort_buffer_size=512M
write_buffer_size=256M
key_buffer_size=512M
ft_min_word_len=3
read_buffer_size=128M

[mysqldump]
max_allowed_packet=512M
quick

[client]
port=3306
socket="/var/lib/mysql/mysql.sock"

bind-address=127.0.0.1

 

[cPanelMichael]

Hello,

The following thread is a good place to start when attempting to tune your MySQL configuration:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.