...
Accesso al database
| Code Block |
|---|
[root@cld-acct ~]# mysql$ mysql --host cld-acct.pd.infn.it -u rootapelro -p apel Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. CommandsCommands end with ; or \g. Your MariaDB connection id is 275462 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 |
Record di accounting per un certo anno
...
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 |
+------------------------------+ |
...