MySQL database performance issue. (MyISAM)

Question

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".

This 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
– Explosion Pills, Commented Jan 30, 2013 at 5: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
– Mahendra, Commented Jan 30, 2013 at 6:03
Say 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
– Explosion Pills, Commented Jan 30, 2013 at 6:05
Or you can convert your engine to InnoDB and backup your data to MyISAM. — Mark
– Mark, Commented Jan 30, 2013 at 6:23

Community · Accepted Answer · 2017-05-23 10:31:59Z

1

Read this frist

Basic & the frist thing you can do is index the tables.
You will have to switch MyISAM to InnoDB. Read More
You can Backup the existing data and start from the beginning if possible

Collectives™ on Stack Overflow

MySQL database performance issue. (MyISAM)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related