How can I optimize the settings to improve the performance of database?

Hello.
Have the VDS - CPU 6 cores, 10 GB operatives, VMS 7.3. Server is site Bitrix business, the average attendance of 4000 per day, 50 thousand products On the website every 4 hours are filled with the data from 1C: balances, rates; once a week the full unloading of goods (except photos). The website is synchronized with 1C of part of orders of around 2000 a day.
DB Percona-Server-server 5.7.22. All tables in InnoDB.

Configuration files:
1. /etc/mysql/conf.d/z_bx_custom.cnf
[mysqld]
query_cache_type = 1
query_cache_size = 128M
query_cache_limit = 16M

innodb_buffer_pool_size = 4096M
innodb_flush_log_at_trx_commit=0
innodb_lru_scan_depth = 256

max_connections = 45
table_open_cache = 4048
thread_cache_size = 30
max_heap_table_size = 128M
tmp_table_size = 128M
key_buffer_size = 24M
join_buffer_size = 4M
sort_buffer_size = 4M
bulk_insert_buffer_size = 2M
myisam_sort_buffer_size = 4M

2. /etc/httpd/bx/conf/zprefork.conf

StartServers 25
MinSpareServers 25
MaxSpareServers 25
50 MaxRequestWorkers
MaxRequestsPerChild 5000
MaxClients 50


Panel performance values:
MySQL database(recording) 4 327
MySQL database(read) 16 562
MySQL database(change) 6 267

Prompt as it is possible to optimize the settings to improve the performance of the DB and server?
Was advice: move temporary DB tables in OP - do not try to use a separate memcache server - difference stored in the files are not noticed, to make a replication DB performance fell
March 19th 20 at 08:40
1 answer
March 19th 20 at 08:42
you need to look at the site itself, all depends on the amount of memory and number of queries to the database, as assembled site that gets to the smart filter, the number of categories, the format of storage of data in mysql
If incremental exchange, etc

Find more questions by tags 1C-Bitrix