db load averages explained (#256)
* db load averages explained
* Update source/adminguide/tuning.rst
Co-authored-by: sureshanaparti <12028987+sureshanaparti@users.noreply.github.com>
* Update source/adminguide/tuning.rst
Co-authored-by: sureshanaparti <12028987+sureshanaparti@users.noreply.github.com>
* show picture?
* default retation changed
It is now three instead of ten interations retained
* display new texts
* Apply suggestions from code review
Co-authored-by: Nicolas Vazquez <nicovazquez90@gmail.com>
Co-authored-by: Daan Hoogland <dahn@onecht.net>
Co-authored-by: sureshanaparti <12028987+sureshanaparti@users.noreply.github.com>
Co-authored-by: Nicolas Vazquez <nicovazquez90@gmail.com>
diff --git a/source/_static/images/dbLoadAverages.png b/source/_static/images/dbLoadAverages.png
new file mode 100644
index 0000000..4a0c62e
--- /dev/null
+++ b/source/_static/images/dbLoadAverages.png
Binary files differ
diff --git a/source/adminguide/tuning.rst b/source/adminguide/tuning.rst
index 75b0954..cee12d5 100644
--- a/source/adminguide/tuning.rst
+++ b/source/adminguide/tuning.rst
@@ -91,6 +91,26 @@
Manual <http://dev.mysql.com/doc/refman/5.5/en/innodb-buffer-pool.html>`_.
+Monitor the Database Load
+-------------------------
+
+The load of the database is monitored. By default the queries for each
+minute are calculated in queries per second. Three values are retaint by
+default. In the UI these are visible under the DB/Usage Server page
+under the infrastructure menu.
+
+|dbLoadAverages.png|
+
+.. |dbLoadAverages.png| image:: /_static/images/dbLoadAverages.png
+ :alt: load averages as displayed in the UI
+
+The configuration variable 'database.server.stats.interval' can be set
+to change the interval, which is 60 seconds by default.
+
+The value of 'database.server.stats.retention' can be changed to tweak
+the number of values that are maintained.
+
+
Set and Monitor Total VM Limits per Host
----------------------------------------
