Dump execution plan for selected process.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Wed, 30 Dec 2015 11:40:18 +0200
changeset 1853 c6be6cc87df4
parent 1852 f572f646694b
child 1854 9b224b68c1e1
Dump execution plan for selected process.
mysql.rst
--- a/mysql.rst	Wed Dec 30 11:34:19 2015 +0200
+++ b/mysql.rst	Wed Dec 30 11:40:18 2015 +0200
@@ -87,6 +87,19 @@
 
   MariaDB [mysql]> show explain for 1;
 
+.. NOTE::
+   You shoud check for code ``1003``::
+
+     MariaDB [mysql]> show warnings;
+
+   to ensure for which query plan shown becase query may finished and new
+   started.
+
+See:
+
+ * `SHOW EXPLAIN in MariaDB 10.0 vs EXPLAIN FOR CONNECTION in MySQL 5.7
+   <http://s.petrunia.net/blog/?p=89>`_
+
 Profiling queries.
 ==================