How can I optimize the settings to improve the performance of database?
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.
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
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