I have a webstore with over 400k products that were migrated from m1. Any product that is either saved or deleted takes approximately 25 - 30 seconds per product.
I have done every performance tuning on the server i can with mysql config, php config and the problem appears to be related with magento 2.3.3.
I have also disable any modules that arent in use - so i am at a loss on where to look or how to begin to figure this out.
[mysqld] sql_mode="" local-infile=0 max_connections = 600 max_user_connections=1000 key_buffer_size = 2048M myisam_sort_buffer_size = 64M read_buffer_size = 1M table_open_cache = 5000 thread_cache_size = 384 wait_timeout = 120 connect_timeout = 60 tmp_table_size = 256M max_heap_table_size = 128M max_allowed_packet = 1024M net_buffer_length = 16384 max_connect_errors = 100 concurrent_insert = 2 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 256M query_cache_size = 512M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65535 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 8 external-locking=FALSE open_files_limit=5000000 innodb_thread_concurrency = 0 innodb_lock_wait_timeout = 7200 innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 2 innodb_log_files_in_group = 2 innodb_file_per_table = 1 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_buffer_pool_instances = 4 innodb_buffer_pool_size = 22G
What are the proper troubleshooting steps to take to pin down the bottle neck?
Any suggestions on Magento settings or tweaks to speed up the save or delete process?