Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

MySQL query analyzer

Tags:

mysql

Is there a tool to analyze query more thoroughly than EXPLAIN allows? Something like SQL Server Management Studio.

like image

520

asked Apr 08 '11 13:04

synapse

2 Answers

JetProfiler has a good GUI for explaining queries, and letting you tweak the query in real time.

like image

142

answered Oct 14 '22 00:10

Tony Gutierrez

sqlyog is a best gui tool for query. And there is Query Profiler which gives these informations when you execute a query:

Explain result.
Explain Extended.
Change Of Status Variables Due ToExecution Of Query.
SHOW PROFILE Result.

enter image description here

like image

20

answered Oct 14 '22 00:10

Jignesh

Sign in to Comment

Related questions
                            
                                Java 8 + Hibernate 5 MySQL TIMESTAMP/DATETIME to LocalDateTime Mapping
                            
                                Sql syntax: select without from clause as subquery in select (subselect)
                            
                                get rows based on expiry time
                            
                                When to use strict mode in MySql or MariaDB
                            
                                Composite key with manual increment
                            
                                MySQL hangs on ALTER TABLE
                            
                                Ecto query and custom MySQL function with variable arity
                            
                                How to escape things within zend literal?
                            
                                RMySQL system error: 10060
                            
                                Doctrine insert many data
                            
                                How do I escape % in Knex where like query?
                            
                                WordPress Error establishing a MySQL database connection IIS10 [duplicate]
                            
                                Using variables as OFFSET in SELECT statments inside mysql's stored functions
                            
                                jdbc4 CommunicationsException
                            
                                Matching a value to multiple columns (in one statement) from a table using MySQL
                            
                                Getting python MySQLdb to run on Ubuntu
                            
                                Scalability of Using MySQL as a Key/Value Database
                            
                                Overloading a Native PHP Function to Encrypt Data for HIPAA Compliance
                            
                                MySQL stored procedure fails when called from R
                            
                                Does number of columns affect MYSQL speed?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With