Super Fast Magento 2.4.6 is terrible slow when saving products (only)

[Alldo Group]

Hello,

We have a blazing fast Magento store, but since moving over from MySQL to MariaDB, it takes several minutes to save a product.

Server Software Versions

Magento 2.4.6
PHP 8.1.18
MariaDB 10.6.12 LTS
Redis 7.0.10

We have added the suggested MariaDB config to conf.d/server.cnf:

optimizer_switch = "rowid_filter=off"
optimizer_use_condition_selectivity = 1

None of this helps, and we are stuck.
Any thougths on this would be more that appreciated.

Thank you,
Kind regards,

[johnwebdes40a5]

Hello @Alldo Group 

If your Magento store was previously fast and responsive but became slow after moving from MySQL to MariaDB, it's possible that the database migration did not go as smoothly as expected. Here are a few things you can try to troubleshoot and optimize your MariaDB configuration:

• Check your MariaDB configuration:
  • Please make sure that your MariaDB configuration is optimized for Magento. You can check the MariaDB configuration file (usually my.cnf or my.ini) to see if it matches the recommended settings for Magento.
• Check your MariaDB version:
  • Please make sure that you are using the latest stable version of MariaDB. Older versions of MariaDB may have performance issues or bugs that have been fixed in newer versions.
• Check your database structure:
  • Please check that the structure of your database tables is correct and optimized. You can use tools like phpMyAdmin or Adminer to analyze and optimize your database structure.
• Check your indexing:
  • Please check that your Magento store is properly indexing its database. Run the indexer tool to make sure that your indexes are up-to-date and optimized.
• Check for conflicting extensions:
  • If you have recently installed or updated any extensions, they may be causing conflicts with your MariaDB database. Disable or uninstall any extensions that may be causing issues and test the performance again.
• Check for network issues:
  • Please check that your network and server are configured correctly. Slow network or server response times can cause performance issues with your database.
• Optimize your database queries:
  • Please analyze your Magento store's database queries and optimize them for MariaDB. Use tools like Query Monitor or New Relic to analyze your queries and optimize them for MariaDB.

If you find our reply helpful, please give us kudos.

A Leading Magento Development Agency That Delivers Powerful Results, Innovation, and Secure Digital Transformation.

WebDesk Solution Support Team

Get a Free Quote | | Adobe Commerce Partner | Hire Us | Call Us 877.536.3789

[Alldo Group]

Thank you for your answer,

We have checked all these tips, except the one that it might be a extension that doesn't like the new Maria DB.

Here are our current configuration:

[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