Next Previous Contents

7. Sys reservation accounting

There are 4 sysres accounting tables: sysres, sysres_timings, sysres_vars, sysres_blob_vars.

7.1 sysres

The sys reservation main table.

mysql> desc sysres;
+-------------+--------------------------------+------+-----+---------+----------------+
| Field       | Type                           | Null | Key | Default | Extra          |
+-------------+--------------------------------+------+-----+---------+----------------+
| rid         | int(10) unsigned               |      | PRI | NULL    | auto_increment |
| res_id      | char(255)                      |      | MUL |         |                |
| submit_auth | char(64)                       |      | MUL | system  |                |
| auth_type   | enum('user','group','account') |      |     | user    |                |
| auth        | char(255)                      |      | MUL |         |                |
+-------------+--------------------------------+------+-----+---------+----------------+

Example values you might see in the table:

mysql> select * from sysres limit 5;
+-----+----------------------------+-------------+-----------+--------+
| rid | res_id                     | submit_auth | auth_type | auth   |
+-----+----------------------------+-------------+-----------+--------+
|   1 | group:adminz:983579769:0   | mauid       | group     | adminz |
|   2 | group:adminz:984875100:0   | root        | group     | adminz |
|   3 | user:frankg:984875252:1    | root        | user      | frankg |
|   4 | user:genieb:998698714:0    | mauid       | user      | genieb |
|   5 | group:adminz:998972755:1   | root        | group     | adminz |
+-----+----------------------------+-------------+-----------+--------+

7.2 sysres_timings

The sysres timings.

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

Example values you might see in the table:

mysql> select * from sysres_timings limit 5;  
+-----+--------------------+----------------+----------------+----------------+
| rid | requested_duration | submit_time    | start_time     | finish_time    |
+-----+--------------------+----------------+----------------+----------------+
|   1 |              43200 | 20010302143609 | 00000000000000 | 20010316100431 |
|   2 |              86400 | 20010317142500 | 20010317000000 | 20010317142719 |
|   3 |              86400 | 20010317142732 | 20010317000000 | 20010317150602 |
|   4 |              43200 | 20010824141834 | 00000000000000 | 20010825103127 |
|   5 |              43200 | 20010827182555 | 00000000000000 | 20010830133013 |
+-----+--------------------+----------------+----------------+----------------+

7.3 sysres_vars

Extra sysres variables.

mysql> desc sysres_vars;
+-------------+------------------+------+-----+---------+-------+
| Field       | Type             | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| rid         | int(10) unsigned |      | PRI | 0       |       |
| total_nodes | int(10) unsigned |      |     | 0       |       |
| total_slots | int(10) unsigned |      |     | 0       |       |
+-------------+------------------+------+-----+---------+-------+

Example values you might see in the table:

mysql> select * from sysres_vars limit 5;   
+-----+-------------+-------------+
| rid | total_nodes | total_slots |
+-----+-------------+-------------+
|   1 |         256 |         512 |
|   2 |          88 |         176 |
|   3 |          80 |         160 |
|   4 |         256 |         512 |
|   5 |         256 |         512 |
+-----+-------------+-------------+

7.4 sysres_blob_vars

Extra sysres "BLOB" variables.

mysql> desc sysres_blob_vars;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| rid               | int(10) unsigned |      | PRI | 0       |       |
| slots             | blob             | YES  |     | NULL    |       |
| resource_managers | blob             |      |     |         |       |
+-------------------+------------------+------+-----+---------+-------+


Next Previous Contents