gh-ost (★ 4,403) - is a triggerless online schema migration solution for MySQL. It is testable and provides pausability, dynamic control/reconfiguration, auditing, and many operational perks. Created by GitHub's team.
#migration #schema #mysql
#migration #schema #mysql
SQL Explain Plan Visualizer by Datadog.
This is a very useful tool for analysing your SQL query performance and identifying bottlenecks. Simply call the command for your SQL database, like this:
The console will then generate a detailed JSON report. Copy this report and paste it into the visualiser to explore your query’s weaknesses.
#sql #report #analyse #postgresdb #mysql
This is a very useful tool for analysing your SQL query performance and identifying bottlenecks. Simply call the command for your SQL database, like this:
EXPLAIN (ANALYSE, FORMAT JSON, VERBOSE, BUFFERS) [your query]The console will then generate a detailed JSON report. Copy this report and paste it into the visualiser to explore your query’s weaknesses.
#sql #report #analyse #postgresdb #mysql
👍2