Internal Server Error large table

[fumeeptc]

Hello everyone! I have really big issue i cant solve

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
Structure: http://prntscr.com/jahmue

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

Please help!

[SpacePhoenix]

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

[fumeeptc]

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
ASC LIMIT 1
");
$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){
	$is++;
}
}