Internal Server Error large table

Hello everyone! I have really big issue i cant solve :frowning:

I have linux server
OS: Ubuntu 14
Memory: 2 GB
CPU: 4 Cores (lowest core 1.9)

I have database user_ip where are over 200K rows

when i open page where i can see all ips (there is paging)

page just dies instantly (note it worked well when was about 100K)

This is what i get from error log:

[Tue Apr 24 13:02:00.979239 2018] [fastcgi:error] [pid 1611] (104)Connection reset by peer: [client IP] FastCGI: comm with server "/usr/lib/cgi-bin/php5.fcgi" aborted: read failed, referer: mypage
[Tue Apr 24 13:02:00.979875 2018] [core:error] [pid 1611] [client IP] AH00524: Handler for fastcgi-script returned invalid result code 1, referer: mypage

I could not find the issue and dont know what to do :frowning:

Please help!

Is there a database query being run on that page and if so whatโ€™s the query?

There is this loop

$Query = mysqli_query($main->con, "
SELECT u.ip AS ip, u.statusIP AS statusIP
FROM `user_ip` u 

LEFT JOIN withdraws AS w
ON u.user=w.user

WHERE u.statusIP='0' AND w.status='Pending'
GROUP BY u.ip 
ORDER BY w.time
$is = 0;
$should = mysqli_num_rows($Query);
while($row = mysqli_fetch_array($Query)){
	$CheckIPS = mysqli_fetch_array(mysqli_query($main->con, "SELECT COUNT(id) as TotalSeen FROM `user_ip` WHERE ip='".$row['ip']."'"));
	$Count = $CheckIPS['TotalSeen'];
if($Count > 1){

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.