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 01:16PM

MySQL version?

502 is a gateway error, what exactly is generating it, what are the associated error messages from PHP and/or MySQL and/Apache or whatever?

What are the PHP and MySQL timeout settings?

How much RAM does MySQL have? Is the MySQL swapping? What is innodb_buffer_pool_size? What does Explain say about the Update queries? What does Show Engine InnoDB status show during such an update?

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.