database access is getting slow day by day

Reply

Join Date: Aug 2005
Posts: 3
Reputation: cqd is an unknown quantity at this point 
Solved Threads: 0
cqd cqd is offline Offline
Newbie Poster

database access is getting slow day by day

 
0
  #1
Aug 10th, 2005
Hi everybody
Hope I will get some help here. I have been using mysql database for quite sometime and had no problem till now. This database is either upgraded nor any change in the indexing, its been as it was from past one year. But recently we have observed that the database access has gone real slow. Even this system hasnt been upgraded, but even the preformance what it had before with database accessing has reduced.
Is there anything you guys can suggest to improve the performance ?
Reply With Quote Quick reply to this message  
Join Date: Jul 2005
Posts: 29
Reputation: jingalala is an unknown quantity at this point 
Solved Threads: 0
jingalala jingalala is offline Offline
Light Poster

Re: database access is getting slow day by day

 
0
  #2
Aug 10th, 2005
Have you defragmented lately? Its possible that the database has got badly fragmented, in which case the time taken to access files would be more. If this is reason, you could go in for a automatic third paty tool with advanced features that can be scheduled to run without interrupting other processes and will check fragmentation on a daily basis.
Reply With Quote Quick reply to this message  
Join Date: Jan 2005
Posts: 294
Reputation: zippee is an unknown quantity at this point 
Solved Threads: 6
zippee's Avatar
zippee zippee is offline Offline
Posting Whiz in Training

Re: database access is getting slow day by day

 
0
  #3
Aug 11th, 2005
Are you using shared server?? If yes, then it may be other users who shared the same server having high traffic that affect your site's performance (unless the server has load balancing feature installed).
Ecommerce-Web-Store.com Building Your e-Business.
Reply With Quote Quick reply to this message  
Join Date: Aug 2005
Posts: 3
Reputation: cqd is an unknown quantity at this point 
Solved Threads: 0
cqd cqd is offline Offline
Newbie Poster

Re: database access is getting slow day by day

 
0
  #4
Aug 11th, 2005
Hi thanks a lot for all your suggestions.
Jingalala.. I owe you a beer. Defragging the drive did increase the performance of the server to a large extent.

zippe.. its a single server and not used by others... and as I mentioned its not being modified for long time but its been used everyday.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MySQL Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC