Configure My.cnf , very slow and high cpu 100%

[Sandro Seccia]

Hello , Can you help me to configure the my database mysql ?
The database is very slow

Also the CPU is to high!




Ubuntu 15.10 64bit
RAM 65GB
CPU: 12 Core

---------------------------------------

# The MySQL server
[mysqld]
user = nobody
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-external-locking
max_allowed_packet = 1073741824M
table_cache = 64
net_buffer_length = 8K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

max_connections = 500
key_buffer = 4096M
join_buffer_size = 256M
read_buffer_size = 32M
sort_buffer_size = 32M
thread_concurrency= 22
thread_cache_size = 572
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2

wait_timeout = 28800
connect_timeout = 1000
interactive_timeout = 10

query_cache_limit = 1M
query_cache_size = 1024M
query_cache_type = 1

#tmp_table_size = 1024M
#max_heap_table_size= 1024M

---------------------------------------


Thank you very much
bye bye
Sandro.