5 posts tagged with "Mysql"

While checking the Magento log files of a Magento instance we recently migrated, I came across the following MySQL warning:

Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size 
or decrease batch size value (which decreases memory usages for the temporary table). 
Current batch size: 417; Allocated memory size: 40032000 bytes; InnoDB buffer pool size: 134217728 bytes.

In a recent Magento upgrade project for one of our merchants, I encountered a problem with the production database during the setup:upgrade process.

As part of an AI project, I had to export data to train a tool developed for a customer. Instead of writing a script, I decided to use MySQL's built-in functions, which turned out to be a challenging experience but a valuable learning opportunity.

Importing larger database dumps can take a while, especially when foreign key checks are enabled. This slowdown happens because each foreign key reference must be verified by the database server.

While migrating a Magento module to make use of the declarative db schema, I ran into the following MySQL error: MySQL error code 121: Duplicate key on write or update