A magento2 website has 0.1 million SKU. what kind of server needs? 8 GB memory, 4 cores, and php. how to configure mysql, my. for details about how to configure cnf, see the following. Mysqlinnodb_thread_concurrency... what kind of server is required for a magento2 website 0.1 million SKU?
8 GB memory 4 cores
What are the configurations required for php. ini?
How to configure mysql and my. cnf?
See some references on the internet 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 = 64 M
Query_cache_limit = 2 M
Join_buffer_size = 8 M
Tmp_table_size = 256 M
Key_buffer = 32 M
Innodb_autoextend_increment = 512
Max_allowed_packet = 16 M
Max_heap_table_size = 256 M
Read_buffer_size = 2 M
Read_rnd_buffer_size = 16 M
Bulk_insert_buffer_size = 64 M
Myisam_sort_buffer_size = 128 M
Myisam_max_sort_file_size = 1G
Myisam_max_extra_sort_file_size = 1G
Myisam_repair_threads = 1
PHP configuration
Realpath_cache_size = 32 k
Realpath_cache_ttl = 7200
Max_execution_time = 90
Max_input_time = 90
Memory_limit = 256 M
Default_socket_timeout = 90
Pdo_mysql.cache_size = 2000
Output_buffering = 4096
Reply content:
What kind of server is required for a magento2 website 0.1 million SKU?
8 GB memory 4 cores
What are the configurations required for php. ini?
How to configure mysql and my. cnf?
See some references on the internet 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 = 64 M
Query_cache_limit = 2 M
Join_buffer_size = 8 M
Tmp_table_size = 256 M
Key_buffer = 32 M
Innodb_autoextend_increment = 512
Max_allowed_packet = 16 M
Max_heap_table_size = 256 M
Read_buffer_size = 2 M
Read_rnd_buffer_size = 16 M
Bulk_insert_buffer_size = 64 M
Myisam_sort_buffer_size = 128 M
Myisam_max_sort_file_size = 1G
Myisam_max_extra_sort_file_size = 1G
Myisam_repair_threads = 1
PHP configuration
Realpath_cache_size = 32 k
Realpath_cache_ttl = 7200
Max_execution_time = 90
Max_input_time = 90
Memory_limit = 256 M
Default_socket_timeout = 90
Pdo_mysql.cache_size = 2000
Output_buffering = 4096