This guide details how to reset a message queue that becomes stuck due to issues like crashes or deadlocks. It provides necessary SQL queries and tips for safely backing up your database before performing a potentially destructive operation. Understanding the causes of stuck queues and the proper steps to reset them is essential for maintaining performance.
29 Jul 2025
These queries/views aggregate all EAV values for each entity into a JSON column (eav_int, eav_text, etc) for easier debugging. For scoped entities, any scope values will be appended as "{attribute_code}:{store_id}"="{value}".
Mohamed Tawfik published a full Magento 2 Database Documentation portal to make life easier when dealing with complex table structures and relationships.
05 May 2025
To execute Magento 2 CLI-like commands directly in your MySQL database without needing PHP or the Magento application layer. The result? Lightning-fast command execution and direct database insights.
The mysql2jsonl tool provides an efficient way to export data from a MySQL database to JSONL (JSON Lines) files and to import data back into a database from these files. It is highly configurable and optimized for performance with concurrency and batching in mind!
You can use INSERT IGNORE INTO mysql query with the help of insertFromSelect() method in Magento 2 with use of magento best standard in your module.
This Magento 2 script by AquiveMedia automates importing databases from remote servers via SSH with configurable environment settings. It supports table exclusions and compression, making it ideal for efficient, tailored migrations.