MySQL Forums
Forum List  »  InnoDB

Re: maximum database inserts/second
Posted by: Rick James
Date: July 20, 2016 09:50AM

* 100 operations/second is usually no problem for InnoDB.
* What kind of disk do you have? SSD is likely to be able to handle 1000/sec, but spinning drives may require some careful planing.
* How much data will there be? How much RAM do you have? If all of the data and indexes can be cached in RAM, you have an order of magnitude more capacity.
* Let's look at combining multiple INSERTs into a single statement; this will be faster.
* Let's look at combining SELECTs.
* Let's look at some settings that will trade off crash-safety for speed.

But first please provide
* SHOW CREATE TABLE (even if tentative)
* SELECT -- the likely selects
* INSERT -- what the insert looks like
* How big the table(s) will eventually become
* RAM size
* Total number of INSERTs per second (out of that 1000)

Options: ReplyQuote

Written By
July 19, 2016 12:09AM
Re: maximum database inserts/second
July 20, 2016 09:50AM
July 20, 2016 09:55AM

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.