MySQL :: Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

New Topic

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).

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Max Resnikoff

January 12, 2020 11:58AM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Peter Brawley

January 12, 2020 01:16PM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Max Resnikoff

January 12, 2020 01:45PM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Peter Brawley

January 12, 2020 02:47PM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Max Resnikoff

January 13, 2020 03:54AM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Peter Brawley

January 13, 2020 10:55AM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Max Resnikoff

January 13, 2020 11:10AM

Re: Best Way to update multiple rows, in multiple tables, with different data, containing over 50 million rows of data

Peter Brawley

January 13, 2020 12:39PM

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.