Changeset 30644

Timestamp:

Feb 15, 2011, 4:35:49 PM (15 years ago)

Author:

watersc1

Message:

Rank by deviation from average value. This eliminates the extra ranking involved with R. I'm not sure that the R ranking was really helping us that much.

File:

• trunk/Nebulous-Server/bin/neb-admin (modified) (2 diffs)

trunk/Nebulous-Server/bin/neb-admin

@@ -312 +312 @@
       SELECT mountedvol.vol_id,mountedvol.name,mountedvol.available,mountedvol.allocate,total,used,
              (used / total) AS D,total * ((used / total) - $average ) AS R,  -- average
+             (used / total) - $average AS delta,
              cab_id FROM
       mountedvol JOIN volume USING(vol_id)
       WHERE mountedvol.available = 1
-      ORDER BY R DESC LIMIT $balance_N_sources                                            -- N
+      ORDER BY delta DESC LIMIT $balance_N_sources                                            -- N
       ) AS ranked_sources
       -- Z End
@@ -337 +338 @@
    SELECT mountedvol.vol_id,mountedvol.name,mountedvol.host,mountedvol.available,mountedvol.allocate,total,used,
           (used / total) AS D,total * ((used / total) - $average ) AS R,  -- average
+          (used / total) - $average AS delta,
           cab_id FROM
    mountedvol JOIN volume USING(vol_id)
    WHERE mountedvol.available = 1 AND mountedvol.allocate = 1
-   ORDER BY R ASC LIMIT $balance_M_destinations                                               -- M
+   ORDER BY delta ASC LIMIT $balance_M_destinations                                               -- M
   ) AS ranked_destinations
   -- Z2 End