MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Poor insert performance. Is there a problem with my config?
251
Lyle Hopkins
September 23, 2021 04:05PM
Re: Poor insert performance. Is there a problem with my config?
68
Peter Brawley
September 24, 2021 12:19PM
Re: Poor insert performance. Is there a problem with my config?
147
Lyle Hopkins
September 28, 2021 05:35AM
Re: Poor insert performance. Is there a problem with my config?
41
Peter Brawley
September 28, 2021 10:58AM
Re: Poor insert performance. Is there a problem with my config?
46
Lyle Hopkins
September 28, 2021 11:26AM


Sorry, only registered users may post in this forum.
Click here to login

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.