From 6512791afab431d0477f6241de1d46f3398ba7d7 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 10 May 2022 16:03:00 +0200
Subject: [statistics] Only suggest clients with SSD for ID45 partition

---
 modules-available/statistics/pages/hints.inc.php | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'modules-available/statistics/pages')

diff --git a/modules-available/statistics/pages/hints.inc.php b/modules-available/statistics/pages/hints.inc.php
index 67c42a18..6ef2490e 100644
--- a/modules-available/statistics/pages/hints.inc.php
+++ b/modules-available/statistics/pages/hints.inc.php
@@ -105,9 +105,11 @@ class SubPage
 		}
 		$q->addMachineColumn('clientip');
 		$q->addMachineColumn('hostname');
-		$q->addLocalColumn('unused')->addCondition('>', 25000000000); // 25 GB
+		$q->addLocalColumn('unused')->addCondition('>', 50000000000); // 50 GB
 		$q->addMachineWhere('id44mb', '>', 20000); // 20 GB
 		$q->addMachineWhere('id45mb', '<', 20000); // 20 GB
+		// Only suggest SSD based systems, caching on spinning rust is usually slower than GBit
+		$q->addGlobalColumn('rotation_rate')->addCondition('=', 0);
 		foreach ($q->query()->fetchAll() as $row) {
 			$row['unused_s'] = Util::readableFileSize($row['unused']);
 			$row['id44mb_s'] = Util::readableFileSize($row['id44mb'], -1, 2);
-- 
cgit v1.2.3-55-g7522