buildmaster/mysql-issues.php: limit to 10k entries per query

1 files changed, 14 insertions, 4 deletions

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)