From 010cfc1ac474d234e842e473b83983e9d2e56585 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 23 Nov 2018 10:35:27 +0100
Subject: buildmaster/mysql-issues.php: limit to 10k entries per query

---
 buildmaster/mysql-issues.php | 18 ++++++++++++++----
 1 file changed, 14 insertions(+), 4 deletions(-)

(limited to 'buildmaster/mysql-issues.php')

diff --git a/buildmaster/mysql-issues.php b/buildmaster/mysql-issues.php
index 292ba3f..7c3701c 100644
--- a/buildmaster/mysql-issues.php
+++ b/buildmaster/mysql-issues.php
@@ -23,6 +23,8 @@ require_once BASE . "/lib/mysql.php";
     <a href="https://buildmaster.archlinux32.org/">Start page</a><br>
 <?php
 
+  $limit = 10001;
+
   $result = mysql_run_query(
     "SELECT CONCAT(" .
     "`r_a`.`name`,\"/\"," .
@@ -78,10 +80,14 @@ require_once BASE . "/lib/mysql.php";
     "`binary_packages_in_repositories`.`is_to_be_deleted`," .
     "`repositories`.`name`," .
     "`binary_packages`.`pkgname`," .
-    "`install_targets`.`name`"
+    "`install_targets`.`name`" .
+    $limit
   );
 
-  print "    Found " . $result -> num_rows . " serious issues.<br>\n";
+  if ($result -> num_rows > 10000)
+    print "    Found >10000 serious issues.<br>\n";
+  else
+    print "    Found " . $result -> num_rows . " serious issues.<br>\n";
 
   while ( $row = $result -> fetch_assoc() ) {
     if ($row["is_to_be_deleted"]==1)
@@ -155,10 +161,14 @@ require_once BASE . "/lib/mysql.php";
       ")" .
     ")" .
     $ignore .
-    " ORDER BY `binary_packages_in_repositories`.`is_to_be_deleted`,`binary_packages`.`pkgname`,`install_targets`.`name`"
+    " ORDER BY `binary_packages_in_repositories`.`is_to_be_deleted`,`binary_packages`.`pkgname`,`install_targets`.`name`" .
+    $limit
   );
 
-  print "    Found " . $result -> num_rows . " stability issues.<br>\n";
+  if ($result -> num_rows > 10000)
+    print "    Found >10000 stability issues.<br>\n";
+  else
+    print "    Found " . $result -> num_rows . " stability issues.<br>\n";
 
   while ( $row = $result -> fetch_assoc() ) {
     if ($row["is_to_be_deleted"]==1)
-- 
cgit v1.2.3