| Table of Contents |
|---|
Accesso al database
...
| Code Block |
|---|
[root@cld-acct ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands 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`:
| Code Block |
|---|
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`:
| Code Block |
|---|
MariaDB [apel]> select SUM(WallDuration * CpuCount) from VCloudSummaries where VO="Kafka-test" AND year="2023" AND month="7"; +------------------------------+ | SUM(WallDuration * CpuCount) | +------------------------------+ | 2938016 | +------------------------------+ |
...