# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1451431237 -7200
# Node ID 84707c692266db9a649a8638b8496011f61b18e3
# Parent  a3b639d803e7bb3f1a5360890c1f48bf682ac6bc
Monitor server execution. Profiling queries.

diff -r a3b639d803e7 -r 84707c692266 mysql.rst
--- a/mysql.rst	Tue Dec 29 22:38:28 2015 +0200
+++ b/mysql.rst	Wed Dec 30 01:20:37 2015 +0200
@@ -63,8 +63,8 @@
 
   [mysql]> SHOW VARIABLES LIKE "%version%";
 
-Debugging.
-==========
+Debugging queries error.
+========================
 
 After error or warning run::
 
@@ -72,3 +72,26 @@
   MariaDB [mysql]> SHOW ERRORS;
   MariaDB [mysql]> show engine innodb status;
 
+Monitor server execution.
+=========================
+::
+
+  MariaDB [mysql]> SHOW PROCESSLIST;
+
+Profiling queries.
+==================
+
+Enable profiling, execute query and review profiling data::
+
+  [mysql]> set profiling=1;
+  [mysql]> select 1;
+  [mysql]> show profile;
+
+Each profiled query results stored separately. To get list of results::
+
+  [mysql]> show profiles;
+
+To retrieve selected profiling data::
+
+  [mysql]> show profile for query 1;
+