What configuration is required for a magento2 website with 100,000 SKUs?

WBOY
Release: 2016-09-05 08:59:53
Original
1564 people have browsed it

A magento2 website with 100,000 SKUs, what kind of server is needed?
Currently 8G memory 4 cores

Also what configuration is required for php.ini

How to configure mysql,my.cnf

I saw some references online as follows, and I want to know how to adjust these parameters.
mysql
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
thread_concurrency = 12
thread_cache_size = 32
table_cache = 1024
query_cache_size = 64M
query_cache_limit = 2M
join_buffer_size = 8M
tmp_table_size = 256M
key_buffer = 32M
innodb_autoextend_increment=512
max_allowed_packet = 16M
max_heap_table_size = 256M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 1G
myisam_max_extra_sort _file_size = 1G
myisam_repair_threads = 1

PHP configuration
realpath_cache_size = 32k
realpath_cache_ttl = 7200
max_execution_time = 90
max_input_time = 90
memory_limit = 256M
default_socket_timeout = 90
pdo_mysql.cache_size = 2 000
output_buffering = 4096

Reply content:

A magento2 website with 100,000 SKUs, what kind of server is needed?
Currently 8G memory 4 cores

Also what configuration is required for php.ini

How to configure mysql,my.cnf

I saw some references online as follows, and I want to know how to adjust these parameters.
mysql
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
thread_concurrency = 12
thread_cache_size = 32
table_cache = 1024
query_cache_size = 64M
query_cache_limit = 2M
join_buffer_size = 8M
tmp_table_size = 256M
key_buffer = 32M
innodb_autoextend_increment=512
max_allowed_packet = 16M
max_heap_table_size = 256M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 1G
myisam_max_extra_sort _file_size = 1G
myisam_repair_threads = 1

PHP configuration
realpath_cache_size = 32k
realpath_cache_ttl = 7200
max_execution_time = 90
max_input_time = 90
memory_limit = 256M
default_socket_timeout = 90
pdo_mysql.cache_size = 2 000
output_buffering = 4096

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template