Next Previous Contents

6. Job accounting

There are 4 job accounting tables: job, job_timings, job_vars, job_blob_vars.

6.1 job

Generic job variables.

mysql> desc job;
+-------------+-----------------------------------------+------+-----+-----------+----------------+
| Field       | Type                                    | Null | Key | Default   | Extra          |
+-------------+-----------------------------------------+------+-----+-----------+----------------+
| jid         | int(10) unsigned                        |      | PRI | NULL      | auto_increment |
| job_id      | char(255)                               |      | MUL |           |                |
| state       | enum('Completed','Cancelled','Errored') |      |     | Completed |                |
| submit_auth | char(64)                                |      |     |           |                |
| uuser       | char(64)                                |      | MUL |           |                |
| ugroup      | char(64)                                |      |     |           |                |
| account     | char(255)                               |      | MUL |           |                |
+-------------+-----------------------------------------+------+-----+-----------+----------------+

Example values you might see in the table:

mysql> select * from job limit 5;
+-------+-------------------------+-----------+-------------+----------+--------+----------------+
| jid   | job_id                  | state     | submit_auth | uuser    | ugroup | account        |
+-------+-------------------------+-----------+-------------+----------+--------+----------------+
|     5 | steviek:983590329:473   | Cancelled | root        | steviek  | adminz | no-account     |
| 18254 | frankg:1012573809:16    | Completed | frankg      | frankg   | adminz | FOOBA-R900-444 |
| 18255 | testhelp:1012584768:17  | Completed | testhelp    | testhelp | userz  | TESTF-9998-S00 |
| 18256 | genieb:1012588320:21    | Completed | genieb      | genieb   | userz  | VIPPP-9999-S99 |
| 18429 | testfoo:1012592626:941  | Cancelled | testfoo     | testfoo  | userz  | 31337-H4X0-R69 |
+-------+-------------------------+-----------+-------------+----------+--------+----------------+

6.2 job_timings

The job timings.

mysql> desc job_timings;
+--------------------+------------------+------+-----+---------+-------+
| Field              | Type             | Null | Key | Default | Extra |
+--------------------+------------------+------+-----+---------+-------+
| jid                | int(10) unsigned |      | PRI | 0       |       |
| requested_duration | int(10) unsigned |      |     | 0       |       |
| submit_time        | timestamp(14)    | YES  |     | NULL    |       |
| queue_duration     | int(10) unsigned |      |     | 0       |       |
| start_time         | timestamp(14)    | YES  |     | NULL    |       |
| finish_time        | timestamp(14)    | YES  |     | NULL    |       |
+--------------------+------------------+------+-----+---------+-------+

Example values you might see in the table:

+-------+--------------------+----------------+----------------+----------------+----------------+
|  jid  | requested_duration | submit_time    | queue_duration | start_time     | finish_time    |
+-------+--------------------+----------------+----------------+----------------+----------------+
|     5 |              36000 | 20010305103417 |             19 | 00000000000000 | 00000000000000 |
| 18254 |               3600 | 20020201043009 |              5 | 20020201043014 | 20020201044845 |
| 18255 |             100800 | 20020201073248 |              3 | 20020201073251 | 20020201074938 |
| 18256 |              28800 | 20020201083202 |              5 | 20020201083207 | 20020201090205 |
| 18429 |                360 | 20020201094346 |          22573 | 20020201155959 | 20020201160630 |
+-------+--------------------+----------------+----------------+----------------+----------------+

6.3 job_vars

Extra job variables.

mysql> desc job_vars;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| jid            | int(10) unsigned |      | PRI | 0       |       |
| total_nodes    | int(10) unsigned | YES  |     | NULL    |       |
| total_slots    | int(10) unsigned | YES  |     | NULL    |       |
| qos            | int(11)          |      |     | 0       |       |
| deferral_count | int(10) unsigned |      |     | 0       |       |
+----------------+------------------+------+-----+---------+-------+

Example values you might see in the table:

mysql> select * from job_vars limit 5;
+-------+-------------+-------------+-----+----------------+
| jid   | total_nodes | total_slots | qos | deferral_count |
+-------+-------------+-------------+-----+----------------+
|     5 |        NULL |        NULL |   0 |           5137 |
| 18254 |           4 |           8 |  68 |              0 |
| 18255 |          64 |         128 |   0 |              0 |
| 18256 |           1 |           2 |   0 |              0 |
| 18429 |          64 |          64 |   0 |              0 |
+-------+-------------+-------------+-----+----------------+

6.4 job_blob_vars

Extra job "BLOB" variables. These can be very large.

mysql> desc job_blob_vars;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| jid               | int(10) unsigned |      | PRI | 0       |       |
| cmd               | blob             |      |     |         |       |
| envp              | blob             |      |     |         |       |
| features          | blob             | YES  |     | NULL    |       |
| geometry          | blob             |      |     |         |       |
| resource_managers | blob             | YES  |     | NULL    |       |
| slots             | blob             | YES  |     | NULL    |       |
+-------------------+------------------+------+-----+---------+-------+


Next Previous Contents