MySQL Forums
Forum List  »  InnoDB

Re: High concurrency for master and high reading from slave slowing down insert
Posted by: Frwa Onto
Date: June 20, 2017 11:01AM

Dear Peter,
Thank you. I have read this link before http://www.speedemy.com/17-key-mysql-config-file-settings-mysql-5-7-proof/ and following it too. I just read this link too https://www.artfulsoftware.com/infotree/tip.php?id=1506&r=1. So it suggested these values for high insert
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_io_capacity = 5000
but again I also read before some other links on google saying not to set too high till 64 for both write and read io.

1.What else can I do to managed these days cause my data I cant do bulk insert because mine is a java socket keep getting data on single unit? In best case how many inserts can I achieve in normal scenario at per minute for Innodb ?
2.I read the percona guys claims could achieve even up to few hundred thousand but when the database itself is having huge that this will difficult right?
3. Will replication help with my read or should I drop that idea too?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: High concurrency for master and high reading from slave slowing down insert
104
June 20, 2017 11:01AM


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.