Re: Poor insert performance. Is there a problem with my config?

[Peter Brawley]

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.