summaryrefslogtreecommitdiff
path: root/buildmaster
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-11-23 10:35:27 +0100
committerErich Eckner <git@eckner.net>2018-11-23 10:35:27 +0100
commit010cfc1ac474d234e842e473b83983e9d2e56585 (patch)
tree647a26413fa36a94d01df5b7ce492af00c61d9d5 /buildmaster
parent97f155c7fad719c7a75842a30e37cd6390f3c0d8 (diff)
downloadarchweb32-010cfc1ac474d234e842e473b83983e9d2e56585.tar.xz
buildmaster/mysql-issues.php: limit to 10k entries per query
Diffstat (limited to 'buildmaster')
-rw-r--r--buildmaster/mysql-issues.php18
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)