V
V
Vladimir2019-03-26 16:06:02
1C-Bitrix
Vladimir, 2019-03-26 16:06:02

How can I optimize settings to improve database performance?

Hello.
We have VDS - CPU 6 cores, 10 GB of RAM, VM 7.3. The Bitrix Business website is on the server, the average attendance is 4000 people. per day, 50 thousand goods. Data from 1C is uploaded to the site every 4 hours: balances, prices; once a week full unloading of goods (except for photos). The site is also synchronized with 1C in terms of orders - about 2000 per 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 = 2565 max_table_connections =
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
MaxRequestWorkers 50
MaxRequestsPerChild 5000
MaxClients 50
In the performance panel, the values ​​are:
MySQL database (write) 4 327
MySQL database (read) 16 562
MySQL database (change) 6 267
Tell me how you can optimize the settings to increase the speed of the database and server?
There were tips: transferring temporary database tables to the OP - did not try, use a separate memcache server - did not notice the difference with storage in files, make database replication - performance dropped

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Viktor Taran, 2019-03-26
@shambler81

you need to look at the site itself, it all depends on the amount of memory and the number of requests to the database, how the site is assembled, what gets into the smart filter, the number of categories, the data storage format in mysql
Is the exchange incremental, etc., etc.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question