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: Peter Brawley
Date: January 12, 2020 02:47PM

cPanel will show you MySQL errors. Most shared hosting providers give you some leeway for adjusting timeouts.

You could run Explain on some of the update queries to see if there's room for optimisation.

Likely it's already occurred to you that your job needs way more resources than you have, at least a dedicated server.

Till then, you're going to have to cut the job into smaller chunks, and stage them at off-peak times.

Edited 1 time(s). Last edit at 01/13/2020 12:27PM by Peter Brawley.

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.