Re: server on development machine
Posted by: Peter Brawley
Date: July 01, 2021 10:27AM

Okeh, innodb_buffer_pool_size is now 24G. What are the sizes of your import files?

The united_claims table has a huge column count because it's a normalisation disaster (eg child tables implemented as col1,col2,col3...). Still, import ought not to take hours. The second table, though, doesn't raise such issues. How long does that import take, and how many rows are taken in?

Unfortunately your privacy protection tweaks rendered the import data unusable, so I can't test it.

Options: ReplyQuote

Written By
Re: server on development machine
July 01, 2021 10:27AM

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.