You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by nv...@apache.org on 2022/04/26 01:41:56 UTC
[cloudstack-documentation] branch main updated: db load averages explained (#256)
This is an automated email from the ASF dual-hosted git repository.
nvazquez pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudstack-documentation.git
The following commit(s) were added to refs/heads/main by this push:
new 783c1b6 db load averages explained (#256)
783c1b6 is described below
commit 783c1b66c8703eafe09f15f90f68e4ce38c380c8
Author: dahn <da...@gmail.com>
AuthorDate: Tue Apr 26 03:41:52 2022 +0200
db load averages explained (#256)
* db load averages explained
* Update source/adminguide/tuning.rst
Co-authored-by: sureshanaparti <12...@users.noreply.github.com>
* Update source/adminguide/tuning.rst
Co-authored-by: sureshanaparti <12...@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 <ni...@gmail.com>
Co-authored-by: Daan Hoogland <da...@onecht.net>
Co-authored-by: sureshanaparti <12...@users.noreply.github.com>
Co-authored-by: Nicolas Vazquez <ni...@gmail.com>
---
source/_static/images/dbLoadAverages.png | Bin 0 -> 13485 bytes
source/adminguide/tuning.rst | 20 ++++++++++++++++++++
2 files changed, 20 insertions(+)
diff --git a/source/_static/images/dbLoadAverages.png b/source/_static/images/dbLoadAverages.png
new file mode 100644
index 0000000..4a0c62e
Binary files /dev/null and b/source/_static/images/dbLoadAverages.png 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 @@ at `MySQL Reference
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
----------------------------------------