You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Accesso al database 


[root@cld-acct ~]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 275
Server version: 10.1.20-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [apel]> use apel;
Database changed


WallClocktime consumato da un certo progetto in un certo anno


Per vedere quanto ha consumato un certo progetto (es. Kafka-test" in termini di wallclocktime (in secondi)  in un certo anno (es. 2023) la query e`:



MariaDB [apel]> select SUM(WallDuration * CpuCount) from VCloudSummaries where VO="Kafka-test" AND year="2023";
+------------------------------+
| SUM(WallDuration * CpuCount) |
+------------------------------+
|                    128016664 |
+------------------------------+
1 row in set (0.01 sec)

MariaDB [apel]> 


WallClocktime consumato da un certo progetto in un certo mese


Per vedere quanto ha consumato un certo progetto (es. Kafka-test" in termini di wallclocktime (in secondi)  in un certo mese (es. Luglio 2023) la query e`:




MariaDB [apel]> select SUM(WallDuration * CpuCount) from VCloudSummaries where VO="Kafka-test" AND year="2023" AND month="7";
+------------------------------+
| SUM(WallDuration * CpuCount) |
+------------------------------+
|                      2938016 |
+------------------------------+
  • No labels