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 01:22PM

Hi Peter,
No in normal instance when you say huge ram is 48Gb consider big enough or need more ? How many insert can mysql support per second or per minute?

What I plan to do for the Java Api is to break it into multiple server e.g. one server will host 5000 devices but at the back end it will be just one db server. Any idea on how to test the Java Api and I am planning to use Hikari CP as the connection pooling solution.

Any idea how to simulate around 30K insert. The problem I know bulk insert is faster in my scenario they are all different insert concurrently cause each device will connect send data and close the connection for both socket n db. So there is no room for me to do the bulk inserts. Maybe you may have other work arounds on this?

Options: ReplyQuote


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


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.