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 13, 2020 12:39PM

Not as big as I expected given 50M rows needing updates, but three quarters of your data is in MyISAM tables, that limits optimisability. Let's see ...

select @@innodb_buffer_pool_size/1024/1024, @@key_buffer_size/1024/1024;

and the result of Explain on one of your updates along with the Show Create Table result for its table(s).

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.