MySQL Forums
Forum List  »  Performance

Re: Poor insert performance. Is there a problem with my config?
Posted by: Peter Brawley
Date: September 24, 2021 12:19PM

Optimise slow queries then turn off the general and slow query logs. Do you need the binary log eg for replication?

All these Inserts are on InnoDB tables?

Run Flush Status, then one of your big inserts, then calculate ...

( Innodb_pages_read + Innodb_pages_written + Innodb_dblwr_writes + Innodb_buffer_pool_pages_flushed ) / Uptime_since_flush_status

See https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/innodb-configuring-io-capacity.html for how to tune i/o capacity. Interesting also: https://dba.stackexchange.com/questions/212884/innodb-after-48-hours-of-optimizing-10mb-sec-write-speed

Consider running the "cheatsheet" sequence described under that title at https://www.artfulsoftware.com/infotree/mysqltips.php, posting the result here inside BBCode code tags.



Edited 3 time(s). Last edit at 09/24/2021 12:39PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Poor insert performance. Is there a problem with my config?
68
September 24, 2021 12:19PM


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.