MySQL Forums
Forum List  »  Performance

Re: Poor insert performance. Is there a problem with my config?
Posted by: Lyle Hopkins
Date: September 28, 2021 11:26AM

One of the insert...selects was on a table that was missing an index for the where column. I changed strategy on those to outfile/infile to avoid that issue.

I did reset the perf after (CALL sys.ps_truncate_all_tables(FALSE)), but it didn't seem to affect that value (and a few others)? I don't know what to do to reset that statistic.

The current usage is atypical of the long term. At this point it's lots of moving data around and breaking up huge 1TB+ tables. I could go up to 512GB RAM in this machine with the 64GB sticks I've been installing, but I'd rather not spend that much at this point if I can help it. Especially as when the usage changes it might not be needed.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Poor insert performance. Is there a problem with my config?
46
September 28, 2021 11:26AM


Sorry, only registered users may post in this forum.

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.