Since we upgraded Magento to 2.4.5-P1 and moved to MariaDB 10.4 (now 10.4.28) and PHP 8.1, we are facing really slow saving of products in admin. Everything else is fast, like the frontend, and working in the admin area. This is only related to saving products.
This worked flawless before, and we haven't made any other changes at all to the server or the software, like adding new extensions.
We have enabled SQL slow log, but that ain't giving us any clues, nothing is logged when saving.
Any help on this would be greatly appreciated.
I think this issue has something to do with MariaDB 10.4.28, and/or PHP 8.1, as nothing else has changed on the server. Either i misconfiguration of MariaDB, or an extension incompatible with PHP 8.1.
This is my current MariaDB 10.4.28 configuration, tuned with mysqltuner:
[server] binlog_cache_size = 16M expire_logs_days = 30 open_files_limit = 32768 table_open_cache = 64M table_definition_cache = 8192 net_retry_count = 16384 key_buffer_size = 6M max_allowed_packet = 64M max_heap_table_size = 768M tmp_table_size = 196M query_cache_type = 0 query_cache_size = 0 long_query_time = 0.5 innodb_buffer_pool_size = 512M innodb_log_file_size = 64M innodb_log_buffer_size = 16M innodb_write_io_threads = 8 innodb_read_io_threads = 8 innodb_autoinc_lock_mode = 2 innodb_buffer_pool_instances = 2 optimizer_switch = "rowid_filter=off" optimizer_use_condition_selectivity = 1 join_buffer_size = 2M performance_schema = ON