Per vedere quanto ha consumato un certo progetto (es. Kafka-test" in termini di wallclocktime (in secondi) in un certo periodo (es. Luglio 2023) la query e`:
| Code Block |
|---|
[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
MariaDB [apel]>
MariaDB [apel]> select SUM(WallDuration * CpuCount) from VCloudSummaries where VO="Kafka-test" AND year="2023" AND month="7";
+------------------------------+
| SUM(WallDuration * CpuCount) |
+------------------------------+
| 2938016 |
+------------------------------+ |