diff options
| author | Erich Eckner <git@eckner.net> | 2018-11-23 10:35:27 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-11-23 10:35:27 +0100 |
| commit | 010cfc1ac474d234e842e473b83983e9d2e56585 (patch) | |
| tree | 647a26413fa36a94d01df5b7ce492af00c61d9d5 /buildmaster | |
| parent | 97f155c7fad719c7a75842a30e37cd6390f3c0d8 (diff) | |
| download | archweb32-010cfc1ac474d234e842e473b83983e9d2e56585.tar.xz | |
buildmaster/mysql-issues.php: limit to 10k entries per query
Diffstat (limited to 'buildmaster')
| -rw-r--r-- | buildmaster/mysql-issues.php | 18 |
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) |