Fischglas

User Tools

Site Tools

Trace: • x11-selection
project:mem-query

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
project:mem-query [2016/01/28 22:19] – created 91.89.129.106project:mem-query [2016/01/28 22:35] (current) – 91.89.129.106
Line 1: Line 1:
-===== mem-query ======+====== mem-query ======
  
 mem-query is a monitoring and recording tool. mem-query is a monitoring and recording tool.
Line 7: Line 7:
 p.e. post mortem analysis.  p.e. post mortem analysis. 
  
-===== prereq ======+===== Ver. 2016-01-28 (sketchy documentation, untestet, **there *be* dragons** ===== 
 + 
 +==== prereq =====
  
   * web server with _enabled_ cgi capabilities   * web server with _enabled_ cgi capabilities
Line 19: Line 21:
   * mysql 5   * mysql 5
  
-===== the database ======+==== the database =====
  
 create a database user password, e.g. create a database user password, e.g.
Line 30: Line 32:
  
 <code> <code>
- create database sysstat; +        create database sysstat; 
- grant all privileges on sysstat.* to user sysstat identified by ("<password-goes-here>"); +        grant all privileges on sysstat.* to user sysstat identified by ("<password-goes-here>"); 
- use sysstat;+        use sysstat;
  
         create table t_mem (         create table t_mem (
Line 80: Line 82:
 </code> </code>
  
-===== the gatherer ======+==== the gatherer =====
  
-<file name=log_mem>+<file txt log_mem>
 #!/usr/bin/perl #!/usr/bin/perl
  
Line 182: Line 184:
 (maybe from /etc/rc.local) (maybe from /etc/rc.local)
  
-===== web =====+==== web ====
  
 get the executable from: get the executable from:
Line 199: Line 201:
 (yup, it renders itself into a web page) (yup, it renders itself into a web page)
  
-  * take a close look into the comment section of the script, it's your user guide.+  * take a close look into the comment section of the script, it's **your user guide**.
   * change the variable $xmlfilename to a place that suits you.   * change the variable $xmlfilename to a place that suits you.
   * create a config file:   * create a config file:
  
-<file name=mem-query.xml>+<file txt mem-query.xml>
 <applicationconfig application="mem-query"> <applicationconfig application="mem-query">
-        <username value="sysstat" /> +         <username value="sysstat" /> 
-        <password value="betLijRekAwyutRa" /> +         <password value="betLijRekAwyutRa" /> 
-        <database value="sysstat" /> +         <database value="sysstat" /> 
-        <databasehost value="db01.intern" />+         <databasehost value="db01.intern" />
 </applicationconfig> </applicationconfig>
-</code>+</file>
  
   * store the config file to the place in $xmlfilename   * store the config file to the place in $xmlfilename
-  * change the password tags attribute value to your password.+  * change the password tag's attribute value to your password.
   * make sure your web server finds that thing   * make sure your web server finds that thing
  
project/mem-query.1454015962.txt.gz · Last modified: 2016/01/28 22:19 by 91.89.129.106