Next Previous Contents

4. Priority tables

There is only one default priority table, for Quality of Service (QoS), and one meta table for how to determine the priority for any one job given the user/group/account the job is running as! This is similar to the policy table above.

4.1 prio_qos

mysql> desc prio_qos;
+-------+-----------+------+-----+---------+-------+
| Field | Type      | Null | Key | Default | Extra |
+-------+-----------+------+-----+---------+-------+
| auth  | char(255) |      | PRI |         |       |
| def   | int(11)   |      |     | 0       |       |
| max   | int(11)   |      |     | 0       |       |
+-------+-----------+------+-----+---------+-------+

Example values you might see in the table:

mysql> select * from prio_qos limit 5;
+----------+------+------+
| auth     |  def |  max |
+----------+------+------+
| steviek  | -666 | -666 |
| frankg   |    0 |   69 |
| testhelp |    0 |    0 |
| genieb   |    0 |    0 |
| testfoo  |    5 |    5 |
+----------+------+------+

4.2 prio_qos_auth

For each user, given a job, this table controls the calculation of QoS priority based on an arrangement of the values in the prio_qos table. We specify here whether we are logical ANDing or logical ORing the values from the prio_qos table for the user, group, and account that the job in consideration is running as.

+----------------+----------------------------+------+-----+-----------------+-------+
| Field          | Type                       | Null | Key | Default         | Extra |
+----------------+----------------------------+------+-----+-----------------+-------+
| uuser          | char(64)                   |      | PRI |                 |       |
| prio_qos_order | enum('AND','OR')           |      |     | OR              |       |
| prio_qos_auth  | set('user','group','acct') |      |     | user,group,acct |       |
+----------------+----------------------------+------+-----+-----------------+-------+

Example values you might see in the table:

mysql> select * from prio_qos_auth limit 5;
+----------+----------------+-----------------+
| uuser    | prio_qos_order | prio_qos_auth   |
+----------+----------------+-----------------+
| steviek  | OR             | user,group,acct |
| frankg   | OR             | user,group,acct |
| testhelp | OR             | user,group,acct |
| genieb   | OR             | user,group,acct |
| testfoo  | OR             | user,group,acct |
+----------+----------------+-----------------+


Next Previous Contents