MySQL Forums
Forum List  »  InnoDB

maximum database inserts/second
Posted by: salim said
Date: July 19, 2016 12:09AM

I am working on a php project that is expected to have 1,000 active users at any instance and i am expecting 1,000 inserts or selects per second.

The question is, if my table uses innoDB Engine and suppose i do not use Transactions,e.t.c to achieve better performance, what is the maximum number of concurrent reads/writes that an innoDB table can handle per second ?

I have 1 table containing 5 columns with 1 index column.

Options: ReplyQuote


Subject
Views
Written By
Posted
maximum database inserts/second
4223
July 19, 2016 12:09AM
2094
July 20, 2016 09:50AM
1462
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.