search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.18k stars 323 forks source link

EXPLAIN EXTENDED is going to disappear #1984

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 1984 created by webyog on 2013-10-25T11:47:16.000Z:

http://www.tocker.ca/2013/10/23/explain-partitions-and-explain-extended-deprecation.html

.. according to this it will be deprecated in MySQL 5.7 and disappear in 5.8.

We should explore the JSON option for EXPLAIN for use in Query Profiler.

atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2013-11-22T20:17:49.000Z:

Per the post, the flag will disappear, but the function will be enabled by default.

Using FORMAT=JSON is a good idea though.

atulwy commented 9 years ago

Comment #2 originally posted by webyog on 2014-07-03T09:36:39.000Z:

Also keep a watch on MariaDB ANALYZE as an option for the Query Profiler. http://s.petrunia.net/blog/?p=96