Every software developer is struggling to fix slow MySQL queries. You are not alone in this.
But you can just visually see what a MySQL query is doing instead of trying to learn the incomprehensible EXPLAIN output.
Hey 👋
I was always confused when trying to optimize a slow MySQL query as the output of the EXPLAIN command is so cryptic and totally useless. And there wasn't any tool that could help visualize what a query does - compared to PostgreSQL which has multiple...
So, I started developing such a tool for MySQL. But boy, I didn't expect how complicated this is in reality. There were so many things hiding in tiny information pieces that I had to learn. But it also confirmed me in that a tool should try to understand the EXPLAIN output and not a human as it is too easy to oversee something.
After months of work, I've now finished the first iteration of my vision. Whats your opinion about it?
What @tpetry has done with MySQL Visual Explain is nothing short of a game-changer. Turning something as complex and frustrating as query optimization into a tool I actually enjoy using is impressive! We've relied on Visual Explain countless times while revamping core parts of our application, and it's transformed the process of pinpointing slow queries into an engaging, actionable experience.
MySQL Visual Explain is a super useful tool! We use it quite often for complex mysql performance optimization tasks. Highly recommend this tool! Tobias really created a little gem here!
Replies
Next-Level Database Techniques For Devs
Laravel
Next-Level Database Techniques For Devs
SimpleStats