MySQL
MySQL for Magento — query optimization, database tuning, index management, and database administration best practices.
-
https://github.com/TonyMerlin/m2-module-asynchronous-operations-fix
Adds an around plugin to make bulk acknowledgement idempotent using insertOnDuplicate, preventing duplicate-key errors when dismissing completed asynchronous operation notifications in Admin. Includes installation and verification steps.
-
https://github.com/justbetter/magento2-optimizeflattable
Scans varchar product attributes used in flat tables and sets column lengths based on actual data instead of 255, preventing MySQL 1118 indexing failures.
43 -
https://gist.github.com/rhoerr/a55285c9cabad6b87d592d5db7589262
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}".
-
https://github.com/henriquekieckbusch/sql_bin_magento
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.
15 -
https://github.com/EcomDev/mysql-to-jsonl
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!
229