MySQL Forums
Forum List  »  Optimizer & Parser

Large database
Posted by: Omar Khan
Date: January 12, 2007 07:45AM

Hello,

We have our database running on remote dedicated machine with following specifications,

P4
2.6Ghz
Cache size 1024
RAM: 768
OS: CentOS

And we are access it (i.e. frontend) using ASP. Our database has been grown to 2 to 3 million records and we are experiencing too much delay in page load. The queries in the page are quiet simple one (i.e. without any joins). The average page load time has increased to 10 to 25sec.

I read few tutorials about Mysql tweeking, almost all of them suggested increasing max. threads, query buffer size and different caches. We tried doing it but didnt find much change and we concluded it might be due to a fact that out data gets updated every 10 to 15 minutes.

Any specific hardware upgrade we require? or mysql server specific optimization?

Thanks
Omar

Options: ReplyQuote


Subject
Views
Written By
Posted
Large database
3443
January 12, 2007 07:45AM
2184
February 09, 2007 01:42AM
2031
February 14, 2007 06:55AM
2193
February 14, 2007 06:47PM
2088
February 15, 2007 05:35AM
2213
February 15, 2007 05:13PM


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.