Re: maximum database inserts/second
* 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)
Subject
Views
Written By
Posted
6700
July 19, 2016 12:09AM
Re: maximum database inserts/second
3234
July 20, 2016 09:50AM
2156
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.