MySQL Forums
Forum List  »  Performance

Performance - Newbie
Posted by: Deepak Goel
Date: June 24, 2021 02:17PM

Hello

I have a fairly simple database (10 tables) and there are simple queries being fired at it (read and insert).

A few days back we started with a few thousand records. The query times were in msec.

Today, due to load there were about 200,000 records in the database. The query time have shot up to about 10 seconds.

I am expecting the number of records to go to a few million in the next couple of days. The query times would also shoot up (and probably go upto 50 secs and more)

There is plenty of hardware available. So how do I go about performance-tuning this setup (and the query response time stays in msec even if the database record size goes up to 25 million)

Any pointers.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance - Newbie
176
June 24, 2021 02:17PM
71
June 24, 2021 02:52PM


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.