As I always say… a database connection can be called a thread, session, connection, etc. Everyone names it however they like. Never, ever argue with the DBA!
Scenario: A query is running on MySQL. It’s draining your patience, in addition to I/O, memory, CPU resources, etc. Before giving it a basic Kill, you’d really (really) like to know what the hell that query is doing.
A true DBA uses the black screen. In the terminal, you’d have to run a SHOW FULL PROCESSLIST, pray that the query fits within the character limit, cut it, and paste it after an EXPLAIN command.
No more, dear padawan. Now, with all this modernity, we have the EXPLAIN CONNECTION command. Ohhhh!
OK, it’s nothing groundbreaking. It won’t get you a 20% salary increase, but for those who live neck-deep in poorly written queries, this little command took its time, but is very welcome.
Visit our Blog
Learn more about databases
Learn about monitoring with advanced tools
Have questions about our services? Visit our FAQ
Want to see how we’ve helped other companies? Check out what our clients say in these testimonials!
Discover the History of HTI Tecnologia
