Im having online online auction website running live since near about 3 years and still going good. Within 3 years so many auctions has been listed on server and completed too. but now there are a lot of load on server as there are so many completed and live auction on database server. Therefore performance of website is not what it was earlier. What should I do to improve the performance ? All table are created using storage engine "MyISAM".
Asked
Active
Viewed 107 times
0
-
1This depends on a large number of factors. How about archiving a big chunk of the completed auction data so your live DB is smaller? – Explosion Pills Jan 30 '13 at 05:56
-
Thanks for quick response. But I didn't fully understand what you exactly mean by archiving and how to do it? I never come through such situation. Can you please explain in details how to perform archiving ? Can such data will be accessible with same php code later on or I will have to make some changes ? – Mahendra Jan 30 '13 at 06:03
-
1Say your table is called `Auctions`. You can create a table called `AuctionsBackup`. DELETE all rows from `Auctions` that are complete and/or before some date (say 6 months ago) and put them in `AuctionsBackup` just so you don't lose them. You can do this with php of course – Explosion Pills Jan 30 '13 at 06:05
-
1Probably more likely an index issues than anything else.. – Ben Jan 30 '13 at 06:13
-
1Or you can convert your engine to InnoDB and backup your data to MyISAM. – Mark Jan 30 '13 at 06:23
