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