MySQL
MySQL for Magento — query optimization, database tuning, index management, and database administration best practices.
-
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
