Ganga Usage Statistics Monitoring

# ssh root@gangamon
[root@gangamon ~]# su - monal
To start/stop ml server type:
~/MonalisaGanga/Service/CMD/start_webml.sh
~/MonalisaGanga/Service/CMD/stop_webml.sh

To extract CSV data use the script MonalisaGanga/CSV/GangaCSV.py

Emergency DB access

/data/monal/MonalisaGanga/Service/myFarm/pgsql > ./console.sh

mon_data=> \dp
               Access privileges for database "mon_data"
 Schema |             Name              |   Type   | Access privileges 
--------+-------------------------------+----------+-------------------
 public | abping                        | table    | 
 public | abping_aliases                | table    | 
 public | abping_aliases_extra          | table    | 
 public | annotation_groups             | table    | 
 public | annotation_groups_ag_id_seq   | sequence | 
 public | annotations                   | table    | 
 public | annotations_a_id_seq          | sequence | 
 public | colors                        | table    | 
 public | hidden_sites                  | table    | 
 public | monitor_ids                   | table    | 
 public | monitor_n_conf                | table    | 
 public | monitor_s_10hour              | table    | 
 public | monitor_s_10hour_backup_rrd   | table    | 
 public | monitor_s_1year               | table    | 
 public | monitor_s_1year_backup_rrd    | table    | 
 public | monitor_s_e_10hour            | table    | 
 public | monitor_s_e_10hour_backup_rrd | table    | 
 public | monitor_s_e_1year             | table    | 
 public | monitor_s_e_1year_backup_rrd  | table    | 
 public | monitor_tables                | table    | 
 public | monitor_tables_onlinetime     | table    | 
 public | saved_bprevdata               | table    | 
(22 rows)

mon_data=> select count (*) from monitor_s_1year;
mon_data=> select count (*) from monitor_s_e_1year;

mon_data=> select * from monitor_s_1year where rectime=1234781774735;
mon_data=> select * from monitor_s_e_1year where rectime=1234781774735;

pcarda75: adjust the memory parameters to start the postgres server


moscicki@pcarda75 /data/gangamon_data_AFTER_CRASH/data/monal/MonalisaGanga/Service/myFarm/pgsql >diff data/postgresql.conf*
61c61
< max_connections = 50			# (change requires restart)
---
> max_connections = 100			# (change requires restart)
104c104
< shared_buffers = 4MB			# min 128kB or max_connections*16kB
---
> shared_buffers = 32MB			# min 128kB or max_connections*16kB

update the config file /data/gangamon_data_AFTER_CRASH/data/monal/MonalisaGanga/Service/CMD/ml_env

-- JakubMoscicki - 11 Mar 2008

Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r5 - 2009-12-16 - JakubMoscicki
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    ArdaGrid All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback