MySQL Forums
Forum List  »  PHP

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data
Posted by: Max Resnikoff
Date: January 12, 2020 01:45PM

My Appologies; 504 Gateway Time-out | nginx

There are no errors thrown apart from timeouts.

I am on a shared server and apparently changing the timeout is not possible unless we upgrade to a dedicated server.

Under mysqlnd in phpInfo:
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
default_socket_timeout 20

On server details:
PHP Version 5.3.26
MySQL Version 5.6.36-82.1
Architecture x86_64
Operating System linux

2 CPU Cores, CentOS, 4GB RAM, 40GB SSD

In PHPMyAdmin, under CPU Usage (whilst actively executing the queries) sits at around 40% usage.

As for the final questions, I am unsure as the script is run from PHP not via PHPmyAdmin, so I cannot see it spitting out any errors or messages from the SQL side of things.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.