0

I have Ubuntu 16.0 dedicated server with 16GB of RAM find my cpu details:

# lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 4
On-line CPU(s) list: 0-7
Thread(s) per core: 2
Core(s) per socket: 4
Socket(s): 1
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 58
Model name: Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
Stepping: 9
CPU MHz: 1712.218
BogoMIPS: 6799.29
Virtualization: VT-x
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 8192K
NUMA node0 CPU(s): 0-7

Below is my my.cnf file configuration:

[mysqld]
default-storage-engine=InnoDB
performance-schema=0
max_allowed_packet=268435456
join_buffer_size = 4M
explicit_defaults_for_timestamp = 1
read_rnd_buffer_size=512K
read_buffer_size=1M
sort_buffer_size=2M
table_open_cache=5000
key_buffer_size=1G

innodb_buffer_pool_size=20G
innodb_buffer_pool_instances = 24
innodb_log_file_size=512M
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_autoinc_lock_mode=0

Top command output:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
49601 mysql 20 0 15.063g 5.170g 8548 S 44.9 29.6 38:09.97 /usr/sbi+
19 root 20 0 0 0 0 S 0.3 0.0 0:28.69 [rcuos/1]
479 root 0 -20 0 0 0 S 0.3 0.0 0:18.83 [kworker+
547 root 20 0 0 0 0 D 0.3 0.0 0:09.59 [jbd2/md+
3237 root 30 10 417280 26672 1436 S 0.3 0.1 0:36.46 /opt/alt+
86892 nobody 20 0 215212 23564 2724 S 0.3 0.1 0:00.02 /usr/sbi+
1 root 20 0 191148 4180 2412 S 0.0 0.0 0:07.12 /usr/lib+
2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 [kthread+

please help me to improve mysql server performance.