MySQL Forums :: Performance :: 30 millions reads/day


Advanced Search

Re: 30 millions reads/day
Posted by: Rick James ()
Date: July 29, 2016 07:03PM

That's a few hundred reads per second. Not bad.

I could show you a database that could handle 300M per day. I could show you a different one that is struggling with 300 per day. We need more info before we can help you.

What kind of data? What kind of queries? How often is the data changing? Are the reads reading 1 row (hopefully) or a million rows each (this won't fly)? Can you provide usable indexes for the reads? Etc.

Options: ReplyQuote


Subject Views Written By Posted
30 millions reads/day 565 Srinivas K 07/29/2016 05:34AM
Re: 30 millions reads/day 278 Rick James 07/29/2016 07:03PM
Re: 30 millions reads/day 288 james wang 08/04/2016 05:15AM


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.