Monitor server execution. Profiling queries.
--- 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;
+