What configuration does the Magento2 website 100,000 SKU require?

Source: Internet
Author: User
Tags what php magento2
A MAGENTO2 website 100,000 sku, what kind of server is needed
Current 8G Memory 4 cores

And what php.ini needs to be configured.

MySQL, how my.cnf needs to be configured

See some references on the internet below, and 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 = 2000
Output_buffering = 4096

Reply content:

A MAGENTO2 website 100,000 sku, what kind of server is needed
Current 8G Memory 4 cores

And what php.ini needs to be configured.

MySQL, how my.cnf needs to be configured

See some references on the internet below, and 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 = 2000
Output_buffering = 4096

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.